Mail Merge Email Templates for Gmail and Google Sheets

Q: How do merge fields in a template work?

A merge field like 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.

Q: 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 . A specific, relevant line is the single biggest driver of replies.

Copy-and-personalize mail merge templates for Gmail and Google Sheets: sales, follow-up, recruiting, event, and update emails with merge fields that map to your columns.

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 `` that map straight to your Google Sheet columns, so each recipient gets a personalized message. Mail Merge for Gmail and Google Sheets turns any of these templates 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 or. When you send, the tool replaces each placeholder with the matching value from that recipient’s row in your Sheet. So a template stays one piece of copy, 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	jordan@example.com
`first_name`	greeting + personalization	Jordan
`company`	context	Northwind
`role`	relevance	Operations Lead
`custom_line`	a tailored sentence	we loved your recent launch

Match your placeholders to these headers exactly and every template below will personalize automatically.

Map your Sheet and send →

Template pack (copy and personalize)

Sales outreach

Subject: Quick idea for

Hi , I noticed and thought it might be worth a quick conversation. We help teams like send personalized outreach from a simple spreadsheet. Open to a short call next week? —

Follow-up (no reply)

Subject: Re:

Hi , 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. —

Recruiting outreach

Subject: ` role at `

Hi , your background stood out for a opening we are hiring for. Would you be open to a quick chat about it this week? —

Event / webinar invite

Subject: You're invited:

Hi , we are hosting on and thought it would be relevant to you at . Save your spot here: . —

Customer update

Subject: ` — what’s new this month`

Hi , a quick update on what changed this month: . Reply any time with questions. —

Light newsletter

Subject: ` — a short note`

Hi , here is one useful thing on this week: . You can unsubscribe any time using the link below. —

Personalization tags that boost replies

Beyond , a single tailored 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

Send a test to yourself first and confirm every placeholder resolves — no raw `` should appear. Then send, watch opens and clicks, and let follow-ups go to people who did not reply.

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 unsubscribe/opt-out 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 `` 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 so the tool knows which value to insert. Keep them identical, for example a company column for a `` 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 ``. 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, include an unsubscribe option, 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, drop in a template, map your columns, and let Mail Merge for Gmail and Sheets personalize and send each message.