Gmail Mail Merge: Send Personalized Emails from Google Sheets

Sending personalized emails to multiple recipients requires copying templates, manually changing names, and sending individually - a tedious process that doesn't scale. Google Sheets mail merge handles the personalization, but lacks advanced features. This workflow connects Google Sheets directly to Gmail for true mail merge capabilities with custom logic.

What this workflow does

1. A Schedule Trigger runs the workflow (or a manual trigger).
2. A Google Sheets node reads all rows from your contact spreadsheet.
3. A Code node loops through each row, personalizing the email subject and body with data from each row.
4. A Gmail node sends each personalized email to the recipient's address from the sheet.

Setup guide

1. Import the JSON into n8n (Workflows > Import from File).
2. Connect Google Sheets and Gmail (OAuth) in their respective nodes.
3. Replace REPLACE_WITH_SPREADSHEET with your actual Google Sheet ID (from the URL).
4. Update the Code node to map your sheet columns to the email personalization variables.
5. Configure the Schedule Trigger timing or set up the manual trigger for on-demand execution.
6. Test with 2-3 rows first, then run on your full contact list.

FAQ