Mail merge from Google Sheets to Gmail
A mail merge from Google Sheets to Gmail transforms spreadsheet rows into personalised, individual emails sent directly from your own Gmail address. By pairing clean spreadsheet data with flexible merge tags, you can conduct thoughtful outreach at scale without sacrificing authenticity.
Last reviewed: 04/11/2026 · By MailMerge
Why use Google Sheets as your contact source?
Google Sheets is the most popular database format for small-scale email outreach, recruitment pipelines, and event management. Because it lives natively in the cloud alongside Gmail, syncing contact details, updating notes, and collaborating with team members is frictionless.
When combined with a dedicated mail merge application like MailMerge, your spreadsheet remains your single source of truth. Every row represents one unique recipient, and every column header becomes a dynamic placeholder in your email draft.
How to structure your Google Sheet for mail merge
The secret to an error-free mail merge is a clean spreadsheet schema. Keep your layout tidy by following these rules:
- Row 1 must be headers only: Do not place title banners, merged headers, or blank rows above your column names.
- Keep header names simple: Use lowercase text or snake_case (e.g.
first_name,company,due_date) instead of sentences or special symbols. - One email address per row: Ensure the primary recipient column contains clean email addresses without surrounding brackets or multiple recipients separated by commas.
| first_name | company | project_name | |
|---|---|---|---|
| Oliver | oliver@example.co.uk | Apex Architecture | Bristol Studio |
| Sarah | sarah@northstar.org.uk | Northstar Digital | Brand Refresh |
| James | james.watson@summit.co.uk | Summit Logistics | Fleet Tracking |
Understanding merge tags and syntax
Merge tags correspond directly to your spreadsheet headers. When drafting your template, enclose the exact column name within double curly braces:
// Example Subject Line
Quick question regarding {{company}} and {{project_name}}
// Example Body
Hi {{first_name}},
I noticed your recent work at {{company}} on the {{project_name}} initiative...
During the merge process, MailMerge matches {{first_name}} to each recipient's corresponding cell in the first_name column.
Common spreadsheet traps to avoid
- Merged cells: Merged cells cause spreadsheet parsers to record blank values for all but the top-left cell. Always unmerge cells before importing.
- Trailing whitespace: Extra spaces before or after email addresses (e.g.
" alex@example.com ") can lead to delivery bounces. Use Google Sheets'=TRIM()function to clean up columns quickly. - Formula errors: Cells displaying
#N/A,#REF!, or#VALUE!will render those error strings directly into recipient emails. Convert formulas to plain text values before running your campaign. - Blank rows: Blank rows mid-sheet can signal the end of data to some tools. Delete empty rows from your range.
Connecting your spreadsheet to Gmail
Once your sheet is formatted, you have two flexible paths to connect it to Gmail:
- Export as CSV (Universal & Private): In Google Sheets, click File > Download > Comma Separated Values (.csv). You can import this directly into MailMerge with no Google Drive permissions required.
- Direct Sheet Link: Connect your Google account so MailMerge reads your active spreadsheet tab in real time.
Because messages are dispatched through your actual Gmail account, your delivery rates benefit from your domain's established reputation, SPF, and DKIM records.
Pre-send verification checklist
- ✓ Row 1 contains concise, unique column headers.
- ✓ No blank values exist in the required
emailcolumn. - ✓ Merge tag names in your template exactly match the column spellings.
- ✓ Recipient count is within your daily Gmail sending limit (500 or 2,000/day).
- ✓ Compliance details and opt-out routes are provided as required by UK GDPR & PECR.
Related guides
Ready to merge your Google Sheet into Gmail?
Import your spreadsheet, write your template, and inspect live previews before sending a single message. Free to start with your standard Gmail account.
Start free mail merge