Home » Archive

Articles tagged with: appscript

Google AppScript »

[20 Mar 2017 | No Comment]

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 that contains exam marks obtained by students of different grades/classes.

Google AppScript »

[6 Mar 2017 | No Comment]

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

Google AppScript »

[27 Feb 2017 | No Comment]

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 Spreadsheet
Create Google Form and email the Form URL

Google AppScript »

[20 Feb 2017 | No Comment]

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 from a Google Spreadsheet and then get the distance between those places in Kilometer using AppScript’s Maps class. Then, we save the distance in the spreadsheet.

Google AppScript »

[13 Feb 2017 | No Comment]

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.

Google AppScript »

[6 Feb 2017 | No Comment]

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

Google AppScript »

[30 Jan 2017 | No Comment]

This article shows how to create a new folder and file with some text inside it with Google AppScript. We will also see how to create a new Google Doc and write some text inside it through AppScript.
Create File & Folder with AppScript

Google AppScript »

[23 Jan 2017 | No Comment]

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 Google AppScript?