The Merge Status Column

Every row gets a result after a send. That column is also how the add-on knows who not to email twice.

← All docs

Last updated

What each status means

The add-on adds a Merge status column to your sheet the first time you send, and writes a result into it as each email goes out.

Status What happened What to do
SENT 2026-10-25 14:32 The email went out at that time, in the spreadsheet’s time zone. Nothing.
SKIPPED: invalid address The email cell isn’t a valid address, such as a typo or a missing @. Fix the address and clear the status.
SKIPPED: duplicate Someone else in this sheet with the same address already got the email, either earlier in this send or in an earlier one. Nothing. Nobody gets the same email twice.
SKIPPED: unsubscribed The address is on your Unsubscribed tab. Nothing.
ERROR: … Gmail refused this one email. The reason follows the colon. See Common errors.

Follow-ups get their own columns, Follow-up 1 status, Follow-up 2 status and so on, with one extra value: QUEUED means the row is lined up for that follow-up and is about to be sent. See Follow-ups.

The progress numbers in the add-on are counted from these columns every time you look. If you clear or edit a status, the numbers change to match.

Running it again

When you send again, the add-on only emails rows with an empty Merge status. That’s the whole rule, and it makes reruns safe:

  • Added 20 new people at the bottom? Send again and only those 20 get the email.
  • A row says SENT, SKIPPED or ERROR? It’s left alone.
  • Even with an empty status, a row is skipped as a duplicate if that address is marked SENT anywhere else in the sheet.

Hidden rows and rows without an email address are passed over without a status, so you can filter the sheet to send in batches.

Resending to some rows

Clear the Merge status cell of each row you want to send again, then send. Nothing else needs to change.

This is also how you retry rows that failed: fix the problem, clear their ERROR cells, and send again.

Deleting the whole Merge status column makes every row look new, so everyone would get the email again (except duplicates within the sheet). Only do that on purpose.

Keeping people off the list

Add a tab named exactly Unsubscribed with Email in cell A1 and one address per row below it. Anyone listed there is skipped by every send and every follow-up in this spreadsheet, and their row is marked SKIPPED: unsubscribed.

The list is checked again before each batch, so adding someone stops their follow-up even after it’s been queued. It’s the quickest way to stop following up with someone who has already replied.

Common errors

What the cell says What to do
The Gmail API is turned off… The add-on’s Google Cloud setup needs attention. Email us, as you can’t fix this one yourself.
The add-on is missing permission to send email Close and reopen the add-on, then approve the Gmail permission when asked.
Google could not verify your sign-in Reload the sheet and approve the add-on again.
Anything else It’s Gmail’s own message about that one email, often an address it won’t accept in To or a merged CC. Fix what it describes and clear the cell.

If five emails in a row fail, the send stops instead of working through the rest of the list, and the dialog shows the last error. Usually something is wrong with your account or permissions rather than with those rows. Fix it, then send again: rows already marked SENT are skipped.

When Gmail’s own daily limit is hit, the rows aren’t marked as errors. The send pauses and carries on 24 hours later. See Daily limits and quota.

One mail merge per spreadsheet

Every send in a spreadsheet writes to the same Merge status column, so two different campaigns in one spreadsheet can’t be told apart. The second one would skip everyone the first one reached.

For a new campaign with a different email, make a copy of the spreadsheet (File → Make a copy) and delete the Merge status column in the copy.

Get it first

Simple Mail Merge is in Google Workspace Marketplace review. Leave your email and we send the install link the day it goes live.

Request early access →