Google Workspace Marketplace
Send personalized emails from Google Sheets™ through your Gmail™. Schedule sends, attach a file per recipient, and see who opened, how many times, and which links they clicked.
By:
Listing updated:November 18, 2026
Works with:
28K+
Overview
Write one email, and everyone on your list gets a version addressed to them. Mail Merge takes a draft from your Gmail™ account and a list in Google Sheets™, fills in each person's details, and sends the emails from your own address. Test it on yourself, send now or later, and see who opened your email, how many times, and which links they clicked, right in the sheet and in a campaign dashboard inside the add-on.

QUICK START
Open any spreadsheet and choose Extensions > Mail Merge for Gmail Sheets > Try with an example. The add-on creates a sample list with you as the only recipient, a sample draft, and sends you a test email, so you see the whole flow in a minute.

HOW TO USE
1. Click Install and allow access.
2. Open a spreadsheet, then Extensions > Mail Merge for Gmail Sheets > Launch.
3. Click Check Sheet Setup. It adds the columns Email, First Name, Last Name and Mail Merge. Paste your contacts or import them. Add more columns, such as Company, on the right.
4. In your mailbox, write the email and save it as a draft. Put column names in double braces, for example "Hi {{First Name}},". The name must match the column header exactly. This works in the subject too.
5. In the sheet, click Start New Campaign and select the draft.
6. Optional: set a sender name or reply-to address. Open and click tracking is on by default.
7. Click Send Test Email. The test comes to you, filled in with the first row.
8. Click Start Campaign, or choose "Schedule for later" and pick a date and time.
9. Watch the Mail Merge column: EMAIL_SENT, then EMAIL_OPENED or EMAIL_CLICKED. Click Refresh Email Status for the latest: the Opens, Clicks and Clicked links columns show how many times each person opened and which links they clicked.
10. Open Extensions > Mail Merge for Gmail Sheets > Open Campaign Report for the campaign dashboard.

FEATURES
- Any column can be a {{placeholder}} in the subject or body.
- Your draft's formatting, links and attachments are kept.
- Schedule in your time zone, or cancel a scheduled send from the report.
- Per-recipient tracking in the sheet: how many times each person opened your email, which links they clicked and how often.
- A campaign dashboard inside the add-on: open and click rates, a Sent > Opened > Clicked > Replied funnel, your most-clicked links and a ranked list of your most engaged recipients.
- A different file for each person, matched by the email address in the file name (files from Google Drive™).
- Delay between emails and a cap per launch, to send long lists in batches.
- Rows already sent, or marked SKIP, are skipped when you run it again.
- Sent emails stay in your Sent folder; replies come to your inbox.

TRIAL, PLANS AND DAILY LIMITS
New accounts get 11 emails to try it, plus a few more during the first week. Tracking is included. Trial emails end with a one-line note about the add-on. Paid plans remove the note, raise your sending volume and add scheduling and personalized attachments: https://docgpt.ai/mail-merge-for-gmail-and-sheets/
Google limits how many recipients an add-on can email: 100 a day on personal accounts, 1,500 a day on Google Workspace™ accounts. The count resets 24 hours after your first send. If a campaign hits the limit, the remaining rows wait in the sheet and Mail Merge sends them automatically when the limit resets. Long lists are sent in batches, and an interrupted campaign can be continued with Continue Campaign.

WHO USES IT
Small businesses send invoices and payment reminders. Recruiters send interview invitations with a file for each candidate. Schools write to parents, nonprofits thank donors, and shops send welcome and abandoned cart emails.

PRIVACY
Your list stays in your spreadsheet, and emails go out through your own account. To report opens and clicks, our server records the recipient's address and the time of each open or click. Turn tracking off and no tracking data is collected. The add-on passed an independent CASA Tier 2 security assessment. Privacy policy: https://docgpt.ai/privacy_mail_merge

TROUBLESHOOTING
- Draft not listed: save it as a draft, then click Refresh.
- {{...}} shows in the email: the text in braces must match the column header exactly.
- A row says INVALID_EMAIL or "Error": check that row's email address; invalid rows are skipped and the rest are sent.
- Help center: https://docgpt.ai/docs/mail-merge/

