Mail Merge Email Templates for Gmail and Google Sheets
Mail merge templates to copy for Gmail and Google Sheets: sales, follow-up, recruiting, event and update emails with merge fields that match your headers.
Mail Merge Email Templates for Gmail and Google Sheets (Copy & Personalize)
Want proven email copy you can fill in and send today? These mail merge templates use merge fields like {{First Name}} that match your Google Sheet column headers, so each recipient gets a personalized message. Paste one into a Gmail draft, and Mail Merge for Gmail and Google Sheets turns it into a personalized campaign in a few clicks.
Try Mail Merge for Gmail and Sheets →
How templates and Sheet columns work together
A merge field is a placeholder wrapped in double braces, like {{First Name}} or {{company}}. When you send, the add-on replaces each placeholder with the matching value from that recipient’s row in your Sheet. So a template stays one Gmail draft, but every recipient sees their own details.
Set up your Sheet columns first
Add one column per placeholder you want to use. A common starter set:
| Column header | Used for | Example value |
|---|---|---|
Email |
recipient address (required, capital E) | [email protected] |
First Name |
greeting + personalization | Jordan |
Last Name |
required header (cells can stay empty) | Lee |
Mail Merge |
status the add-on writes (required) | leave empty |
company |
context | Northwind |
role |
relevance | Operations Lead |
custom_line |
a tailored sentence | we loved your recent launch |
The add-on checks that the first four columns (A–D) are Email, First Name, Last Name and Mail Merge, and Launch creates them if they’re missing. Put your other columns after them.
Match your placeholders to these headers exactly, including case and spaces, and every template below will personalize automatically. A placeholder with no matching column, such as {{sender_name}} or {{event_link}}, is sent as literal text, so add those columns too or replace them with plain text in your draft.
Template pack (copy and personalize)
Sales outreach
Subject: Quick idea for {{company}}
Hi {{First Name}}, I noticed {{custom_line}} and thought it might be worth a quick conversation. We help teams like {{company}} send personalized outreach from a simple spreadsheet. Open to a short call next week? — {{sender_name}}
Follow-up (no reply)
Subject: Re: {{company}}
Hi {{First Name}}, just floating this back to the top of your inbox in case it slipped by. Happy to share a one-line summary if that is easier. — {{sender_name}}
Recruiting outreach
Subject: {{role}} role at {{company}}
Hi {{First Name}}, your background stood out for a {{role}} opening we are hiring for. Would you be open to a quick chat about it this week? — {{sender_name}}
Event / webinar invite
Subject: You're invited: {{event_name}}
Hi {{First Name}}, we are hosting {{event_name}} on {{event_date}} and thought it would be relevant to you at {{company}}. Save your spot here: {{event_link}}. — {{sender_name}}
Customer update
Subject: {{company}} — what's new this month
Hi {{First Name}}, a quick update on what changed this month: {{custom_line}}. Reply any time with questions. — {{sender_name}}
Light newsletter
Subject: {{topic}} — a short note
Hi {{First Name}}, here is one useful thing on {{topic}} this week: {{custom_line}}. Reply “unsubscribe” any time and I’ll take you off this list. — {{sender_name}}
Personalization tags that boost replies
Beyond {{First Name}}, a single tailored line ({{custom_line}}) referencing something specific to the recipient lifts reply rates more than any other tweak. Keep subjects short, lead with relevance, and avoid stuffing every field just because you can.
Test send, then track and follow up
Click Send Test Email first: it sends one message to you, filled with row 2’s data. Confirm every placeholder resolves — no raw {{tags}} should appear. Then send: the add-on writes EMAIL_SENT in the Mail Merge column, and EMAIL_OPENED or EMAIL_CLICKED after you click Refresh Email Status. A follow-up is a separate send you set up yourself: copy the rows that didn’t open or reply to a new tab, clear their Mail Merge cells, write a new draft (such as the follow-up template above) and launch again.
Sending-quality cautions
Templates are a starting point, not a license to blast. Only email people who have consented to hear from you, include a working opt-out line you write yourself (the add-on doesn’t add an unsubscribe link) and a real sign-off, keep examples generic (no impersonating real people or brands), and respect Gmail’s daily sending limits and laws like CAN-SPAM and GDPR. No template guarantees results.
Related Mail Merge resources
- Mail Merge for Gmail and Google Sheets
- Mail merge follow-up emails
- Personalized email from Google Sheets
Mail merge templates FAQ
How do merge fields in a template work?
A merge field like {{First Name}} is a placeholder. When you send, it is replaced with the matching value from each recipient’s row in your Google Sheet, so one template produces many personalized emails.
Do my Sheet column names have to match the template tags?
Yes. Each placeholder must match a column header exactly, including case and spaces, so the add-on knows which value to insert; a placeholder with no matching column is sent as-is. Keep them identical, for example a company column for a {{company}} tag.
Can I add my own custom personalization line?
Yes. Add a column such as custom_line with a tailored sentence per recipient and reference it as {{custom_line}}. A specific, relevant line is the single biggest driver of replies.
Are these templates safe to send as-is?
Treat them as starting copy. Edit for your voice, email only consented contacts, write an opt-out line into your draft, and run a test send first. Following anti-spam rules is the sender’s responsibility.
Grab the templates and send
Keep recipients in Google Sheets, paste a template into a Gmail draft, match the placeholders to your column headers, and let Mail Merge for Gmail and Sheets personalize and send each message.
