Easy Mail Merge

Simplest way to communicate with your audience

Easily prepare and send personalized, attachment-rich bulk emails straight from Google Docs & Sheets. Perfect for any campaign — newsletters, promotional offers, updates — it lets you easily connect info from Google Sheets, ensuring every recipient feels uniquely addressed. Plus, with the ability to see send statuses, you'll know which emails have left your Gmail, allowing for swift adjustments or resends as needed.

Test unlimited mail merging for 30 days for free

With Easy Mail Merge you will

  • Mail merge from Google Docs Prepare emails in Google Docs and connect with your Google Sheets mailing list to send personal emails from Gmail.
  • Personalize emails Use special placeholders from connected Google Sheets data in your emails to ensure each message is tailored to each recipient.
  • Send Google Drive files as attachments Convert Google sheets, docs, slides into MS Office or PDF attachments in a snap.
  • See a test email before the final send Send a sample of your mail merge email directly to your account for a final review.
  • Mail merge from Google Sheets Run Easy Mail Merge right from the mailing list in spreadsheets and add email template from your existing Gmail Drafts.
  • Send current file as PDF Convert your currently opened Google doc or Google sheet into PDF to mass-send it as a personalized attachment for each recipient.
  • Send personal links to shared Google Drive files Share large files or documents that require collaboration.
  • Monitor email dispatch status Track send statuses for each recipient for immediate follow-up if necessary.

How to Easy Mail Merge from Google Docs & Google Sheets

Personalize and send emails from your Gmail account using mail merge in Google Docs.
Personalize and send emails from your Gmail account using mail merge in Google Docs.
Or mail merge from Google Sheets using your Gmail templates.
Or mail merge from Google Sheets using your Gmail templates.
Add a mailing list from Google Sheets with the personalized info for all recipients.
Add a mailing list from Google Sheets with the personalized info for all recipients.
Set up the recipient and other extra fields if needed: <em>Cc, Bcc, Sender name, Reply</em> to. Fill in the subject or pick a suitable placeholder to personalize it per recipient.
Set up the recipient and other extra fields if needed: Cc, Bcc, Sender name, Reply to. Fill in the subject or pick a suitable placeholder to personalize it per recipient.
Personalize your email template using placeholders from your mailing list.
Personalize your email template using placeholders from your mailing list.
When working from Google Sheets, pick one of the existing drafts as your email template.
When working from Google Sheets, pick one of the existing drafts as your email template.
Attach or share personalized files from your mailing list, and even send the current doc/sheet as a PDF attachment for each recipient.
Attach or share personalized files from your mailing list, and even send the current doc/sheet as a PDF attachment for each recipient.
Check email status and easily exclude recipients from campaigns straight from your mailing list.
Check email status and easily exclude recipients from campaigns straight from your mailing list.

Frequently asked questions

Can I mail merge from Google Docs?

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.

Can I mail merge from Google Docs using its standard features?

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 :)

How do I mail merge from Google Docs exactly?

  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.

Can I mail merge from Google Sheets?

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.

How can I personalize emails with Easy Mail Merge?

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.

Can I send attachments using your mail merge software for Google Docs?

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.

Can I send emails with personalized attachments using Easy Mail Merge?

Yes, you can send mail merges from Gmail with personalized attachments provided your mailing list in Google Sheets includes a column with links to these files.

Is it possible to convert Google Drive files to email attachments?

Yes. With just one checkbox, Easy Mail Merge will convert Google documents, spreadsheets, and presentations from your Drive into PDFs or MS Office file attachments.

Can I share Google Drive files or send personal links to files through email?

Yes, provided the links to Drive files are in your mailing list. You'll be able to fine-tune sharing settings via Easy Mail Merge before inserting links to the email.

Can I see how the email will look like before running my mail merge campaign?

Yes. Use a Test button to send the sample email to your Inbox for review.

How can I see if an email has been successfully sent from my Gmail?

Check your mailing list. Easy Mail Merge adds the Email Status column and fills it accordingly for each recipient. You'll know if the email has been successfully sent from your Gmail, and at what time exactly.

How can I exclude specific recipients from a mail merge without removing them from the mailing list?

Simply pop something like "X" or "skip" into the Email Status column next to their names in your Google Sheets mailing list before beginning your mail merge campaign. The add-on will then bypass any recipients marked in that Status column. It's a simple way to include/exclude individuals for specific campaigns without fiddling with your entire mailing list.

What are the limits on the number of emails I can send with Easy Mail Merge?

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.

Choose your plan

1-month

  • 1-month access with all
    updates
$3.99
Buy now

12-month

  • 12-month access with all updates
$33.60
$19.99
Buy now

System requirements

Windows IconOperating Systems
  • Windows: Windows 10 and up
  • Mac: macOS Catalina 10.15.7 and up
  • Chrome OS™
Google Chrome IconBrowsers
  • Chrome™
  • Firefox
  • Safari (Mac only)