Names marked ™ are trademarks of Google LLC. Mail Merge is made by docgpt.ai and is not affiliated with Google.
Additional information
PricingFree of charge with paid features
Developer
Non-trader
Support
Privacy policy
Terms of service
Mail Merge for Gmail™ Sheets™ will ask for the permissions shown below. Learn more
Mail Merge for Gmail™ Sheets™ will need access to your Google account
This will allow Mail Merge for Gmail™ Sheets™ to :
View and manage spreadsheets that this application has been installed in
See, edit, create, and delete only the specific Google Drive files you use with this app
Send email on your behalf
Manage drafts and send emails
Manage drafts and send emails when you interact with the add-on
Run as a Gmail add-on
View your email messages and settings
See and download your contacts
Connect to an external service
Display and run third-party web content in prompts and sidebars inside Google applications
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
David Bryan
September 25, 2025
Our small non-profit couldn't afford expensive CRM software. This add-on has been a game-changer for our donor communication. We can now easily send personalized thank-you emails and updates to hundreds of supporters by simply managing a Google Sheet. The link tracking helps us see what resonates. It’s powerful, reliable, and free. Thank you!
Is this review helpful?
Yes
No
Profile Picture
Hannah Mike
September 25, 2025
I've tried several mail merge solutions, and this is the most reliable. The connection between Sheets and Gmail is rock solid. I love the advanced features like adding attachments and the "send as draft" option, which allows for a final review. The emails are delivered through Gmail's servers, so they don't get flagged as spam. A perfectly executed tool.
Is this review helpful?
Yes
No
Profile Picture
Walter Owen
September 26, 2025
We use this for internal communications and smaller, targeted customer campaigns. It's incredibly cost-effective and integrates with the Google ecosystem we already use. It's not a replacement for a full-scale marketing automation platform, but for quick, personalized blasts, it's unbeatable. Reliability is key, and this add-on delivers.
Is this review helpful?
Yes
No
Profile Picture
Elmohd Digital
September 25, 2025
I used to dread sending personalized newsletters to my clients. This add-on has cut my work from hours to minutes. The interface is so simple—I just update my Google Sheet and hit send. The ability to track opens is invaluable. It feels like having a premium marketing tool for free. Highly recommended for any entrepreneur!
Is this review helpful?
Yes
No
Profile Picture
Angela Schulz
December 9, 2025
Can't get it to work, paid for premium for the year, no receipt. Nobody is answering my chat questions and there's no other way to get a hold of them. Did they go under?
Is this review helpful?
Yes
No
Profile Picture
Steven jason
September 25, 2025
I use this to send progress updates to parents. Creating a sheet with each student's name and a brief, personalized comment is easy. The emails look like they came directly from my inbox, which feels more professional than a mass BCC. I'm giving 4 stars only because I wish the daily sending limit was a bit higher for school-wide announcements. Otherwise, it's fantastic.
Is this review helpful?
Yes
No
Profile Picture
Ivan Dunskiy
June 18, 2025
I’ve been using Mail Merge for Gmail & Sheets weekly to reach out to clients and partners, and it’s truly streamlined our workflow. Here’s why I love it: - Effortless integration: I draft emails in Gmail, merge contacts from Sheets, and hit send—no need to juggle third-party apps. - Live tracking in Sheets: Opens, clicks, replies, and bounces update automatically in my spreadsheet—makes follow-up a breeze . It’s become our go-to for client outreach—simple, secure, and effective. If you’re a freelancer or a small business, this one’s a winner!
Is this review helpful?
Yes
No
Profile Picture
Auncon M.
June 16, 2026
best ad ones
Is this review helpful?
Yes
No
Profile Picture
Charles Promotion
September 25, 2025
For targeted, personalized outreach to a list of 50-100 prospects, this tool is perfect. It’s much more efficient than manual emails and avoids the cold, robotic feel of larger platforms. The setup is straightforward. I deducted one star because I once hit a temporary sending limit, so just be aware of that for very large, time-sensitive campaigns. For most sales needs, it's excellent.
Is this review helpful?
Yes
No
Profile Picture
Bohdan Makar
September 26, 2025
I use this to send invoices and project updates to my clients. Instead of copying and pasting the same email, I can personalize each one with the client's name and project specifics. It makes my communication look much more professional and organized. The fact that it works right inside Gmail is the best part. No need to switch between different apps.
Is this review helpful?
Yes
No
1-10 of 27
Search
Clear search
Close search
Google apps
Main menu