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

<img src="https://www.gstatic.com/images/branding/product/2x/admin_96dp.png" align="left" width="96px"/>

AdminSDK

• Manage domains and apps
  
  

<img src="https://www.gstatic.com/images/branding/product/2x/google_cloud_96dp.png" align="left" width="96px"/>

Advanced Services

• Access Google APIs via Advanced Google services
  
  

<img src="https://www.gstatic.com/images/branding/product/2x/calendar_96dp.png" align="left" width="96px"/>

Calendar

• List upcoming events
• Create a vacation calendar

<img src="https://www.gstatic.com/images/branding/product/2x/classroom_96dp.png" align="left" width="96px"/>

Classroom

• Manage Google Classroom
  
  

<img src="https://www.gstatic.com/images/branding/product/2x/data_studio_96dp.png" align="left" width="96px"/>

Data Studio

• Build a connector
• Authentication and Authorization

<img src="https://www.gstatic.com/images/branding/product/2x/docs_96dp.png" align="left" width="96px"/>

Docs

• Cursor inspector add-on
• Translate add-on

<img src="https://www.gstatic.com/images/branding/product/2x/drive_96dp.png" align="left" width="96px"/>

Drive

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

<img src="https://www.gstatic.com/images/branding/product/2x/forms_96dp.png" align="left" width="96px"/>

Forms

• Notification add-on
  
  

<img src="https://www.gstatic.com/images/branding/product/2x/gmail_96dp.png" align="left" width="96px"/>

Gmail

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

<img src="https://www.gstatic.com/images/icons/material/system/2x/people_black_48dp.png" align="left" width="96px"/>

People

• Listing Connections
  
  

<img src="https://www.gstatic.com/images/branding/product/2x/sheets_96dp.png" align="left" width="96px"/>

Sheets

• Managing Responses for Google Forms
• Menus and Custom Functions

<img src="https://www.gstatic.com/images/branding/product/2x/slides_96dp.png" align="left" width="96px"/>

Slides

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

<img src="https://www.gstatic.com/images/branding/product/2x/tasks_96dp.png" align="left" width="96px"/>

Tasks

• List Tasks
• Simple Tasks Web App

<img src="https://www.gstatic.com/images/icons/material/system/2x/code_grey600_48dp.png" align="left" width="96px"/>

Templates

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

<img src="https://www.gstatic.com/images/icons/material/system/2x/alarm_grey600_48dp.png" align="left" width="96px"/>

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.