The way to ship customized emails utilizing Mail Merge in Google Sheets with SMTP. You may ship emails by way of SendGrid, Postmark, AWS SES, Zoho Mail, or every other SMTP server
The Mail merge add-on helps you to ship customized emails to a number of recipients in a single go. The emails are at all times despatched by way of your Gmail account or your Google Workspace electronic mail handle. Google additionally imposes a limit on the variety of emails you’ll be able to ship per day.
Mail Merge with SMTP
Mail merge is handy as a result of you’ll be able to put your contacts in a Google Sheet and the add-on will individually ship the emails for you. Nevertheless, in case you aren’t utilizing Gmail or have a big mailing record, an SMTP service like SendGrid or AWS could also be extra an appropriate possibility for sending out customized emails.
Wouldn’t or not it’s good in case you may benefit from the ease of the Mail Merge add-on whereas nonetheless using an SMTP service to ship customized emails? That’s the place the Document Studio add-on can assist.
Generate SMTP Credentials
Google for SMTP settings for [your email provider] and also you’ll discover the SMTP server handle, port quantity, and the authentication particulars just like the username and password (or API key) to your electronic mail service.
As an illustration, in case you plan to make use of Zoho Mail for mail merge, the SMTP settings can be as follows:
- SMTP Server: smtp.zoho.com
- Port: 465
- Username: Your Zoho account electronic mail handle
- Password: Your zoho.com password
Put together Mail Merge Knowledge
Open the Google Sheet along with your mail merge information and launch the Doc Studio add-on. Create a brand new workflow and select the Ship E mail process.
From the record of E mail Service suppliers, select SMTP Server and enter the SMTP server handle, port quantity, and the authentication particulars that you just discovered within the earlier step.
Subsequent, transfer to the E mail Message part and configure your email template. You should use placeholders like {{First Identify}} and {{Title}} within the message physique and topic line to personalize the emails.
If you want to connect recordsdata to the e-mail, you are able to do that as properly. You could connect the same file to all emails or use placeholders to attach different files to every electronic mail.
Click on the Preview button and it’s best to see a pattern electronic mail despatched to your personal electronic mail handle by the SMTP server. Now you can click on the Save and Run button to ship customized emails to all recipients in your Google Sheet.
