Mail Merge for Sheets & Gmail

Yes, you can mail merge from Google Docs using the Easy Mail Merge add-on. It lets you create personalized emails in Google Docs (with the data from connected Google Sheets) and send these customized emails through Gmail.

No, Google Docs doesn't offer a built-in mail merge feature. However, Easy Mail Merge software for Google Docs fills this gap and extends Docs capability in this regard :)

1. Prepare an email template in Google Docs.
2. Run the add-on from Extensions > Easy Mail Merge > Start.
3. Upload your mailing list from Google Sheets.
4. Customize your template with placeholders (that carry personal info for each recipient from your mailing list).
5. Attach or share Google files for all or each recipient.
6. Click Send.

See a more detailed description here.

Yes, if you have template emails prepared in your Gmail Drafts.

1. Prepare your template in Gmail Draft.
2. Open your mailing list and run the add-on from Extensions > Easy Mail Merge > Start.
3. Add an email template from Gmail and pick a template.
4. Attach or share Google files for all or each recipient.
5. Click Send.

See a more detailed description here.

First, organize your contact information and any personalized data (like names, addresses, etc.) in a Google spreadsheet.

Next, upload this mailing list to Easy Mail Merge. The add-on will automatically recognize the columns in your sheet and suggest them as placeholders for your email template.

When you send this email in bulk, each placeholder will be replaced with the corresponding personalized info for each recipient, making each email uniquely tailored.

Yes. You have the flexibility to attach common file types, convert Google Drive documents to attachments in such formats as PDFs or MS Office files, or even share Google Drive files by sending direct links within your emails.

What's more, you can convert your currently viewed Google document or Google sheet to PDF to send it as a personalized attachment to each recipient. In this case, the add-on will provide another field for you to enter the email body.

During the trial, you can send as many bulk emails as your Google account allows: 100 emails per day from a free Google account and 1500 emails from a business Google account.

Once the trial ends, the free version becomes limited to 50 emails per day. To remove the add-on limit and fully utilize Gmail maximum sending capacity for your account, upgrading to one of the paid plans is required.