GPT for Google Sheets, Docs AI, Slides, Forms

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.

Set up your Sheet and send →

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.

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.

Try Mail Merge for Gmail and Sheets →