Google Apps Script: From Level Zero with 20 Projects (2025)

Learn Google Apps Script from zero by building about 20 projects to explore automation, while teaching beginners and those with some coding background the basics and beyond.

Explore Google Apps Script, a lightweight JavaScript platform to automate tasks in Google Sheets, Docs, and Slides, with editor access via extensions.

Learn how to authenticate scripts for personal and google workspace accounts, review permissions, bypass the unverified app warning by selecting test project, and grant access.

Learn to write and run Google Apps Script in the script editor and read data from a Google Sheet using SpreadsheetApp.getActiveSpreadsheet, getSheetByName, and getRange to log values.

Master reading and writing data in Google Sheets with Apps Script by pulling values, computing sums, and writing results to an output sheet with formatting.

Learn how arrays work in Google Apps Script, including one-dimensional and two-dimensional arrays, zero-based indexing, and reading sheet data with get values, get range, and get data range.

Master reading an array from a sheet and writing it to another with Google Apps Script, using get range, set values, and dynamic row calculations.

Master core array methods in Google Apps Script, including push, pop, shift, unshift, concat, slice, sort, and reverse, with one- and two-dimensional arrays.

Learn how if statements evaluate conditions to execute code, with examples using age checks to vote, else if chains, and loops, in Google Apps Script.

Master for loops in google apps script by initializing a counter, testing a condition, and incrementing. See examples that print hi five times, generate number tables, and apply repeated logic.

Master while loops and their comparison with for loops through practical examples, showing counters, indices, and conditions that drive repeated execution in Google Apps Script projects.

Learn to merge data from individual sheets into a master tab with Google Apps Script, adding date, name, and daily metrics for calls, meetings, and sales.

Learn to merge data from multiple sales rep spreadsheets into a master sheet using google apps script, including per-user commission calculations and automated data pulling.

learn to read gmail inbox threads with google apps script by fetching threads, logging the first message’s from, date, and subject, and using search queries to filter inbox.

Learn to fetch Gmail inbox threads and messages into Google Sheets, capturing thread IDs, subjects, and message counts, while batching writes and deduplicating to streamline data automation.

Learn to send emails from a Google sheet using Google Apps Script, GmailApp.sendEmail with subject and body, including an HTML body, cc, attachments, and tracking sends.

Learn to read events from Google Calendar with Google Apps Script, extracting start time, end time, title, and location, then write results to a sheet and explore colors.

Learn to create and update Google Calendar events with Apps Script, including title, start and end times, location, and description from sheet data; manage edits and deletions via event IDs.

Learn to access Google Docs from Google Apps Script, read and modify document bodies, replace placeholders to generate templates, and send emails using Apps Script.

Learn to read and write data in Google slides using the slides app, navigate slides and elements, and extract text from shapes.

Learn to write to Google Slides with Apps Script by reading and setting text, replacing placeholders, and inserting slides programmatically.

List drive files and folders with Apps Script and the Drive API. Use an iterator to get name, ID, URL, and mime type, then move or rename by ID.

Learn to generate pdfs from google sheets using an apps script that exports a sheet as pdf, with orientation, fit, and margins options, then save to drive or email.