GIMM · Free for everyone
GIMM — Google Is Missing Mailmerge
Why Google got no mailmerge.
Free mail merge for Google Sheets. GIMM sends one personal email to each person on a list in your Sheet, from your own Gmail account. No paywall, no server, no tracking.
Install: coming soon to the Google Workspace Marketplace. This page will link to the listing as soon as it is live.
How it works
- Put one person per row in a Google Sheet — name, email address, and anything else you want to personalise with.
- Open GIMM from the menu in Sheets and write your template in the sidebar, using markers like
{{First name}}for any column. - Preview the exact email one person will receive, then send a test to yourself.
- Send to everyone. GIMM writes
Sentand the time back to your Sheet, row by row.
What it does
- Sidebar template editor — write your subject and message in Sheets, with marker chips for every column in your Sheet.
- Personalisation with fallbacks —
{{First name|Friend}}means an empty cell becomes “Friend”, never “Dear , ”. - Preview any row — see the exact email that person will receive before anything is sent.
- Test send first — Send All stays locked until you have sent a test to yourself.
- One email per person — never a group email, always from your own account.
- Status tracking in the Sheet — GIMM adds
GIMM Status,GIMM Sent AtandGIMM Notecolumns and writesSent,FailedorSkippedwith a plain-language reason. Rows already markedSentare always skipped, so resuming is safe. - Quota guard — GIMM reads your real remaining daily quota before sending and stops cleanly at the limit instead of failing halfway through a list. Google's own limits apply: 100 recipients a day on a personal Gmail account, 1,500 a day on Google Workspace.
- Resumable sends — Google stops any script after 6 minutes, so GIMM sends in batches and saves its place. Press Resume and only unsent rows go out.
- Per-person attachments — one shared attachment for everyone, and/or a different file per person from a column holding a Drive link or file ID. Google Docs, Sheets and Slides are attached as PDF.
- CC / BCC — fixed CC/BCC for the run, plus optional per-row CC/BCC columns. Every CC/BCC address counts against your daily quota, and the sidebar says so.
- Send from an alias — if you have a Gmail “Send as” alias, you can use it.
- Optional unsubscribe line — adds a “To unsubscribe, email …” footer. Replies arrive as ordinary emails; you remove people in the Sheet yourself.
- Visible rows only — tick the option to skip filtered-out rows.
- Sample sheet — GIMM can create a sample tab so you can try it without building a list first.
What it deliberately does not do
- No Gmail draft as a template. Your template lives in the sidebar (or a plain-text file you load). Picking a Gmail draft would need mailbox access, which is a different, costlier permission — a separate decision for a later version.
- No open, click or reply tracking. That needs a tracking pixel and a server. GIMM has no server.
- No scheduled sending and no automatic follow-ups.
- No automatic unsubscribe processing — that would need to read your inbox. GIMM cannot read your inbox.
- No import from Google Contacts — paste or import a CSV into the Sheet instead.
Privacy in one line: GIMM runs entirely inside your Google account via Google Apps Script, sends via MailApp, and sends no data to any external server. See the full privacy policy.
Who it is for
Anyone who needs to send the same kind of email to many people, each with their own name and details — a school, a small business, a club, a church group, a teacher, a community organiser — and does not want to pay a monthly fee for it.
Support
GIMM is published by Kavin Enterprises, Bengaluru, India. Support details will be added here when the Marketplace listing goes live.