Google Apps Script Tutorial for Beginners

https://www.youtube.com/watch?v=Nd3DV_heK2Q 

 

Demo Scenario

1. Problem

a. You have to format your Weekly Analytics Report everytime you extract it from the datasource.

 

2. Solution

a. Write a script that create a custom menu item. When this menu item is clicked the whole report gets formatted as desired.

 

 

Designing our Algorithm for formatting

1. Access our active spreadsheet and store it in a variable

2. Identify our header row and store it in a variable

3. Identify our whole table and store it in a variable

4. Change the format of our header row

5. Change the format of our table

6. Create a filter for our header row