Mail Merge for Gmail
Send personalized mass email campaigns directly from your Gmail account. Achieve higher deliverability and open rates.
How to Mail Merge with Gmail and Google Sheets ?
Step 1: Prepare contact list in Google Sheets
Create a new Google Sheet (or use existing Sheet). Create a header row that contains column header names. Add the name, email address and other details of the recipients.
Step 2: Create an Email Template
Use the rich text editor to compose an email template. To insert data from spreadsheet contact list, use placecholders corresponding to the column names surrounded double curly braces, e.g.
Step 3: Send the emails
Click on Start Sending to start sending the personalized emails to the recipients. Once completed, click on View Report button to see a detailed campaign report.
Simple and easy-to-use mail merge features to save your time
Mailway Mail Merge addon requires absolute minimum permission to run. The addon does not have any access to read your emails.
Send email campaigns to up to 2000 recipients* per day from your Gmail id.
Google Workspace users can send up to 2000 emails per day on Pro plan and up to 1500 emails per day on Standard plan. Gmail.com users can send up to 500 emails per day on both Pro and Standard plan (this limit is imposed by Google). See pricing page for more details.
Read more about quotas
You can personalize email subject line, body, attachments, cc and bcc to give every email a personal touch.
Read how to compose personalized email template
Send emails on autopilot
Use advanced delivery options: limit daily email sending count, add delay between emails, send emails only during specific weekday/specific time. Combine these options to achieve hyper-targeted email delivery.
Schedule mail merge campaigns to send emails at specific date and time in future.
Track email open rate, link click rate (click-through rate or CTR) and un-subscriptions in real time directly from Google Sheets.
Read how to track email open & click rates
Add attachments (e.g. pdf, word, excel, powerpoint files) to your emails. You can add common attachments (same attachments sent to all recipients) or personalized attachments (unique attachments for each recipient). Personalized attachment is very useful for sending payslips, invoices, invitations etc.
Read how to send personalized attachments
Read how to send common attachments
Don't just take our word for it, here's what customers are saying
Amazing app!!!! Has made my mass emailing so much easier!!!
this mail merge is awesome and i found this is best in all...
I recommend this app for your email campaign! This tool is very simple, everything is clear for the use. Thanks for this! It's the best app in the Market for me!
Awesome app...loved it