# How to Setup Email Marketing using Google Apps Scripts *This blog was originally published on [RavSam blog](https://www.ravsam.in/blog/setup-email-marketing-using-google-apps-script/).* Recently, we have been writing a lot of stuff related to Web Design and Development, like [collecting form responses](http://www.ravsam.in/blog/collect-form-responses-using-google-apps-script/), that can be implemented using **Google Apps Scripts** and Serverless Architecture. In this blog, we will talk about **email marketing**. We will set up custom email marketing purely using Google Apps Script. The advantage is we can take control of our email marketing campaign and create our own automated workflows. ### Creating a new Spreadsheet First of all, we need a Google Sheet where we store all of our email addresses to whom we want to send the emails. Let’s [create a new spreadsheet](https://docs.google.com/spreadsheets/). ![Enter the user details in Google Sheet](https://cdn.hashnode.com/res/hashnode/image/upload/v1631429593299/GtBzH7RjP.png)*Enter the user details in Google Sheet* ### Creating a new Google Apps Project Now is the time to connect our Google sheet to a Google Apps Script. From *Tools*, we select the *Script Editor*. ![Connect Google Sheet to Google Apps Script project](https://cdn.hashnode.com/res/hashnode/image/upload/v1631429595160/2bg73h7Me.png)*Connect Google Sheet to Google Apps Script project* ### Writing code Finally, it is time to write some code. a.) **Main.gs** Add the following code to the file: ```js function sendEmails(mail_template='content', subject='Testing my Email Marketing') { // get the active spreadsheet and data in it var id = SpreadsheetApp.getActiveSpreadsheet().getId(); var sheet = SpreadsheetApp.openById(id).getActiveSheet(); var data = sheet.getDataRange().getValues(); // iterate through the data, starting at index 1 for (var i = 1; i < data.length; i++) { var row = data[i]; var email = row[0]; var name = row[1]; // check if we can send an email if (MailApp.getRemainingDailyQuota() > 0) { // populate the template var template = HtmlService.createTemplateFromFile(mail_template); template.name = name; var message = template.evaluate().getContent(); GmailApp.sendEmail( email, subject, '', {htmlBody: message, name: 'RavSam Team'} ); } } } ``` The comments have been included in the file for a proper description of the above function. > Always use *GmailApp.sendEmail* instead of *MailApp.sendEmail*. It is a more stable and reliant function. b.) **content.html** Since the above script uses an HTML file and populates it, we need to create an HTML template file. Add the following code to the file: ```html Hi . We are testing our beta features for email marketing. ``` The `<?= name ?>` template variable gets auto-filled by the email marketing script. ### Running the script We have done all the necessary setup to start a successful email marketing campaign. Before we run our code, we need to grant ![Authorize the Google Apps Script to send an email on your behalf](https://cdn.hashnode.com/res/hashnode/image/upload/v1631429597122/D__rlvgg2.png)*Authorize the Google Apps Script to send an email on your behalf* ### Results Let us check our email to see if the email was received. Awesome! We can clearly see that the email was delivered successfully to the user’s inbox. ![Email Delivered successfully to the inbox](https://cdn.hashnode.com/res/hashnode/image/upload/v1631429599316/6SGVsxaQc.png)*Email Delivered successfully to the inbox* We can create more beautiful and custom HTML templates and manage our email marketing campaigns around them. In our next blog, we will be talking about [how to track whether a user opens our emails or not](https://www.ravsam.in/blog/track-email-opens-with-google-apps-script/) Thanks for reading 💜 *** If you enjoyed my blog, follow me for more informative content like this. I publish a [monthly newsletter](https://www.ravsam.in/newsletter/) in which I share personal stories, things that I am working on, what is happening in the world of tech, and some interesting dev related posts which I across while surfing on the web. Connect with me through [Twitter](https://twitter.com/ravgeetdhillon) • [LinkedIn](https://linkedin.com/in/ravgeetdhillon) • [Github](https://github.com/ravgeetdhillon) or send me an [Email](mailto:ravgeetdhillon@gmail.com). — [Ravgeet](https://www.ravgeet.in), *Full Stack Developer and Technical Content Writer*