How to do a Gmail mail merge without Google Sheets
You do not need Google Sheets for a Gmail mail merge. Tools such as YAMM and Mailmeteor are Sheets add-ons, so your list has to live in a spreadsheet they can access. Mailroom reads a CSV file directly: upload it, write one email with merge tags and send from your Gmail account.
Step by step
Get your list as a CSV
Export it from wherever it lives: your CRM, a booking system, a form tool, Excel, Numbers. Almost everything can export CSV. Keep the header row.
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
- A Sheets add-on needs permission to see your spreadsheets. A CSV upload shares one file, once.
- If your list already is a Google Sheet, that works too: File, Download, Comma-separated values (.csv).
- Mailroom shows who has been sent to and who opened, inside the project. It does not write results back into a spreadsheet.
- 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.
Common questions
Why do most mail merge tools need Google Sheets?
Because they are built as Google Workspace add-ons, which run inside Sheets. It is convenient if your contacts already live there, and a hurdle if they do not.
Can I mail merge from Excel?
Yes. Save the workbook as CSV UTF-8 and upload that file. See the separate guide to mail merge from Excel to Gmail.
Is there a limit on the number of columns?
No practical one. Every column in the file becomes a merge tag you can use in the subject or the body.
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