KR Mail Merge: 100 free emails a day from Google Sheets
Write one email, and send a personalised copy with attachments to everyone on your Google Sheet, from your own Gmail. 100 a day, free. Other free mail merge plans stop at 20 or 50.
- 100 emails a day, free
- Attachments and scheduling included
- English & Hindi templates
100 a day. Free.
Most mail merge tools cap their free plan well below what Gmail allows. We don't add a cap of our own: you get Gmail's full daily limit.
| Mail merge tool | Free emails a day |
|---|---|
| KR Mail Merge | 100 (free Gmail) · up to 1,500 (Google Workspace) |
| Mailmeteor (free plan) | 50 |
| YAMM (free plan) | 20 |
Other tools' limits are from their own pricing pages, checked on 5 October 2026, and may change. Our 100 is Google's own daily limit for a free Gmail account (CC and BCC count too); Google Workspace accounts get up to 1,500.
Personal emails, at scale, from your own Gmail
Personalised everything
Use {{First Name}}, {{Amount}} or any column in the subject and message. Amounts show the Indian way: ₹1,25,000.
Attachments per person
Attach one file for everyone, or a different file for each person (their invoice, pass or certificate). Upload once and type the file name in the Sheet.
Schedule it
Send now or pick a date and time. It sends even if your computer is off. Lists over the daily limit carry on by themselves the next day.
Ready templates in English & Hindi
Fee reminder, invoice and event pass, each in English, Hindi and English + Hindi. Pick one, edit it, done.
Test first, then track every row
Preview each person's email and send yourself a test. Then see sent, waiting, skipped or failed next to each person. Nobody gets the same email twice.
No inbox access
The tool can only send email. It can't read your inbox, drafts or other emails.
Four steps, about five minutes
Get your free copy
One click makes your own copy of our ready Google Sheet. Nothing to install, no account with us.
Add your list
Type or paste names, emails and any details (amount, due date, invoice number).
Pick a template & test
Choose a ready English or Hindi template or write your own, then send a test to yourself.
Send or schedule
Send to everyone now, or at a time you choose.
The first time, Google shows "Google hasn't verified this app". That's because the tool runs as your own copy, inside your account. Click Advanced, then Go to KR Mail Merge (unsafe), then Continue. You only do this once; see the 3-click guide below.
Use it for people who expect your email, such as customers, students, members or event participants. Sending unsolicited bulk email can get a Gmail account blocked. Tick "Unsubscribed" for anyone who asks to stop, and the tool skips them.
The one-time Google screen, in 3 clicks
Your copy runs inside your own Google account, so Google asks you once to confirm. Nothing is shared with us.
-
1. Click "Advanced"
Google shows this for every tool that runs as your own copy. It's expected.
-
2. Click "Go to … (unsafe)"
It names our tool. Google uses the word "unsafe" for every app it hasn't reviewed yet; ours is in its review.
-
3. Tick "Select all", then "Continue"
Each permission is explained below. The tool needs all of them to work, and asks again if one is unticked.
Pictures are simplified; Google's screens may look slightly different. You can remove the tool's access at any time at myaccount.google.com/permissions.
What the tool can access, and why
We request only what the tool needs. This list matches what Google shows you the first time.
Use of information received from Google APIs follows the Google API Services User Data Policy, including its Limited Use requirements.
| Permission | Why it's needed |
|---|---|
| The spreadsheet you open it in | To read your recipient list and write each row's status. |
| Send email as you | To send the personalised emails from your account. |
| Drive: only files the tool creates | To keep the attachments you upload in its own folder. Nothing else in your Drive. |
| Connect to an external service | Only to Google's own Drive address, to attach the files you uploaded. |
| Run when you're not there | To send scheduled emails, and to carry on the next day after the daily limit. |
| See your email address | To send the test email to you. |
- No access to your Gmail inbox, drafts or other emails.
- Your recipient list stays in your own Google account.
- We never sell or share your data, or use it for advertising or AI training.
- Revoke access anytime at myaccount.google.com/permissions.
Is KR Mail Merge really free?
Yes. KR Mail Merge is free, including attachments, scheduling and templates. If you need more, such as sending beyond Gmail's limits through a professional email service, KR Software & Automation can build a custom version as a paid service.
How many emails can I send per day?
100 a day from a free Gmail account, and up to 1,500 from Google Workspace. These are Google's own limits; we add no cap of our own. CC and BCC addresses count too. If your list is longer, the rest are sent automatically the next day. The tool shows how many you have left.
Can I write emails in Hindi?
Yes. The ready templates come in English, Hindi and English + Hindi, and you can write your own email in any language.
Why does Google say the app isn't verified?
Your copy of the tool runs inside your own Google account, so Google shows this screen once. Click Advanced, then "Go to KR Mail Merge (unsafe)", then Continue. See the 3-click guide. We've also applied for Google's Marketplace review; when it's approved, you can install it from there without this screen.
Can the tool read my emails?
No. KR Mail Merge can only send the emails you write in it. It has no access to your inbox, drafts or other emails.
Will emails come from my own address?
Yes. Emails are sent from your own Gmail or Google Workspace address, so replies come straight back to you.
I made a mistake in an email. Can I send it again?
Yes. Fix the message or the person's details, clear that person's Status cell, and press Send. Only the people with an empty Status get the email, so nobody else gets it twice.
Can I use it on my phone?
Please use a computer (Chrome, Edge or Firefox). The Google Sheets phone app doesn't show the tool's menu. Your recipients can of course read the emails on any phone.
The panel shows an error or keeps loading
This usually happens when several Google accounts are signed in in the same browser. Open your Sheet in an Incognito/Private window with just one account. Still stuck? Tell us and we'll reply by email.
Does it work with a school or company Google account?
Usually yes. Some schools and companies block tools Google hasn't reviewed yet; you'll then see a "blocked by your administrator" message. Ask your IT admin to allow it, or use a personal Gmail account until our Marketplace version is approved.
What users say about KR Mail Merge
Be the first to rate KR Mail Merge. We publish only genuine reviews from real users, with their permission.
Need it customised, or have a question?
Tell us what you'd change and we'll quote a custom version that runs in your own account. For help with the free tool, use Support.