Email Marketing Automation - Using Google Scripts

What is Email Marketing Automation?

Email marketing is the process of delivering a promotional letter, primarily by using email to a customer or group of customers.

Scalable Marketing Strategy : through email marketing automation, the marketing strategy for the company can be scaled, by increased reach to customers.
Personalization of Customer Experience: can be achieved by creating a template taking into account customers need. Through automatic personalized email, these clients can be targeted, thereby enhancing the relationship between your client and business.
Improved Productivity: less time will be spent on emailing customers manually with the automation, thus improving productivity.

Create a Google Spread Sheet, with the following format.
In Google Sheet, go to Tool -> Script Editor.
Add the following code in the google script.
Go to File -> New -> HTML File
Copy the following html template code, and paste it in the html file created.
Save the HTML file, with name as email_template.html.
Once this is done, select function onOpen from toolbar and click on Run.
Allow permission for email, read, write and edit google sheets.
Now the system with interface has been setup, which can be verified by the addition of Send Email menu option on google sheets.
Select the cell corresponding to customer email, to whom you need to send email, then click on Send Email -> Send -> OK. The Sent column in sheet gets updated and the email is sent to the client.

14 Dec 2019