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.
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 →