What This Workflow Does
This automation solves the tedious problem of sending personalized emails to multiple recipients from data in Google Sheets. Instead of manually copying information or using expensive email marketing tools, this workflow connects directly to your Gmail account to send messages with data pulled from your spreadsheet.
The system handles all the heavy lifting - it processes each row in your sheet, inserts the personalized content into your email template, and sends the messages through your Gmail account. You maintain full control over the content while eliminating hours of repetitive work.
How It Works
Step 1: Spreadsheet Setup
Your Google Sheet serves as the data source, containing recipient emails and personalized content. The first row should contain column headers that will be referenced in your email template.
Step 2: Email Template Configuration
Create your email template in n8n using HTML or plain text. Insert merge tags that correspond to your spreadsheet column headers wherever personalized content should appear.
Step 3: Authentication
>The workflow connects to both your Google Sheets and Gmail accounts using OAuth. You'll authorize access just once during setup, and the system will maintainsthe connection securely.
Step 4: Execution
When triggered, the workflow reads your spreadsheet, processes each row, generates personalized emails, and sends them through your Gmail account with your signature and branding.
Who This Is For
This workflow benefits any business or professional who regularly sends batches of personalized emails. Ideal users include:
HR teams sending onboarding materials, sales professionals conducting outreach campaigns, educators communicating with students, and small businesses managing customer relationships without expensive CRM software.Pro tip: Use separate sheets for different email campaigns to maintain organization and make updates easier.
What You'll Need
- A Google account with access to both Sheets and Gmail
- n8n account (free or paid version)
- Basic spreadsheet with recipient data (emails, names, etc.)
- Email template content (can be HTML or plain text)
Quick Setup Guide
- Download and import the JSON template into your n8n workspace
- Connect your Google Sheets and Gmail accounts via OAuth
- Specify your spreadsheet ID and worksheet name
- Customize the email template with your content and merge tags
- Test with a small batch before full deployment
Key Benefits
Save 5-10 hours per month by eliminating manual email processes and copy-paste work.
Reduce errors by 90% compared to manual sending, ensuring correct information goes to each recipient.
Maintain professional branding as emails come directly from your Gmail account with your signature and formatting.
No additional software costs required beyond tools you already use (Google Workspace and n8n).
Scale campaigns easily by simply adding more rows to your spreadsheet when needed.