How to Send Personal Emails Using Mail Merge in Google Sheets with SMTP You can send emails via SendGrid, Postmark, AWS SES, Zoho Mail, or any other SMTP server.
The Mail Merge add-on lets you send individual emails to multiple recipients at once. Emails are always sent through your Gmail account or your Google Workspace email address. Google also imposes a limit on the number of emails you can send per day.
Mail merge with SMTP
Mail Merge is convenient because you can put your contacts in a Google Sheet and the add-on will send emails for you personally. However, if you are not using Gmail or have a large mailing list, an SMTP service such as SendGrid or AWS may be a more suitable option for sending personal emails.
Wouldn’t it be great if you could enjoy the ease of the Mail Merge add-on while using an SMTP service to send personal emails? A Document Studio add-on can help.
Generate SMTP credentials
For Google SMTP settings for (your email provider) And you’ll find the SMTP server address, port number, and authentication details like username and password (or API key) for your email service.
For example, if you plan to use Zoho Mail For mail merge, the SMTP settings will be as follows:
- SMTP server: smtp.zoho.com
- port: 465
- Username: Your Zoho account email address
- password: Your zoho.com password
Prepare mail merge data
Open a Google Sheet with your mail merge data and launch the Docs Studio add-on. Create and select a new workflow Send Email work
From the list of email service providers, choose SMTP Server and enter the SMTP server address, port number, and authentication details you found in the previous step.
Next, move on Email Message section and configure your email template. You can use placeholders like {{First Name}} and {{Title}} In the message body and subject line to personalize emails.
If you want to attach files to an email, you can do that too. You can attach the same file to all emails or use placeholders to attach different files to each email.
Click Preview button and you should see a sample email sent via SMTP server to your own email address. You can click now Save and Run A button to send personalized emails to all recipients on your Google Sheets.