Google AppScript: Create Form using HTML, Publish Form as WebApp & Show data from Spreadsheet

This article shows: 1) How to create Google Form using standalone HTML file 2) Fetch data from Google Spreadsheet and populate Select box of the HTML Form 3) Populate second select box based on the value selected from first select box 4) Show result data from spreadsheet on form submit Basically, we have a spreadsheet … Read more

Google AppScript: Create Form using HTML, Publish Form as WebApp & Email Response

This article shows: 1) How to create Google Form using standalone HTML file 2) Email form submitted data to any particular email address Create HTML file We create a Form in a new HTML File. Go to http://script.google.com Go to File -> New -> Html file Type the name of the file, e.g. form.html Write … Read more

Google AppScript: Create Form using FormApp class, Publish Form as WebApp, Email & Save Responses to Spreadsheet

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

Google AppScript: Get Latitude Longitude & Distance between Places/City

This article shows how to get latitude and longitude of a particular place or city. We read the city/place name from a Google Spreadsheet, then get the latitude and longitude of that place using Google AppScript’s “Maps” class and then save the lat long in the spreadsheet. We will also be reading two places name … Read more

Google AppScript: Send Multiple Emails by reading data from Spreadsheet

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

Google AppScript: Create and Write to Google SpreadSheet

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

Google AppScript: Basic/Beginner Introduction [TUTORIAL]

This tutorial provides a very basic introduction to Google App Script. I will also list out the works that can be done with AppScript. And, I will be showing very basic Javascript code that can be run on AppScript’s console. In this article, we will be dealing only with Javascript arrays and loops. What is … Read more