In this tutorial, we will see how we can add a custom menu and submenu in Google Docs (Spreadsheet, Document, etc.) and then add some action when the menu or submenu is clicked. This solution is for the following problem I had: I had a lot of programming code blocks in a Google Document. I … Read more
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
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
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 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
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
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 The following function will create a folder name My Folder in … Read more
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