MailroomSign in

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.

Try it free100 emails a day free. No card, nothing to install.

Step by step

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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

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