Send emails from Google Sheets with Gmail - automatically and using different templates!

Tutorial on how to send automated emails using Gmail and Google Sheets templates using Integromat. All you need is a contact list, Google Sheets, Gmail, and Integromat.
Try a free Integromat account 💸 now: https://rebrand.ly/test_integromat

Integromat Free plan allows you to create fully functioning integration scenarios and provides monthly renewable 1000 operations credit.

Subscribe to Business Automated for more video automation tutorials 🚀:
https://www.youtube.com/c/BusinessAutomatedTutorials?sub_confirmation=1

You can set up multiple email templates inside of Google Sheets and use these as content for your emails. As you add emails to your email or contact list in Google Sheets, these additional rows will be recognized by Integromat and will trigger automation that will send them an email with the content matching the template you have selected.

These emails are being sent out using easy to set up Gmail module inside Integromat. No need for any external software such as Mailchimp or Hubspot. The email will arrive from your own Gmail account. Another alternative not shown in this video is using Microsoft Office 365 Email Integromat Module to send emails.

This feature is also sometimes known as mail merge and could be set up alternatively using Google API. Integromat however offers you a simple no-code way how to access this feature.

0:00 How sending emails directly from Google Sheet via Gmail looks like
0:15 Setting up Google Sheet spreadsheet for sending emails
2:20 Setting up Integromat to collect emails from Google Sheets
4:58 Setting up Gmail module in Integromat
6:50 Test run of the scenario
7:25 Using different email templates in Google Sheets
8:14 Setting up scheduling for Integromat scenario

Business Automated is an independent automation consultancy. If you would like to request custom automation for your business, visit us at https://www.business-automated.com

If you like our tutorials - buy us a coffee☕: https://www.buymeacoffee.com/business
Follow us on Twitter🐦: https://twitter.com/BAutomated
Read more on Medium 💆‍♂️: https://business-automated.medium.com/

#Gmail #Sheets #emails

Видео Send emails from Google Sheets with Gmail - automatically and using different templates! канала Business Automated!