Google Apps Script Spreadsheet Emailer Project
- 1 hour on-demand video
- 8 articles
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Google Apps Script
- Creating apps with Google Script
- Google Spreadsheet App Class and methods
- Coding experience
- Google Account
Automate sending of emails from your Google Spreadsheet !
Add a UI button in the spreadsheet that will send emails, update the results all within the spreadsheet itself. One of the most asked for functionality for G Suite to use spreadsheet to manage email communications. HERE IT IS......
Source Code is included
Step by step instructions on how to build the project - this is a starter project designed to get you started and then you can customize and extend on what is covered within the lessons.
Setup of Spreadsheet UI Object
Adding buttons to sheet toolbar
Running functions with button click
Permissions for Sheets and emails
Sending HTML email using data from the Spreadsheet
Tracking sent emails
How the Emails look within Gmail
Testing of email app
Taught by an instructor with many years of web development experience ready to help you learn.
Fast friendly support within the Q&A section.
Start building your own version of the app - by the end of the course you will have a fully functional application that can send emails from your spreadsheet.
- Anyone using G Suite of products
- Apps Script Developers