GPT for Google Sheets, Docs AI, Slides, Forms

Google Contacts Mail Merge with Gmail and Google Sheets

Turn Google Contacts into a careful Gmail mail merge: import contacts into Google Sheets, add personalization fields, send a test, and respect opt-outs.

Google Contacts Mail Merge: Send Personalized Gmail Campaigns from Sheets

A Google Contacts mail merge is useful when your relationship list already lives in Google: customers, parents, donors, partners, candidates, members, alumni, or local business contacts. The safest workflow is to move the contacts into a clean Google Sheet, add the fields you need, then send a tested Gmail campaign.

Mail Merge for Gmail and Google Sheets helps you use the Sheet as the campaign control center: recipient data, personalization, send status, opens and clicks, plus your own notes on replies and opt-outs.

Turn contacts into a Gmail mail merge →

The quickest route is built in: in your Sheet, choose Extensions → Mail Merge for Sheets™ Gmail™ → Import Google Contacts, which adds your contacts’ names and email addresses as rows. This guide also covers the export-to-Sheets route for when you want labels or other fields.

When Google Contacts is the right starting point

Google Contacts is often the source of truth for relationship-based email:

  • customers you have personally worked with;
  • community members or event attendees;
  • parents, students, or school stakeholders;
  • donors, volunteers, or nonprofit supporters;
  • recruiters’ candidate lists;
  • account managers’ relationship contacts;
  • small business leads and partners.

A contact being in Google Contacts does not automatically mean they opted into marketing. Use consent, relationship context, segmentation, and opt-out handling before sending a broader campaign.

Export or prepare contacts before the merge

The safest universal workflow is:

  1. Choose a focused contact group. Do not export every contact by default.
  2. Export from Google Contacts using the current export options available in your account.
  3. Open or import the file in Google Sheets. Keep only the fields needed for this campaign.
  4. Remove personal notes you should not merge. A campaign Sheet should not contain sensitive context that could be accidentally sent.
  5. Add campaign-specific columns. Include segment, message angle, opt-out, and notes. The add-on adds its own Mail Merge status column.

If you use the add-on’s Import Google Contacts instead, still review the rows before sending: it brings in all your contacts’ names and addresses, so delete the ones outside this campaign and add any other columns yourself. The review step prevents accidental blasts.

Clean the Sheet: names, email addresses, segments, and custom fields

After export, clean the Sheet before writing the email.

Column Example Check before send
Email [email protected] Valid, unique, not suppressed (exact header name)
First Name Dana No blanks or all-caps names
Last Name Lee Optional but useful
Mail Merge blank Add-on status; type SKIP to hold a row back
label donors Segment is accurate
relationship 2025 event attendee Relevant reason to email
custom_line thanks for joining the workshop Safe personalization
cta register for the spring session One clear next step
opt_out no Your suppression flag; type SKIP in Mail Merge for these rows

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.

Remove duplicates, role accounts that are not appropriate, outdated addresses, and any contact who should not receive the message.

Clean your contact list in Sheets →

Write a Gmail draft that uses Sheet columns

Keep the message short and recognizable. A contacts-based campaign should feel like a relationship email, not a generic blast.

Example update template:

Subject: Quick update for {{label}}

Hi {{First Name}},

I wanted to share a quick update because {{relationship}}.

The main next step is to {{cta}}.

If this is not relevant, just reply and I will update my list.

Best, Your name

Use only fields you have reviewed. If a personalization field may be blank, rewrite the sentence so it works without it, or remove that field from the first send: there is no fallback, so an empty cell becomes empty text.

Send a test, then a small first batch

Before emailing a full contact group:

  1. Check rows from each segment for blanks and odd values.
  2. Click Send Test Email: one message goes to you, filled with row 2’s data.
  3. Check mobile formatting, links, signature, and opt-out wording.
  4. Send a small real batch first.
  5. Watch your inbox for bounces, replies, and confusion.
  6. Pause if the list quality looks poor.

For school, nonprofit, community, and customer lists, clarity matters more than volume. Recipients should understand why they are getting the message.

Track status, replies, bounces, and opt-outs in Google Sheets

Use the Sheet as the campaign log. The add-on fills only the Mail Merge column (EMAIL_SENT, then EMAIL_OPENED or EMAIL_CLICKED after you click Refresh Email Status). Add these columns for what you track by hand:

Column Purpose
sent_at When the row was emailed
reply_status Positive, neutral, negative, no reply
bounce Mark invalid addresses
opt_out Suppress future sends
follow_up_needed Yes/no
owner Who handles the response
next_step Call, donation ask, registration, renewal, or no action

Opens and clicks (tracked on every plan) can help prioritize, but replies and explicit opt-outs are more important for list health.

Google Contacts mail merge FAQ

Can I mail merge from Google Contacts?

Yes. In Google Sheets, Mail Merge for Gmail and Sheets has an Import Google Contacts menu item that adds your contacts’ names and email addresses as rows. You can also export a focused group from Google Contacts, open it in Google Sheets, clean the fields, and send personalized messages from a Gmail draft.

Should I email every Google Contact I have?

No. Segment the list and email only contacts where the message is consented, expected, or clearly relevant. Avoid emailing old, unrelated, or purchased lists.

What fields should I keep from Google Contacts?

Keep email, name, label or group, relationship context, and any safe campaign-specific fields. Remove sensitive notes or fields that should not be used in an email template.

How do I avoid broken personalization?

Clean blanks and duplicates, check the rows each placeholder uses, write sentences that still work if a field is empty, and send a test email to yourself before launching the full campaign.

Can I track replies and opt-outs in Google Sheets?

Yes, by hand. The add-on writes send, open, and click status into the Mail Merge column, but it does not track replies or opt-outs, so add your own columns for replied, bounced, opted out, follow-up needed, owner, and next step.

Send from a reviewed contact Sheet

Start with a focused contact group, clean the data in Google Sheets, test the Gmail draft, and send only when the message is relevant and ready.

Start a Google Contacts mail merge →