GPT for Google Sheets, Docs AI, Slides, Forms

How to Send Mail Merge Follow-Up Emails from Google Sheets

Send a mail merge follow-up from Google Sheets as a separate Gmail campaign: pick rows by open or click status, write a new draft, test and send.

Follow-ups are where many Gmail campaigns become useful—but only when they are relevant, respectful, and based on what happened after the first send. With Mail Merge for Gmail and Google Sheets, the add-on writes EMAIL_SENT in the Mail Merge column, and EMAIL_OPENED or EMAIL_CLICKED after you click Refresh Email Status, so campaign status, your reply notes, and next-step fields sit in the same Sheet you used for the original outreach. The add-on doesn’t send follow-ups automatically: a follow-up is a separate send you set up yourself.

Plan Gmail follow-ups from Google Sheets →

This guide shows a practical workflow for sending mail merge follow-up emails from Google Sheets without turning your campaign into spam. Use consented or clearly relevant contacts, respect opt-outs, test every merge field, and stay within Gmail/Google Workspace limits.

When follow-ups help and when not to send them

A follow-up can be helpful when the recipient had a legitimate reason to hear from you and the second message adds useful context. It is usually not helpful when the list is unqualified, the first message was generic, or the recipient already replied, bounced, unsubscribed, or opted out.

Good follow-up triggers include:

  • a sales prospect opened or clicked (EMAIL_OPENED or EMAIL_CLICKED in the Mail Merge column) but did not reply;
  • a recruiter contacted a candidate and wants to share a clearer role detail;
  • an event organizer needs a reminder for registered or invited guests;
  • a customer-success team needs to send a deadline or product update;
  • a nonprofit or school needs a polite reminder to a permissioned audience.

Avoid follow-ups to people who already said no, asked not to be contacted, bounced, or are not a relevant audience.

Prepare follow-up columns in Google Sheets

Before writing the message, add fields that control who should receive it and why:

Column Example Why it matters
Email [email protected] Recipient address (header must be exactly Email)
First Name Alex Basic personalization
Last Name Lee Required header; the cells can stay empty
Mail Merge EMAIL_OPENED, SKIP The add-on’s status column; type SKIP for anyone who replied or opted out
company Acme Context for business outreach
last_touch_date 2026-06-01 Prevents sending too soon
follow_up_reason asked for pricing, downloaded guide Makes the message relevant
next_step send demo link Clarifies the ask
owner Maya Useful for teams

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.

Rows already marked EMAIL_SENT, EMAIL_OPENED, or EMAIL_CLICKED are skipped on the next launch, and Sheet filters don’t change who gets the email. So send the follow-up from a new tab (copy the rows you want and clear their Mail Merge cells), or note who opened or clicked, run Clean Current Campaign, and type SKIP in Mail Merge for the rows to exclude. Replies arrive in your Gmail inbox; the add-on doesn’t track them, so remove people who replied, bounced, or opted out yourself.

Write concise Gmail follow-up templates with merge fields

Follow-ups should be shorter than the first message. Do not pretend a message is hand-written if it is clearly a campaign. Use merge fields to add real context. The add-on sends each follow-up as a new email, not as a reply in the original thread, so don’t fake a thread with “Re:” in the subject.

Sales follow-up template

Subject: Following up: idea for {{company}}

Hi {{First Name}},

Quick follow-up on my note about {{pain_point}}.

If it is relevant for {{company}}, I can send a short example of how teams handle {{use_case}}.

Worth a look?

Best, {{owner}}

Recruiting follow-up template

Subject: Following up on the {{role}} role

Hi {{First Name}},

I wanted to follow up once on the {{role}} opportunity. Your background in {{candidate_background}} looked aligned with what the team needs.

If you are open to it, I can send the job details and compensation range.

Thanks, {{owner}}

Event reminder template

Subject: Reminder: {{event_name}} on {{event_date}}

Hi {{First Name}},

A quick reminder that {{event_name}} is coming up on {{event_date}}.

The session may be useful if you are working on {{audience_goal}}. Here is the registration link: {{registration_link}}

Preview, test, and send follow-ups responsibly

Use this launch checklist before sending any follow-up batch:

  1. Remove exclusions. Delete or SKIP rows for people who replied, opted out, or bounced (check your Gmail inbox; the add-on doesn’t track these), customers with resolved tickets, and anyone outside the intended segment.
  2. Check timing. A follow-up sent too quickly can feel automated; a follow-up sent too late can feel irrelevant.
  3. Check rows with edge cases in the Sheet. Look for missing first names, empty reasons, broken links, and awkward sentences.
  4. Send a test email. Send Test Email sends one message to you, filled with row 2’s data. Verify subject, body, signature, links, and attachments.
  5. Send a small segment first. Watch replies and bounces before scaling.
  6. Respect Gmail limits. Do not use mail merge to bypass Workspace limits or recipient preferences.
  7. Monitor quality signals. Replies and bounces usually tell you more than opens alone.

Use Mail Merge for Gmail follow-ups →

Follow-up examples by use case

Sales outreach

Add columns for pain_point, use_case, industry, last_touch_date, and next_step. Segment by fit and recent engagement, then send a short follow-up that adds a specific reason to reply.

Recruiting outreach

Add columns for role, candidate_background, location, and salary_range_available. A useful follow-up gives clearer role context, not vague pressure.

Events and webinars

Add columns for event_name, event_date, registration_link, and audience_goal. Exclude people who already registered if the reminder is for non-registrants.

Customer updates

Add columns for plan, feature_used, deadline, and account_owner. Send updates only to customers who need the information.

Mail merge follow-up FAQ

Can I send follow-up emails from Google Sheets?

Yes, as a separate send you set up yourself. Mail Merge for Gmail and Sheets skips rows already marked EMAIL_SENT, EMAIL_OPENED, or EMAIL_CLICKED, so copy the rows you want to a new tab (with empty Mail Merge cells), write a new Gmail draft, and launch again. The add-on does not send follow-ups automatically.

How many follow-ups should I send?

There is no universal number. For most campaigns, one or two respectful follow-ups are safer than long automated sequences. Stop when someone replies, opts out, bounces, or is no longer relevant.

What columns should I add for follow-ups?

Useful columns include Mail Merge (the add-on’s status column, where SKIP excludes a row), last_touch_date, follow_up_reason, next_step, owner, and any personalization fields that make the message specific.

Should I follow up with everyone who did not open?

No. Open tracking is approximate because some email apps block or preload images. Use replies you see in Gmail, bounces, clicks (EMAIL_CLICKED after Refresh Email Status), and recipient fit before deciding.

How do I avoid spammy follow-up emails?

Use permissioned or clearly relevant contacts, keep the message useful, include opt-out handling where appropriate, test sends, avoid misleading personalization, and respect Gmail/Workspace limits.

Start sending better follow-ups

Turn your follow-up process into a clean Sheet-based workflow: segment carefully, write one useful message, test it, and use Mail Merge for Gmail and Sheets to send responsibly.

Try Mail Merge for Gmail and Sheets →