Introduction
  • Introduction
  • script Editor: Where codes are written
  • Writing the first line of code
  • Good Practices for writing Codes
  • Know about Google App Script
Handling Spreadsheet and For Loop
  • Accessing an outside spreadsheet
  • What can we do with the Spreadsheets
  • Introduction to for Loop
  • More on For Loop
IF Statement and Array
  • IF Statements
  • Array of Variables
  • Combining Array and For Loop
Commonly used Functions in Spreadsheet
  • Get Last Row of Spreadsheet
  • CopyTo : Copying from one cell to another
  • Change Name, Hide and Show Sheets
  • Customized Menu
  • Pop Up Dialogue Box
Live Project 1: Send email with details of Google Form
  • Creating Google Form
  • Setting up For Loop
  • Writing code for Loop
  • Automatically trigger the code