Introduction
This tutorial shows you how to create a mailing list in Google Sheets, then automatically send a personalized email using Google Apps Script. The end result will be a script that will be able to automatically send an email to each address in the list, based on some rules.
While we build this sheet and script, we will:
- Design the mailing list sheet
- Add Services
- Create the script logic for collecting data
- Design Settings sheet
- Create the script logic for sending a personalized email
- Share code as a library
- Explore distribution possibilities
- Use clasp
Prior knowledge & Prerequisites
- A Google account
- A basic understanding of JavaScript (or programming in general)
- A solid understanding of the basics of Google Sheets
