“Mail merge in Gmail” is searched about 1,000 times a month in India. It is the go-to method for founders sending investor updates, HR teams sending offer letters, colleges emailing students, sales teams sending personalised outreach, and small businesses announcing a new service.
Mail merge is simple to set up. What trips people up are the sending limits and the bounces that follow when a spreadsheet full of old or mistyped addresses meets Gmail’s reputation systems. This guide covers both.
What Mail Merge in Gmail Does
Mail merge sends one personalised copy of an email to each recipient in a list. Fields such as first name, company, or amount are pulled from a spreadsheet and inserted into the message, so each person receives an individual email rather than a group message with everyone in the “To” line.
Recipients cannot see each other, replies arrive as separate threads, and the email reads as a one-to-one message.
Gmail and Google Workspace Sending Limits
| Account type | Daily sending limit | Mail merge limit |
|---|---|---|
| Free Gmail (@gmail.com) | 500 recipients per day | Native mail merge not available |
| Google Workspace (paid, active billing) | 2,000 messages per user per day | 1,500 recipients per day via mail merge |
| Google Workspace (trial) | 500 per day | Reduced until billing threshold is met |
Three details matter:
- Limits count recipients, including CC and BCC.
- On Workspace, once your combined regular and mail merge sends reach 1,500, mail merge stops for the day; the remaining 500 are reserved for regular email.
- Exceeding limits triggers a “reached a limit for sending mail” error and can block sending for up to 24 hours.
Method 1: Gmail’s Built-In Mail Merge
Available on Workspace Individual, Business Standard and Plus, Enterprise and eligible Education plans.
- Prepare a Google Sheet with columns such as First Name, Last Name, and Email.
- In Gmail, click Compose.
- Next to the “To” line, click Use mail merge.
- Add recipients from a Google Contacts label or link your Google Sheet.
- Insert merge tags such as @firstname in the subject or body.
- Send a preview to yourself, then send.
Native mail merge adds an unsubscribe link automatically. It supports only basic tags (first name, last name, full name, email) and has no open tracking or scheduling.
Method 2: Google Sheets Add-ons
Free Gmail users and teams needing more fields, scheduling, or tracking typically use a mail merge add-on from the Google Workspace Marketplace. The workflow is similar: prepare the sheet, draft a Gmail template with placeholders, run the merge from the add-on menu.
Add-ons still send through your Gmail account, so the same daily limits apply.
Why Mail Merge Campaigns Bounce
The spreadsheet is usually the problem. Common sources:
- Old lists. An alumni database from 2019 or a customer list from a previous business.
- Manual entry typos: gmail.com, yahoo.co, spaces, and missing characters from event registration forms.
- Copied lists combined from multiple files without checks.
- Job changes. Corporate addresses deleted when employees move on.
Gmail’s systems watch bounces closely. A Workspace account that sends 1,000 merged emails with 80 bounces looks like a sender with a poorly maintained list, and future emails from that account, including routine ones to clients, become more likely to land in spam.
Worse, the bounce notifications flood your inbox as “Mail Delivery Subsystem” messages. Our guide to what “email undeliverable” means decodes them.
Clean Your Sheet Before You Merge
Because mail merge already runs from Google Sheets, verification belongs in the same sheet, right before you send.
- Remove duplicates using Data > Data cleanup > Remove duplicates.
- Trim spaces with Data cleanup > Trim whitespace.
- Run email verification inside the sheet. BounceProof’s Google Sheets add-on writes a status beside every address, with no CSV export or upload.
- Filter to keep only valid addresses for the merge.
- Hold risky and catch-all contacts in a separate tab for a smaller, later send.
- Remove invalid and disposable addresses entirely.
A step-by-step walkthrough is in how to verify emails in Google Sheets.
A worked example
A Pune-based training institute has 1,800 past-student emails for a new course announcement. Sent unverified from a Workspace account, a typical 8–10% invalid rate means roughly 150 bounces and a two-day sending pause due to limits. Verified first, the institute removes around 150 invalid addresses, sends to the valid 1,650 across two days within the 1,500 cap, and keeps its account reputation intact for regular client email.
Mail Merge Best Practices
- Stay well under the limits. Split large lists across days rather than hitting 1,500 at once.
- Warm up new accounts. A new Workspace account sending 1,000 emails on day one looks suspicious.
- Personalise beyond the first name. A merged email that reads like a template still gets ignored.
- Keep formatting light. Plain text or simple formatting delivers better than heavy HTML.
- Include an opt-out and honour it. Native mail merge adds one automatically.
- Test first. Send to yourself and a colleague on a different provider.
- Authenticate your domain with SPF, DKIM and DMARC. See Google Workspace deliverability settings.
When to Move Beyond Gmail
Gmail mail merge suits hundreds of personalised messages. It is the wrong tool when you need:
- Thousands of recipients per send.
- Scheduled campaigns, segmentation or analytics.
- Recurring newsletters to subscribers.
- Transactional email at scale.
At that point, use a dedicated email service provider. Our guide to bulk email service providers in India compares the options.
Key Takeaways
- Free Gmail allows 500 recipients a day; Workspace allows 2,000, with 1,500 via mail merge.
- Native mail merge requires eligible Workspace plans; free users rely on add-ons.
- Bounces from old or mistyped sheets damage account reputation.
- Verify addresses inside the same Google Sheet before merging.
- Split large lists across days and move to an ESP for volume or recurring campaigns.
Frequently Asked Questions
Gmail’s native mail merge requires eligible Google Workspace plans. Free Gmail users can use Google Sheets mail merge add-ons, within the 500-recipient daily limit.
Up to 1,500 recipients a day on eligible Workspace accounts through native mail merge, within a 2,000 total daily limit. Free Gmail is capped at 500.
Usually because the spreadsheet contains invalid, mistyped, or outdated addresses. Verify the list before sending.
It can. High bounce rates and sudden volume spikes from a Gmail account can push future emails toward spam.
Verify the list, stay under daily limits, authenticate your domain, personalise meaningfully, and include an unsubscribe option.
Conclusion
Mail merge in Gmail is one of the most practical tools available to small Indian teams: free or low-cost, familiar and personal. Its limits are real, but manageable, and most problems attributed to Gmail are actually problems with the spreadsheet.
Treat the sheet as the product. Deduplicate it, verify it, segment it, and send in sensible batches. Done that way, mail merge becomes a reliable channel rather than a reputation risk hiding inside your everyday inbox.
