Google Apps Script Samples

Various sample code and projects for the Google Apps Script platform, a JavaScript platform in the cloud.

Learn more at developers.google.com.

Google APIs

AdminSDK

• Manage domains and apps
  
  

Advanced Services

• Access Google APIs via Advanced Google services
  
  

Calendar

• List upcoming events
• Create a vacation calendar

Classroom

• Manage Google Classroom
  
  

Data Studio

• Build a connector
• Authentication and Authorization

Docs

• Cursor inspector add-on
• Translate add-on

Drive

• Manage Google Drive files and folders
• View Google Drive activity

Forms

• Notification add-on
  
  

Gmail

• Sending email
• Mailmerge: Merge a template email with content

People

• Listing Connections
  
  

Sheets

• Managing Responses for Google Forms
• Menus and Custom Functions

Slides

• Translate Slides Add-on
• Progress Bars add-on

Tasks

• List Tasks
• Simple Tasks Web App

Templates

• Build off a working framework for new Apps Script projects.
  
  

Triggers

• Call an Apps Script function such as onOpen, onEdit, or onInstall in an add-on
• Create a time-driven trigger

Codelabs

Codelab tutorials combine detailed explanation, coding exercises, and documented best practices to help engineers get up to speed with key Google technologies. Here's a list of Apps Script codelabs:

• Apps Script Intro
• Apps Script CLI – clasp
• BigQuery + Sheets + Slides
• Docs Add-on + Cloud Natural Language API
• Gmail Add-ons
• Google Chat Apps

Clone using the clasp command-line tool

Learn how to clone, pull, and push Apps Script projects on the command-line using clasp.

Lint

Run ESLint over this whole repository with:

pnpm lint

This command will fix simple errors.

Type Checking

Run the TypeScript-based check over the repository with:

pnpm check

This command validates .gs files by temporarily converting them to .js and running tsc. It checks for syntax errors and type issues using JSDoc annotations.