Intermediate14 hrsEnglish + हिन्दी

Google Apps Script

Prerequisites: Foundations

Automate Google Sheets, Gmail and Drive with JavaScript.

Modules: 5
Lessons: 20
Duration: 14 hrs

Your progress0 of 20 lessons · 0%

Module roadmap

1

Getting Started

4 lessons · 59 min

What is Apps Script and when to use it10 min Script editor tour: bound vs standalone scripts12 min JavaScript essentials for Sheets users25 min Logger, console and debugging12 min

2

Working with Google Sheets

4 lessons · 68 min

SpreadsheetApp: sheets, ranges, getValues/setValues20 min Fast scripts with batch reads and writes15 min Custom functions (=MYFUNCTION)15 min Formatting, custom menus and dialogs18 min

3

Triggers & Automation

4 lessons · 60 min

Simple triggers: onOpen, onEdit15 min Installable and time-driven triggers15 min Automate Google Form responses18 min Quotas, execution limits and workarounds12 min

4

Gmail, Drive, Calendar & Docs

4 lessons · 69 min

Mail merge from a sheet with GmailApp20 min Create and organise Drive files and folders15 min Generate PDF invoices from a Docs template22 min Create calendar events from sheet rows12 min

5

APIs & Web Apps

4 lessons · 100 min

Call external APIs with UrlFetchApp20 min Build a web app with doGet/doPost25 min PropertiesService: storing settings and API keys10 min Project: automated inventory tracker with email alerts45 min

Google Apps Script | ExcelWalaa