MailroomSign in

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.

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

Step by step

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

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

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

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

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

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