Mail Merge for Gmail and Sheets

Mail Merge for Gmail and Sheets by DocGPT.ai is a Google Sheets™ add-on that sends personalized emails from your own Gmail account, one separate email for each row of your sheet. It writes a status such as EMAIL_SENT next to every recipient and can track opens and clicks. Scheduling and per-recipient attachments come with paid plans, and new users get 11 free emails to start.

Links:

• Install Mail Merge from the Google Workspace Marketplace (listed as Mail Merge for Gmail™ Sheets™)
• Mail Merge for Gmail and Sheets product page, with features and pricing

Key facts

• Works in: Google Sheets. You write the email as a Gmail draft and start the campaign from the sheet. A small Gmail side panel only explains the steps; sending always happens from Google Sheets.
• Sends from: your own Gmail or Google Workspace account, one email per recipient. You can set a sender name and a reply-to address.
• Personalization: placeholders like {{First Name}} in the subject and body are replaced with the matching column of each row.
• Tracking: opens and clicks, shown as statuses in the sheet. Replies, bounces and unsubscribes are not tracked in the current version.
• Daily limit: set by Google, not by the add-on: about 100 recipients a day on a free @gmail.com account and 1,500 on Google Workspace. See Gmail sending limits.
• Free: 11 free emails to start, with open and click tracking, test emails and Google Contacts import. Free emails carry a small “Sender notified by Mail Merge for Gmail” footer.
• Paid plans: from $4.99 a month. They remove the footer and add scheduling and personalized attachments. See Plans and billing.

How to install

1. Open the Marketplace listing and click Install.
2. Choose the Google account you send email from and approve all the requested permissions.
3. Open a Google Sheet and go to Extensions → Mail Merge for Sheets™ Gmail™ → 🚀 Launch.

Work or school account? Your administrator may need to allow the add-on first. See Admin setup.

Documentation

• Get started: install, set up the sheet, write a draft, send a test and run your first campaign
• Personalize with placeholders: how {{Column Name}} matching works, empty cells, fallbacks and attachments per recipient
• Schedule a campaign: send later, time zones and how to cancel
• Track opens and clicks: what each status means and how accurate it is
• Gmail sending limits: how many emails you can send per day and what to do at the limit
• Fix common errors: permissions, missing columns, invalid emails, timeouts and spam
• Plans and billing: the free plan, paid plans, upgrading and cancelling
• Admin setup: enable the add-on for a Google Workspace organization or school

Related

• Mail Merge for Gmail and Sheets product page
• Pricing
• Contact support

Gmail™, Google Sheets™ and Google Workspace™ are trademarks of Google LLC.

---

Table of contents

• Get started with Mail Merge for Gmail and Sheets
• Personalize Mail Merge emails with placeholders
• Schedule a Mail Merge campaign
• Track email opens and clicks
• Gmail sending limits for Mail Merge
• Fix common Mail Merge errors
• Mail Merge plans, billing and cancellation
• Admin setup: enable Mail Merge for your organization