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