Mail Merge Personalization Tags in Google Sheets

Learn how mail merge personalization tags and merge fields map to Google Sheets columns for Gmail campaigns, with examples, fallbacks, and test-send tips.

Mail Merge Personalization Tags in Google Sheets (Merge Fields That Actually Convert)

Personalization tags turn one Gmail draft into many relevant emails. With Mail Merge for Gmail and Google Sheets, each tag maps to a column in your Sheet, so every recipient can receive their own name, company, offer, link, or custom opening line.

Map your Sheet columns and send →

What personalization tags are

A personalization tag, merge field, or variable is a placeholder in your message. Common examples look like:

When you send a campaign, the mail merge replaces each tag with the value from that recipient’s row in Google Sheets.

How tags map to Google Sheets columns

The rule is simple: one Sheet column equals one merge field. If your column is named first_name, your email can include ``. If the header is Company Name, your tag must match the format your tool expects for that header.

A clean starter Sheet might look like this:

email	first_name	company	role	custom_line	call_to_action
alex@example.com	Alex	Northwind	VP Sales	saw your new partner program	book a short demo
maya@example.com	Maya	Contoso	Recruiter	noticed your hiring push	review candidate examples

Then your Gmail draft can say:

Subject: Quick idea for 

Hi ,

I  and thought this might be useful for your  workflow.

Would you like to ?

Set up clean columns before you write copy

Personalized campaigns fail when the spreadsheet is messy. Before sending, review these details:

Use simple headers. Prefer first_name, company, role, city, custom_line, and offer.
Avoid duplicate headers. Two columns with the same name can confuse mapping.
Remove empty required fields. If first_name is blank, your greeting may look broken.
Keep one idea per column. Do not mix company names, notes, and links in a single field.
Use a status column. Track draft, test, sent, replied, bounced, or opted out.

Turn your Sheet columns into a Gmail campaign →

Use fallback-friendly copy

Not every row will have perfect data. Write copy that still sounds natural if a field is short or missing.

Instead of:

Hi , I loved your  at .

Use a safer version:

Hi , I came across  and thought this might be relevant to your team.

Or create a custom_line column that you manually review for every recipient. A single accurate custom line is better than five weak tokens.

Personalize more than the greeting

First-name personalization is expected. Better campaigns personalize the reason for sending.

Use case	Useful tags
Sales outreach	`,`, `,`
Recruiting	`,`, `,`
Events	`,`, `,`
Customer updates	`,`, `,`
Agencies	`,`, `,`

Use tags where they add relevance, not just because the data exists.

Preview and test before going live

Before a real send, preview multiple rows:

the first row;
a row with a long company name;
a row with non-English characters;
a row with optional fields empty;
a row from each campaign segment.

Then send a test to yourself. Confirm the subject, body, links, attachments, signature, unsubscribe language, and sender identity all look correct.

Common personalization mistakes

Avoid these errors:

mismatched headers such as First Name in the Sheet but `` in the email;
empty cells that produce awkward sentences;
over-personalized lines that feel fake or creepy;
stale data copied from old campaigns;
real personal data used in examples or screenshots;
sending without a test message.

Sending-quality cautions

Personalization does not make unwanted email acceptable. Send to consented or clearly relevant contacts, include opt-out language where appropriate, respect Gmail/Workspace limits, avoid misleading copy, and comply with applicable laws. No merge tag guarantees replies.

Personalization tags FAQ

What is a mail merge personalization tag?

A personalization tag is a placeholder in an email, such as ``, that is replaced with a value from the recipient’s Google Sheets row when the campaign sends.

Do tag names need to match Sheet headers?

Yes. Keep Sheet headers and email tags consistent so the mail merge knows which value belongs in each placeholder.

What are the best fields to personalize?

Start with first name, company, role, segment, and one reviewed custom line. The custom line is usually more useful than adding many generic fields.

Should I test every personalized campaign?

Yes. Send at least one test and preview several rows before launching, especially if the campaign uses subject-line tags, links, attachments, or custom lines.

Build better personalized Gmail campaigns

Keep your data in Google Sheets, use clear merge fields, preview every row that matters, and send personalized campaigns with Mail Merge for Gmail and Sheets.

Try Mail Merge for Gmail and Sheets →