This article shows: 1) How to create Google Form using AppScript’s “FormApp” class 2) Send Form URL to any email address using MailApp or GmailApp class 3) How to use Triggers in AppScript 4) How to send Form submit Responses to any email address 5) How to save Form submit Responses to any particular Google … Read more
This article shows how to read list of email addresses, subject and message body from Google Spreadsheet and send separate emails to all of them with Google AppScript. First, let’s see a simple example of sending single message to a particular email address. Send Single Email Here, AppScript’s MailApp class is used to send email. … Read more
This article shows how to create a new Google Sheet and write data into it with Google AppScript. We will also be writing data into existing Google SpreadSheet. Create a new Google Sheet and write data into it with AppScript The following function will create a Google Sheet named TestSheet in your Google Drive. Then, … Read more