GPT for Google Sheets, Docs AI, Slides, Forms

Preview and Test Your Gmail Mail Merge Before You Send

Test a Gmail mail merge from Google Sheets before you send: a test email with real row data catches broken placeholders, blank names and bad links.

The fastest way to ruin a campaign is to send “Hi {{First Name}},” to a few hundred people. In Mail Merge for Gmail and Google Sheets, the test email is your preview: on the 3. Schedule tab, click Send Test Email and the add-on sends one email to you only, filled with the data from row 2. It doesn’t use your free emails and has no tracking or footer. Check it, fix the draft or the sheet, and test again before you start the campaign.

Try Mail Merge for Gmail and Sheets →

Why preview and test sends matter in mail merge

A mail merge applies one template to many rows, so one mistake repeats across the whole list: a broken placeholder, a blank field or the wrong link appears in every copy. A test with real row data turns that risk into something you can see and fix in minutes.

The 7 mistakes to catch before sending

  1. Wrong or broken placeholders. A placeholder that doesn’t match a header exactly (capitals and spaces included) is sent as it is, for example {{Frist Name}}.
  2. Blank names and empty fields. An empty cell becomes empty text, so “Hi ,” appears. There is no default value inside a placeholder; use a fallback column instead (below).
  3. Broken links. Wrong, expired or non-HTTPS links, especially ones built from placeholders.
  4. Bad attachments. The wrong file, a missing file, or a wrong match in the Attachments column on paid plans.
  5. Wrong recipients. Test rows, internal addresses, duplicates or people who opted out left in the list. Type SKIP in the Mail Merge cell of anyone who shouldn’t get the email.
  6. Formatting issues. Broken layout, images that don’t load, or competing calls to action.
  7. Missing signature or opt-out. The add-on doesn’t add an unsubscribe line, so add one yourself on marketing-style sends.

Add a fallback for empty names

Prepare the text in Google Sheets with a formula, then use the new column as the placeholder. For example, add a column called Greeting with this formula in row 2 (First Name in column B), and fill it down:

=IF(B2="", "Hi there,", "Hi " & B2 & ",")

In your draft, write {{Greeting}} instead of Hi {{First Name}},. More examples: Personalize with placeholders.

Add a few control columns so nothing launches by accident:

Column Purpose
Mail Merge Required. Empty before sending; the add-on writes each row’s status here. Type SKIP to hold a row back
Reviewed Your own yes/no check that the row was reviewed
Notes Owner notes, edge cases, personalization to double-check

The add-on doesn’t read your own columns like Reviewed. Only SKIP (or an existing status) in the Mail Merge column keeps a row from being sent.

Set up a reviewable Sheet campaign →

How to send a test email and check several rows

  1. Put a tricky row in row 2, the first row under the headers. The test goes to you, whatever address row 2 has.
  2. Send the test. Click Start New Campaign, pick your draft, then click Send Test Email on 3. Schedule.
  3. Read it as a recipient on desktop and mobile. Check the subject, the greeting and every placeholder.
  4. Click everything: the call to action, every link and any attachment.
  5. Check another row. Move it to row 2 and send another test. Tests don’t use your free emails, but they count toward Google’s daily limit.
  6. Fix the source, not one email. If a placeholder is broken, fix the draft or the header.
  7. Want a second opinion? Forward the test to a teammate; the add-on sends tests only to you.

Checklist before launching the full campaign

  • Recipient list cleaned: duplicates, bounced addresses and opt-outs removed or marked SKIP.
  • Every placeholder matches a header exactly; empty cells are filled or covered by a fallback column.
  • Subject line is honest and fills in correctly.
  • Links and call to action checked in at least one test.
  • Attachments confirmed where used.
  • Signature and opt-out line present (free-plan emails also get a small footer).
  • First run sent with a low Maximum emails per launch.
  • Daily volume fits Google’s limit: about 100 recipients a day on @gmail.com and 1,500 on Google Workspace.

What to monitor after sending

Click Refresh Email Status in the sidebar to update rows to EMAIL_OPENED or EMAIL_CLICKED. Replies and bounce messages arrive in your Gmail inbox; the add-on doesn’t track replies, bounces or unsubscribes. Treat a spike in bounces or opt-outs as a signal to pause and review list quality and message relevance. No tool can guarantee inbox placement, so keep watching.

Mail merge preview and test-send FAQ

How do I preview a Gmail mail merge before sending?

With Mail Merge for Gmail and Sheets, send yourself a test: on the 3. Schedule tab, click Send Test Email. It uses row 2’s data and goes only to you. To check another row, move it to row 2 and send another test.

How do I send a test email for a mail merge?

Click Start New Campaign, select your draft, go to 3. Schedule and click Send Test Email. The test doesn’t use your free emails and has no tracking or footer. Read it as a recipient, open it on desktop and mobile, and click every link.

What are the most common mail merge mistakes?

Placeholders that don’t match a header exactly, empty cells with no fallback column, wrong or non-HTTPS links, bad attachments, wrong recipients, broken formatting, and a missing signature or opt-out.

How many test rows should I check?

At least a typical row, a row with unusually long values and a row with a missing field. Move each one to row 2 in turn and send a test.

What should I monitor after the campaign goes out?

Opens and clicks (click Refresh Email Status), plus replies and bounce messages in your Gmail inbox, which the add-on doesn’t track. A rise in bounces or opt-outs is a signal to pause and review list quality and message relevance.

Catch merge mistakes before your recipients do

Build the list in Google Sheets, put a tricky row in row 2, send yourself a test, then launch with confidence.

Try Mail Merge for Gmail and Sheets →