Google Apps Script Spreadsheet Emailer Project

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……

Please note that JAVASCRIPT KNOWLEDGE is REQUIRED – This is a coding course you can use the source code as is for the functionality but the course is CODING…  Demonstrating how to write Google Apps Script code and create a simple project that can connect G Suite Apps together for advanced and automated functions.

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.