Personalized Email Mail Merge with Google Sheets and Gmail

This workflow connects Google Sheets with Gmail to enable two powerful email automation modes: bulk mail merge for sending personalized emails to multiple recipients using sheet data, and triggered emails that fire automatically when specific sheet conditions are met, such as row updates or new entries.

Ideal for marketers running campaigns, recruiters outreach from candidate lists, small business owners for automated follow-ups, and anyone managing event updates or dynamic lists. It eliminates manual copying, pasting, or app-switching, saving hours on repetitive tasks while ensuring professional, customized communications.

Setup is straightforward: copy the provided Google Sheets template, connect your accounts in n8n, select your spreadsheet and sheet, customize email subject/body with variables like names or links, test the workflow, and activate for hands-free operation. Includes a YouTube video guide for quick implementation.

Requirements are minimal: a Google Sheets account with organized data, a Gmail account, and an n8n instance. This delivers high business value through seamless integration and scalability for growing email needs.