Personalized email mail merge from a table
The scenario takes a list from a table, fills each person's data into a template, and sends personalized emails, marking the ones sent.
- Takes the list straight from the table
- Fills each person's data into the email
- Sends a personalized email to each
- Marks sent ones, no duplicates

Google Sheets