How to do a mail merge in Gmail from a CSV file
Upload the CSV to Mailroom, write one email using the column names as merge tags (for example {{first_name}}), and press send. Each person in the file receives their own personalised email from your Gmail address. It takes about five minutes, needs no browser extension, and is free for up to 100 emails a day.
Step by step
Sign in with Google
Go to themailroom.cc and choose Continue with Google. This signs you in and connects the Gmail account you will send from. Mailroom asks only for permission to send; it cannot read your inbox.
Upload your CSV
Create a project and drop in a CSV file with a header row. One column must hold the email addresses; Mailroom finds it for you. Every other column becomes a merge tag. Addresses that would bounce (two in one cell, missing domain) are flagged with their row number before anything is sent.
Write one email with merge tags
Write the subject and body once. Wherever you want a value from the spreadsheet, type the column name in double curly braces, for example {{first_name}}. You can use bold, italic and links.
Preview and send yourself a test
Step through the preview to see exactly what each person will receive, then send a test to your own address. Mailroom warns you if a tag does not match any column.
Send, or schedule it
Press send. Each recipient gets their own individual email from your Gmail address, about one a second. Or pick a date and time and Mailroom sends it then.
Good to know
- The CSV needs a header row. Column names can contain spaces: a column called First Name is used as {{First Name}}.
- Exporting from Excel or Google Sheets: choose File, Download or Save As, CSV (UTF-8) so accents and non-English names survive.
- Gmail itself allows 500 recipients a day from a personal @gmail.com account and 2,000 a day from Google Workspace. No tool can raise that.
- Mailroom's free tier sends 100 emails a day and 300 a month. A 7-day pass (£7.99 / $9.99, one payment) or Pro (£15.99 / $19.99 a month) lifts that to Gmail's own limit.
- Mailroom sends text and formatted email. It does not send file attachments.
Common questions
Does the mail merge come from my own Gmail address?
Yes. Every message is sent by Gmail, through the official Gmail API, from the account you signed in with. Replies come straight back to your inbox and the sent emails appear in your Sent folder.
Do I need Google Sheets or a Chrome extension?
No. Mailroom is a web app that reads a CSV file directly. There is nothing to install and your contact list does not have to live in a Google Sheet.
What if a merge tag is missing for some people?
The preview shows each recipient's email exactly as it will be sent, so an empty value is visible before you send. Mailroom also warns you when a tag in your email does not match any column in the file.
Can recipients see each other?
No. Each person receives a separate email addressed only to them. Nobody is copied or blind-copied.
Related
Send your first one in five minutes
Sign in with Google, upload a CSV, write one email. 100 a day free.
Start with Mailroom