Looking for a free Gmail mail merge solution that actually works without paid subscriptions or complicated scripts? You have options — and they are simpler than you might think.
What is a Gmail mail merge?
A mail merge lets you send a personalized email to a list of recipients, where each message is automatically customized with their specific details — name, company, offer, or any other data you have.
Instead of sending 100 identical emails (or writing 100 individual ones), you:
- Write one template with variable placeholders.
- Connect it to a list of contacts in a spreadsheet.
- Send — each person gets a unique, personalized message.
Free options for Gmail mail merge
Several approaches exist, at different levels of technical complexity:
| Tool | Cost | Requires code? | Volume limit |
|---|---|---|---|
| GSheetMailer | Free | No | 500/day (Gmail) |
| Apps Script (GAS) | Free | Yes (JavaScript) | 500/day |
| Mailmeteor (free tier) | Free / paid | No | 50/day free |
| YAMM (free tier) | Free / paid | No | 50/day free |
For a no-code, fully free solution with no daily limits on the tool itself, GSheetMailer is the most straightforward option — the only limit is Gmail’s own sending quota (500/day for free Gmail).
How to do a free Gmail mail merge with GSheetMailer
Step 1: Set up your Google Sheet
Create a spreadsheet with one column per variable you want to use:
| FirstName | Company | Plan | |
|---|---|---|---|
| alice@example.com | Alice | Acme Corp | Pro |
| bob@example.com | Bob | TechStart | Starter |
Column names will become your template variables. Keep them clean — no special characters if possible.
Step 2: Install GSheetMailer
Install the GSheetMailer Chrome extension from the Chrome Web Store. It connects directly to your Google account — no external server, no API keys.
Step 3: Write your email template
Use double curly braces around column names to insert variables:
Subject: A quick idea for {{Company}}
Hi {{FirstName}},
I noticed {{Company}} is growing fast and I wanted to reach out
about {{Plan}} — I think it could be a great fit.
Would you have 15 minutes this week?
Best,
[Your name]Step 4: Send
Select your sheet, preview the first few emails to verify variables are correct, and send. Each email goes out individually from your Gmail account.
Gmail sending limits for free mail merge
- Free Gmail accounts: 500 emails per day
- Google Workspace accounts: 2,000 emails per day
For prospecting, follow-ups, event invitations, and small campaigns, these limits are rarely a bottleneck.
Why Gmail beats marketing platforms for small-volume personalized emails
- Better inbox placement: emails from your personal Gmail account rarely hit the Promotions or Spam tabs.
- Human appearance: recipients see a real email, not a newsletter with an unsubscribe footer.
- No cost: no paid plan required for the tool or the sending infrastructure.
- Simple: no onboarding, no domain authentication setup, no deliverability wizards.
FAQ
Is free Gmail mail merge legal? Yes, for B2B outreach to professional email addresses. For B2C (sending to consumers), you need explicit consent under GDPR or CAN-SPAM.
Can I personalize the subject line too? Yes. Variables work in the subject line exactly the same way as in the body.
What happens if a cell is empty? The variable is replaced with an empty string. Always review your data before sending.
Do recipients know this was sent in bulk? No. Each email is sent individually from your Gmail address with no indication it was part of a larger campaign.
Conclusion
A free Gmail mail merge is 100% achievable in 2026 without spending a cent on tools. Google Sheets + GSheetMailer gives you everything you need to send hundreds of personalized emails from your own Gmail account.