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.
Specification: Google Apps Script Spreadsheet Emailer Project