Free Mail Merge for Gmail and Google Sheets
Can you mail merge in Gmail for free? Gmail's built-in option, Apps Script and free add-on tiers compared. Mail Merge for Gmail and Sheets: 11 free emails.
Free Mail Merge for Gmail and Google Sheets: What You Can Send Without Paying
Yes, you can mail merge in Gmail for free. Write a Google Apps Script if you code, use Gmail’s built-in mail merge if you have an eligible Google Workspace plan, or use a free add-on tier. Mail Merge for Gmail and Google Sheets gives you 11 free emails to start, with open and click tracking, test emails and Google Contacts import included. Paid plans start at $4.99 a month.
Start free with Mail Merge for Gmail and Sheets →
Can you mail merge in Gmail for free?
Yes, in more than one way. The right choice depends on how many emails you send, whether you need scheduling or a different attachment for each person, and how much setup you’re willing to do.
Free option 1: Gmail’s built-in mail merge
Gmail’s own mail merge costs nothing extra, but it is plan-gated. It is included only on eligible Google Workspace plans: Workspace Individual, Business Standard and Plus, Enterprise Standard and Plus, and Education Standard and Plus. Free @gmail.com accounts can’t use it. You start it from Compose (Use mail merge) and personalize with tags such as @firstname, or with columns from a linked spreadsheet (first tab, text only). Google allows up to 1,500 mail merge recipients a day.
Free option 2: Google Apps Script
Apps Script is free and can read your sheet and send through Gmail. The trade-off is technical: you write and maintain code and manage authorization. Scripts are bound by Google’s Apps Script email quota: about 100 recipients a day on @gmail.com and 1,500 on Workspace. Great for developers, frustrating if you just want to send a campaign this afternoon.
Free option 3: a free add-on tier
Most Sheets mail merge add-ons have a free tier for small sends. What’s included and where the cap sits differ by vendor and change over time, so check each tool’s pricing page. A free tier is a good way to try the workflow and run small lists.
What’s free in Mail Merge for Gmail and Sheets
| Feature | Free | Paid (from $4.99/month) |
|---|---|---|
| Emails | 11 free emails to start | See plan details |
| Open and click tracking | Yes | Yes |
| Send Test Email | Yes, doesn’t use free emails | Yes |
| Import Google Contacts | Yes | Yes |
| Sender name and Reply-to | Yes | Yes |
| Files attached to the Gmail draft | Yes | Yes |
| Footer “Sender notified by Mail Merge for Gmail” | Added to each email | Removed |
| Schedule for later | No | Yes |
| A different attachment per recipient | No | Yes |
| Google’s daily quota | About 100 (@gmail.com) or 1,500 (Workspace) | The same |
Paid plans start at $4.99 a month or $49.99 a year. Other tools’ free tiers have their own caps, set by each vendor; check their pricing pages before you compare. The honest takeaway: free is fine for getting started and small sends. More volume, scheduling and per-recipient attachments are the usual reasons to upgrade.
How to start free with Mail Merge for Gmail and Sheets
- Install the add-on and open Extensions → Mail Merge for Sheets™ Gmail™ → Launch in a Google Sheet. It creates the Email, First Name, Last Name and Mail Merge headers.
- Add your recipients, one per row, or use Import Google Contacts.
- Write a Gmail draft with placeholders like
{{First Name}}. - Click Start New Campaign, pick the draft and click Send Test Email. The test goes only to you and doesn’t use your free emails.
- Start the campaign. Each sent email uses one free email. When they run out, the remaining rows get
CLICK_GO_PREMIUM__NO_CREDITS_LEFT. After you upgrade, run the campaign again and those rows are sent.
Limits and deliverability to keep in mind
Google’s daily limits apply on every tier. Add-ons and scripts that send through Apps Script get about 100 recipients a day on @gmail.com and 1,500 on Google Workspace (source: Google’s Apps Script quotas). Gmail’s own limit of 2,000 messages a day for Workspace users covers mail sent in Gmail itself, not Apps Script.
Email only people who expect to hear from you, include a clear opt-out (the add-on doesn’t add one), keep copy non-spammy, and send a test first. Consent rules like CAN-SPAM and GDPR are your responsibility as the sender.
Free mail merge FAQ
Is there a truly free way to mail merge in Gmail?
Yes. Google Apps Script is free. Mail Merge for Gmail and Sheets gives you 11 free emails to start, including on free @gmail.com accounts. Gmail’s built-in mail merge is included on eligible Workspace plans only.
How many free emails do I get with Mail Merge for Gmail and Sheets?
11 free emails to start. Test emails don’t count. Open and click tracking, test emails and Google Contacts import are included. Free emails carry a small footer with a link to docgpt.ai.
Why do free mail merge tools have send limits?
Free tiers protect the vendor’s costs, and Google caps daily recipients too. So you see both a tool’s free cap and Google’s daily quota.
When should I upgrade from a free mail merge?
Upgrade when your free emails run out, or when you need to schedule a campaign, send a different attachment to each recipient, or remove the footer. Open and click tracking is already free.
Does free mail merge affect deliverability?
The plan doesn’t change Google’s rules or daily quota. Deliverability depends on emailing consented contacts, keeping copy non-spammy, including an opt-out and pacing your sends. On the free plan, each email ends with a small footer; paid plans remove it.
Start free, upgrade only when you grow
Keep your list in Google Sheets and send your first personalized emails at no cost. When you need scheduling, per-recipient attachments or more volume, paid plans start at $4.99 a month.
Try Mail Merge for Gmail and Sheets →
