Advanced Google Apps Script and API with 10 Projects

Explore using the script editor and logger to print and view output, trace loop values, and inspect execution transcripts for debugging in Google Apps Script.

Learn to extract a portion of a string with the substring method in JavaScript, within Google Apps Script. Use 0-based indexing and an end index that is not included.

Learn how the indexOf function finds the position of a value in an array within Google Apps Script, with zero-based indexing using names and spreadsheet data.

Practice adding and removing array elements at the beginning or end with push, unshift, shift, and pop in JavaScript. Use indexOf for duplicates and log results in Google Apps Script.

Explore replacing a set of characters with another in Google Apps Script and JavaScript, using regular expressions to extract digits or letters and perform targeted replacements.

Learn how to manage date and time in Google Apps Script by using new Date(), setting time zones in project properties, and formatting outputs with Utilities.formatDate for precise logging.

Learn to save a Google Sheets document as a pdf with Google Apps Script, configuring paper size, orientation, margins, header and footer, and export with correct sheet and folder ids.

Extract nested data from an API response, loop through coins to obtain name, symbol, and USD price, and write them as rows with a header in a spreadsheet.

Learn to use Google Apps Script and Google Calendar services to create all-day events, manage calendars by ID or name, and automate data flows between Sheets, Docs, and Gmail.

Master advanced Google Apps Script, from complex sheet actions and custom functions to JSON parsing and API integration. Work with libraries, get and post calls, webhooks, and ten real-world projects.

Explore advanced actions on sheets with Google Apps Script, including copying ranges and formats, data validation, and resizing columns and rows.

Explore how to create and read data validation in sheets, work with dropdown lists, and apply text formatting using Google Apps Script, including font size, bold, and color.

Learn how to create custom functions in Google Sheets with Apps Script, including kilometer-to-meter conversion and array handling. Understand how to describe, parameterize, and test functions while noting usage limits.

Explore JSON basics, including key-value pairs and arrays, learn to parse and stringify JSON, and navigate nested objects using Google Apps Script for API workflows.

Use Google Forms with Apps Script to get form id and active form, read and set title and description, manage questions and checkbox choices, and mark fields as required.

Explore Google Contacts rebranded as the People API, enable the API, and fetch connections to extract names, emails, birthdays, and phone numbers for a sheet export.

Learn to use Google Classroom with Apps Script, listing courses, obtaining teacher group emails, and creating or updating classes via the Classroom API, with practical code examples.

Learn to interact with Google Analytics through Google Apps Script by listing accounts, web properties, and profiles, and by running analytics data API reports.

Explore Google Maps in Apps Script, using the direction finder to compute routes between origins and destinations. Use geocoder and reverse geocode to obtain addresses, durations, and distances.

Explore how to access YouTube from Google Apps Script using the YouTube Data API, perform keyword searches with parameters, and handle channels, videos, and uploads.