{"id":5886,"date":"2021-06-22T12:10:48","date_gmt":"2021-06-22T12:10:48","guid":{"rendered":"https:\/\/nlineaxis.com\/?p=5886"},"modified":"2021-09-14T12:30:33","modified_gmt":"2021-09-14T12:30:33","slug":"send-email-in-html-table-format-via-app-script-app","status":"publish","type":"post","link":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/","title":{"rendered":"Send Email In HTML Table Format via App Script App"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#Guide_on_how_to_send_email_in_HTML_Table_Format\" >Guide on how to send email in HTML Table Format<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#Wrapping_up\" >Wrapping up<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Spreadsheets have emerged as a powerful tool to automate various business functions while minimizing human efforts. With the help of <strong>Google Sheets send emails<\/strong> to the recipients. You can create and save entire code associated with processing an order, creating an invoice or emailing it. This article will help those who are seeking to <strong>send email in<\/strong> <strong>HTML table format<\/strong>\u00a0 from a spreadsheet for hassle-free management of tasks and better accountability.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Guide_on_how_to_send_email_in_HTML_Table_Format\"><\/span><strong>Guide on how to send email in HTML Table Format<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this guide, you will learn how to convert data from spreadsheet(s) into HTML table format and *send email using gmail app and scheduling email using trigger* create trigger(s) for scheduling emails to the recipient(s).<\/p>\n\n\n\n<p><strong>Step 1: Convert spreadsheet data into HTML table format.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/KQIw82a_QqvbO-H20z7LyXGmF555WdDziK_KqmbHVL5PJkfn_0Bc7RmJsue6ocl2qLscoyrj35uVL2URFjfDg2CfcKPd0lRplsZ-jRUFpk6OQ8i1gwcr2rrSn9abAJs8-_3obMxA\" alt=\"\"\/><\/figure>\n\n\n\n<p>The above screenshot resembles spreadsheet data. In this article, you will learn how to convert this data into a HTML table format and send to multiple recipients via <strong>Google Script App<\/strong>.<\/p>\n\n\n\n<p><strong>Step 2: Read spreadsheet data & convert into HTML table format.<\/strong><\/p>\n\n\n\n<p>To read spreadsheet data and convert it into HTML table format, use the same code that is provided in the screenshot below-<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/Xj7RlYpmPA775v3qQGmIdF0gxxc0X-GGXAmw_DmO6DG673-sP0gLK3F1ikKe-V3EoGfBZAN6W9ISmX7hL7vCwDGQ6GUQhqSFtSDcw3fxY6j0LEm2hgRN4wQVqw7KSQn-1cfNlp2k\" alt=\"\"\/><\/figure>\n\n\n\n<p><em><!DOCTYPE html><\/em><\/p>\n\n\n\n<p><em><html><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0<body><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0<div><b>See below for 1) customers that are above 90 days overdue on their renewal and 2) top 20 ACV customers who are up to 60 days overdue.<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0<br>Please provide your manager with an update on renewal status (or payment status for expected autorenewals) for all customers on either list<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0in the next 2 days.<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0<\/b><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0<br><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0<br><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0<\/div><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a01. <strong>Customers that are above 90 days overdue on their renewal = <?=total?> <\/strong> <br><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<div><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0<table width=\u201d100%\u201d><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<thead><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<tr style=\u201dbackground-color:gray;\u201d><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<th><?=AccountName?><\/th> <th><?=AccountTeam?><\/th> <th><?=AccountOwner?><\/th> <th><?=EffectiveDate?><\/th><th><?=DaysAged?><\/th> <th><?=Days30?><\/th> <th><?=Days60?><\/th><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<th><?=Days90?><\/th><th><?=Days120?><\/th><th><?=Days150?><\/th><th><?=Over150?><\/th><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<\/tr><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<\/thead><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<tbody><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ TableRangeValues to send in HTML Template using FOR EACH loop.\u00a0<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<? TableRangeValues.forEach(r => { ?><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0<tr><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<td><?= r[0] ?><\/td> <td><?= r[1] ?><\/td> <td><?= r[2] ?><\/td> <td><?= r[3] ?><\/td> <td><?= r[4] ?><\/td> <td><?= r[5] ?><\/td><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0<td><?= r[6] ?><\/td> <td><?= r[7] ?><\/td> <td><?= r[8] ?><\/td> <td><?= r[9] ?><\/td> <td><?= r[10] ?><\/td><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<\/tr><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<? }) ?>\u00a0<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<\/tbody><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<\/table><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0<\/div><\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0<\/body><\/em><\/p>\n\n\n\n<p><em><\/html><\/em><\/p>\n\n\n\n<p>This code will help you in reading and conversion of the data available in the spreadsheet. Once done, we will read the HTML file to retrieve the data that is required to send in email.<\/p>\n\n\n\n<p><strong>Step 3: Create a function to read HTML files.<\/strong><\/p>\n\n\n\n<p>The following code will help you to create a function to allow you to read the HTML file and send email via gmail app.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/wVpt0AoRXAxx_yIcmATwZltEbIHVFtHGQ3uxMWCakku3ySWGoJQJhhFuZceEWicBqTaiDdXpaqXr31S2XpqM6EyjMB3wP5ZU7Djbng9nooP39nqgDW03gCkD1c5r3uG4Z8Y0wLUS\" alt=\"send email in HTML table format\"\/><\/figure>\n\n\n\n<p><em>function outstandingDataEmail()\u00a0<\/em><\/p>\n\n\n\n<p><em>{<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var ss = SpreadsheetApp.getActiveSpreadsheet();<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var ActiveSheet = ss.getSheetByName(\u201cDays aged> 90\u201d);<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var headers = ActiveSheet.getRange(\u201cA1:K1\u201d).getValues();<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var total = ActiveSheet.getRange(\u201cL2\u201d).getDisplayValue();<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0var Recipients =\u201dJohn@gmail.com, Marry@gmail.com\u201d<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var AccountName = headers[0][0];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var AccountTeam = headers[0][1];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var AccountOwner = headers[0][2];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var EffectiveDate = headers[0][3];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var DaysAged = headers[0][4];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var Days30 = headers[0][5];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var Days60 = headers[0][6];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var Days90 = headers[0][7];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var Days120 = headers[0][8];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var Days150 = headers[0][9];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var Over150 = headers[0][10];<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var lr= ActiveSheet.getLastRow();<\/em><\/p>\n\n\n\n<p><em>\u00a0var TableRangeValues = ActiveSheet.getRange(2, 1, lr-1, 11).getDisplayValues();<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var htmltemplate =HtmlService.createTemplateFromFile(\u201cEmail\u201d);<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.total=total;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.AccountName=AccountName;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.AccountTeam=AccountTeam;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.AccountOwner=AccountOwner;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.EffectiveDate=EffectiveDate;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.DaysAged=DaysAged;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.Days30=Days30;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.Days60=Days60;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.Days90=Days90;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.Days120=Days120;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.Days150=Days150;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.Over150=Over150;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0htmltemplate.TableRangeValues=TableRangeValues;<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0var htmlforemail = htmltemplate.evaluate().getContent();<\/em><\/p>\n\n\n\n<p>\/\/ This is the function for sending email<\/p>\n\n\n\n<p><strong><em>GmailApp.sendEmail(<\/em><\/strong><\/p>\n\n\n\n<p><strong><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Recipients,\u00a0<\/em><\/strong><\/p>\n\n\n\n<p><strong><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u201c[ACTION REQUIRED] Outstanding Renewals\u201d,<\/em><\/strong><\/p>\n\n\n\n<p><strong><em>\u00a0\u00a0\u00a0\u00a0\u201cSee below for 1) customers that are above 90 days overdue on their renewal and 2) top 20 ACV customers who are up to 60 days overdue\u201d, {htmlBody: htmlforemail});<\/em><\/strong><em>\u00a0<\/em><\/p>\n\n\n\n<p><em>}<\/em><\/p>\n\n\n\n<p><strong>Step 4: To create a trigger to schedule email(s).<\/strong><\/p>\n\n\n\n<p>After using the code to create a function, you must now create a trigger to facilitate emails via the App Script App. There are two ways to create a trigger, i.e. either by UI or using manual code.\u00a0<\/p>\n\n\n\n<p>To create a trigger using UI, follow these steps-<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Click on Tools<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li>Select ScriptEditor\u00a0<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>Go to Triggers<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li>AddTriggers<\/li><\/ol>\n\n\n\n<p>Or, use the following code to create a trigger-<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/pQu53nntQC3O_6cK2FdXqDQKziYfNOPi0xQKqpOgBU9m7E87CPGBZlFSyXuYZPdtNRvegwQnfA1UVwfy1bcC1bpPvIOSCGwMtBEzH2yzYpRlUudZ7e8ScyT-oL5YOye_aomrH58o\" alt=\"send email in HTML table format\"\/><\/figure>\n\n\n\n<p><em>function createBiWeeklyTrigger() {<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\/\/ Trigger every other TUESDAY at 09:00 AM.<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ScriptApp.newTrigger(\u2018outstandingDataEmail\u2019)<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.timeBased()<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.everyWeeks(2)<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.onWeekDay(ScriptApp.WeekDay.TUESDAY)<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.atHour(9)<\/em><\/p>\n\n\n\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.create();<\/em><\/p>\n\n\n\n<p><em>}<\/em><\/p>\n\n\n\n<p>(In this example, we have created a trigger to facilitate email on alternate tuesday in every month; i.e. second and fourth tuesday at 9:00 am.)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Wrapping_up\"><\/span><strong>Wrapping up<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now when we have done the coding job easy for you, scheduling emails to multiple recipients must have never been much easier for you. Ensure that you do not miss out on any step for a hassle free mailing experience using <strong>spreadsheet on App Script App<\/strong>. Approach a company like NLINEAXIS for professional assistance on software solutions and services.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Spreadsheets have emerged as a powerful tool to automate various business functions while minimizing human efforts. With the help of Google Sheets send emails to the recipients. You can create and save entire code associated with processing an order, creating an invoice or emailing it. This article will help those who are seeking to send [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":5970,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-5886","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Nlineaxis IT Solutions Private Limited in USA<\/title>\n<meta name=\"description\" content=\"Scheduling email to multiple recipient via Google Script App can confuse beginners. Read this article for email in HTML table format.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nlineaxis IT Solutions Private Limited in USA\" \/>\n<meta property=\"og:description\" content=\"Scheduling email to multiple recipient via Google Script App can confuse beginners. Read this article for email in HTML table format.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/\" \/>\n<meta property=\"og:site_name\" content=\"Nlineaxis IT Solutions Private Limited in USA\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Kapilsalesforce\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-22T12:10:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-14T12:30:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2240\" \/>\n\t<meta property=\"og:image:height\" content=\"1260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vaibhav Sharma\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@NLINEAXIS\" \/>\n<meta name=\"twitter:site\" content=\"@NLINEAXIS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vaibhav Sharma\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/\"},\"author\":{\"name\":\"Vaibhav Sharma\",\"@id\":\"https:\/\/nlineaxis.com\/blog\/#\/schema\/person\/448053fac62aa1097f882bc75001ba44\"},\"headline\":\"Send Email In HTML Table Format via App Script App\",\"datePublished\":\"2021-06-22T12:10:48+00:00\",\"dateModified\":\"2021-09-14T12:30:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/\"},\"wordCount\":1205,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png\",\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/\",\"url\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/\",\"name\":\"Nlineaxis IT Solutions Private Limited in USA\",\"isPartOf\":{\"@id\":\"https:\/\/nlineaxis.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png\",\"datePublished\":\"2021-06-22T12:10:48+00:00\",\"dateModified\":\"2021-09-14T12:30:33+00:00\",\"author\":{\"@id\":\"https:\/\/nlineaxis.com\/blog\/#\/schema\/person\/448053fac62aa1097f882bc75001ba44\"},\"description\":\"Scheduling email to multiple recipient via Google Script App can confuse beginners. Read this article for email in HTML table format.\",\"breadcrumb\":{\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#primaryimage\",\"url\":\"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png\",\"contentUrl\":\"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png\",\"width\":2240,\"height\":1260,\"caption\":\"Salesforce\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/nlineaxis.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Send Email In HTML Table Format via App Script App\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/nlineaxis.com\/blog\/#website\",\"url\":\"https:\/\/nlineaxis.com\/blog\/\",\"name\":\"Nlineaxis IT Solutions Private Limited in USA\",\"description\":\"Innovating business solutions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/nlineaxis.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/nlineaxis.com\/blog\/#\/schema\/person\/448053fac62aa1097f882bc75001ba44\",\"name\":\"Vaibhav Sharma\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/348da4701f57aaf28130b40ba84f07eb4547cf60c15091e489c7ece276c62fe8?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/348da4701f57aaf28130b40ba84f07eb4547cf60c15091e489c7ece276c62fe8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/348da4701f57aaf28130b40ba84f07eb4547cf60c15091e489c7ece276c62fe8?s=96&d=mm&r=g\",\"caption\":\"Vaibhav Sharma\"},\"description\":\"A technical graduate with a passion for writing, he has been educating readers about technical innovations and trends like blockchain, internet of things, Salesforce and much more.\",\"sameAs\":[\"https:\/\/nlineaxis.com\/blog\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Nlineaxis IT Solutions Private Limited in USA","description":"Scheduling email to multiple recipient via Google Script App can confuse beginners. Read this article for email in HTML table format.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/","og_locale":"en_US","og_type":"article","og_title":"Nlineaxis IT Solutions Private Limited in USA","og_description":"Scheduling email to multiple recipient via Google Script App can confuse beginners. Read this article for email in HTML table format.","og_url":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/","og_site_name":"Nlineaxis IT Solutions Private Limited in USA","article_publisher":"https:\/\/www.facebook.com\/Kapilsalesforce","article_published_time":"2021-06-22T12:10:48+00:00","article_modified_time":"2021-09-14T12:30:33+00:00","og_image":[{"width":2240,"height":1260,"url":"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png","type":"image\/png"}],"author":"Vaibhav Sharma","twitter_card":"summary_large_image","twitter_creator":"@NLINEAXIS","twitter_site":"@NLINEAXIS","twitter_misc":{"Written by":"Vaibhav Sharma","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#article","isPartOf":{"@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/"},"author":{"name":"Vaibhav Sharma","@id":"https:\/\/nlineaxis.com\/blog\/#\/schema\/person\/448053fac62aa1097f882bc75001ba44"},"headline":"Send Email In HTML Table Format via App Script App","datePublished":"2021-06-22T12:10:48+00:00","dateModified":"2021-09-14T12:30:33+00:00","mainEntityOfPage":{"@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/"},"wordCount":1205,"commentCount":0,"image":{"@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#primaryimage"},"thumbnailUrl":"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png","articleSection":["Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/","url":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/","name":"Nlineaxis IT Solutions Private Limited in USA","isPartOf":{"@id":"https:\/\/nlineaxis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#primaryimage"},"image":{"@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#primaryimage"},"thumbnailUrl":"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png","datePublished":"2021-06-22T12:10:48+00:00","dateModified":"2021-09-14T12:30:33+00:00","author":{"@id":"https:\/\/nlineaxis.com\/blog\/#\/schema\/person\/448053fac62aa1097f882bc75001ba44"},"description":"Scheduling email to multiple recipient via Google Script App can confuse beginners. Read this article for email in HTML table format.","breadcrumb":{"@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#primaryimage","url":"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png","contentUrl":"https:\/\/nlineaxis.com\/blog\/wp-content\/uploads\/2021\/06\/SEND-EMAIL-IN-HTML-TABLE-FORMAT-VIA-APP-SCRIPT-APP-1.png","width":2240,"height":1260,"caption":"Salesforce"},{"@type":"BreadcrumbList","@id":"https:\/\/nlineaxis.com\/blog\/send-email-in-html-table-format-via-app-script-app\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nlineaxis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Send Email In HTML Table Format via App Script App"}]},{"@type":"WebSite","@id":"https:\/\/nlineaxis.com\/blog\/#website","url":"https:\/\/nlineaxis.com\/blog\/","name":"Nlineaxis IT Solutions Private Limited in USA","description":"Innovating business solutions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nlineaxis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/nlineaxis.com\/blog\/#\/schema\/person\/448053fac62aa1097f882bc75001ba44","name":"Vaibhav Sharma","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/348da4701f57aaf28130b40ba84f07eb4547cf60c15091e489c7ece276c62fe8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/348da4701f57aaf28130b40ba84f07eb4547cf60c15091e489c7ece276c62fe8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/348da4701f57aaf28130b40ba84f07eb4547cf60c15091e489c7ece276c62fe8?s=96&d=mm&r=g","caption":"Vaibhav Sharma"},"description":"A technical graduate with a passion for writing, he has been educating readers about technical innovations and trends like blockchain, internet of things, Salesforce and much more.","sameAs":["https:\/\/nlineaxis.com\/blog\/"]}]}},"_links":{"self":[{"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/posts\/5886","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/comments?post=5886"}],"version-history":[{"count":3,"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/posts\/5886\/revisions"}],"predecessor-version":[{"id":9313,"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/posts\/5886\/revisions\/9313"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/media\/5970"}],"wp:attachment":[{"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/media?parent=5886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/categories?post=5886"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nlineaxis.com\/blog\/wp-json\/wp\/v2\/tags?post=5886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}