Google Script Apps Email From Spreadsheet list

Explore how you can create a simple powerful application with Google Apps Script that connects your Google Suite together

Use Google Apps Script to create advanced functions within your spreadsheet

Use the spreadsheet to manage a user list, click the members on the list and send out confirmation emails.  Track emails that have been sent.  Create your own custom HTML template mail that gets sent to the users on the list.  Use the spreadsheet UI menu to add buttons for administration of the spreadsheet data.  You will be amazed at how easy it is to create powerful functionality that helps power up your Google Suite of products.

JavaScript is a prerequisite to this course.

Course covers applying Google Apps Script to build a project application.

Add items to the spreadsheet UI menu that can trigger functions in Google Apps Script

Select user active cell content from the spreadsheet

Create HTML template to send email

Use Alerts to accept user actions

Update values of the spreadsheet data

Select ranges and update content in the range

Get content from the spreadsheet

Send email from Google Apps Script

Google Script Apps Email From Spreadsheet list Source code is included so you can copy and paste the code to try for yourself.