GPT for Google Sheets, Docs AI, Slides, Forms

Add an Unsubscribe Link to Gmail Mail Merge (Google Sheets)

How to add an unsubscribe or opt-out link to a Gmail mail merge from Google Sheets, honor opt-outs in your sheet, and keep personalized campaigns compliant and deliverable.

If you send personalized campaigns to a list, giving people a clear way to opt out is both good practice and, for many campaign types, a legal expectation. Mail Merge for Gmail and Google Sheets lets you run personalized Gmail campaigns from a spreadsheet, but it has no built-in unsubscribe link: you write the opt-out line into your Gmail draft yourself. This guide shows how to add an unsubscribe link, record opt-outs back in your Sheet, and keep your sending clean.

Try Mail Merge for Gmail and Sheets →

This page is general guidance, not legal advice. Requirements vary by region and campaign type (for example marketing vs. transactional). Confirm what applies to you under rules such as CAN-SPAM, GDPR, and CASL.

A working opt-out path protects both your recipients and your sender reputation:

  • Respecting consent. People who no longer want your emails should be able to leave easily.
  • Compliance. Many marketing emails are expected to include a clear, working opt-out and to honor it promptly.
  • Deliverability. Giving recipients an easy unsubscribe reduces spam complaints, which mailbox providers weigh heavily. A complaint is worse for reputation than an unsubscribe.
  • List quality. Removing uninterested recipients keeps your engagement rates and future campaigns healthier.

You do not need a heavy marketing platform to offer a real opt-out. Common approaches:

  1. Link to a simple opt-out form. Create a Google Form (or any form) and paste its link into your template, for example: “Prefer not to receive these? [Unsubscribe here].” Form responses give you a list of addresses to suppress.
  2. Use a mailto opt-out. Add a line such as: “Reply STOP or email [email protected] to unsubscribe.” This is low-tech but workable for small lists.
  3. Per-recipient link with merge fields. Store a unique link or token in a Sheet column (for example unsubscribe_url) and insert it as a merge field so each recipient gets a trackable opt-out link. If the add-on’s open and click tracking is on, links in the email (including an opt-out link) go through its tracking redirect, so a click shows as EMAIL_CLICKED in the Mail Merge column, not as an unsubscribe.
  4. Footer with sender identity. Pair the link with your real name, business, and a physical mailing address where required, so the email is clearly identifiable.

Step-by-step workflow

  1. Add opt-out columns to your Sheet. For example opted_out (yes/no) for your own records and, if needed, unsubscribe_url.
  2. Write the footer once. Put your unsubscribe line and sender identity at the bottom of your template so every message includes it.
  3. Insert the merge field. If you use per-recipient links, reference the column (for example {{unsubscribe_url}}) in the footer.
  4. Exclude opted-out rows before sending. The add-on ignores the opted_out column (and other filter columns), so type SKIP in the Mail Merge cell of every row where opted_out is “yes.” Rows marked SKIP are left out of every launch.
  5. Collect new opt-outs. After each campaign, review form responses and your Gmail inbox for replies and bounces (the add-on doesn’t track them), mark those rows opted_out = yes, and type SKIP in their Mail Merge cell.
  6. Suppress on every future send. Treat the opt-out column as permanent. Clean Current Campaign clears the whole Mail Merge column, SKIP included, so re-mark opted-out rows before you send again. Never re-add a removed contact without fresh consent.
You're receiving this because {{reason_for_contact}}.

Your Name, Your Business
Your mailing address

Prefer not to hear from us? Unsubscribe: {{unsubscribe_url}}
(or reply STOP and we'll remove you)

Type your name, business, and address straight into the draft; only per-recipient values such as reason_for_contact and unsubscribe_url need their own columns, with headers that match the placeholders exactly. Keep the language plain and the link easy to find. Hiding the opt-out tends to increase spam complaints, which hurts deliverability more than the unsubscribe itself.

Honor opt-outs across campaigns

An unsubscribe link only helps if you act on it. Build a habit of moving opt-out addresses into a suppression column or separate “do not email” sheet, and check that suppression list before every send. If you run multiple lists, apply opt-outs across all of them, not just the campaign where someone unsubscribed.

Deliverability and compliance cautions

Send only to permissioned or clearly relevant contacts, include a working opt-out where required, identify yourself honestly in the footer, process opt-outs promptly, avoid misleading subject lines or spammy copy, send a test first, and respect Gmail/Workspace sending limits. Rules differ by country and by whether a message is marketing or transactional, so confirm what applies to your situation.

Not always, but marketing and promotional emails commonly do. Transactional messages may be treated differently. Because rules vary by region and message type, confirm what applies to you under regulations such as CAN-SPAM, GDPR, and CASL.

Mail Merge for Gmail and Sheets doesn’t add one for you, so add a footer to your Gmail draft with a link to an opt-out form, a mailto opt-out, or a per-recipient unsubscribe_url merge field stored in your Sheet. Then suppress anyone who opts out on future sends.

How should I track who unsubscribed?

Keep an opted_out column or a separate suppression sheet and update it after each campaign from form responses and replies; the add-on doesn’t track unsubscribes. Before every send, type SKIP in the Mail Merge cell of opted-out rows, since the add-on ignores other columns.

Generally yes. An easy opt-out reduces spam complaints, which mailbox providers weigh heavily. An unsubscribe is less damaging to your reputation than a spam report.

Yes. Store a unique link or token in a spreadsheet column and insert it as a merge field so each recipient receives their own opt-out link.

Send responsibly from Google Sheets

A clear opt-out is part of a healthy Gmail + Sheets workflow. Add the footer, suppress opt-outs, test, and use Mail Merge for Gmail and Sheets to keep personalized campaigns clean and compliant.

Try Mail Merge for Gmail and Sheets →