Google Apps Script

Create a script that will get data from a sheet, create content to add within a Doc. Make the Doc, update the sheet data with the doc details, and email out to the user from the sheet the doc location. Select a Spreadsheet sheet by Name – getSheetByName(‘data’) Get the data from the sheet Loop … Read more

Google Apps Script allows you to create custom blocks of code that do stuff, and there is a lot of stuff you can do with it.  Container-bound Scripts – the Google file the Apps Script is attached to is known as the container.   Bound scripts behave just like Standalone scripts but they have several special functions, … Read more

Introduction to Google Apps Script Macros within Google Sheets can be used to write Apps Script Code. Create a new spreadsheet and add some data into the sheet. In the top menu under extensions select Macro. Google Apps Script is created using standard JavaScript Syntax. Apply some changes and update the text color of some … Read more

Get the free ebook for learning Google Apps Script with coding examples.