Google Apps Script List

A curated list of Google Apps Script resources. Want to add or fix something? Read CONTRIBUTING.md first -- it explains what we accept and how to format an entry.

• Communities
• Resources
  • Useful sites & blogs
  • Awesome code & things
  • Lists & collections
• Development
  • Starter Kits
  • Shims and polyfills
• Libraries & Modules
  • Using databases
  • ORM (O/RM and O/R mapping tool)
  • Utility
  • Artificial Intelligence
  • Parsing
  • oAuth
  • Images & Pictures
  • Data Studio community connectors
  • Pack modules and universal libraries
  • Services
• Open Source Apps & Add-ons
• Chatbots
• Testing
• Logging
• Benchmarking
• Snippets and assorted
  • Snippets
    • Collections
    • Spreadsheets
    • Gmail
    • XML
    • JSON
  • Assorted

Communities

• Google Apps Script Community Google Groups
• Google Apps Script Facebook Community Facebook Group
• r/GoogleAppsScript Reddit
• Русскоязычный чат по Google Apps Script Telegram

goto top ⇑

Resources

• Search by label [google-apps-script] on GitHub
• SO [google-apps-script] tag

Useful sites & blogs

• Digital Inspiration Amit Agarwal's site
• mashe.hawksey.info Martin Hawksey's site
• ramblings.mcpher.com Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation
• googleappscripting.com Google Apps Script Tutorials and Examples • Making Google Apps Script Accessible to Everybody
• scriptsexamples A set of code samples and libraries to foster programming in Google AppsScript to be easy
• tanaikech.github.io The Google Apps Script tag of the Kanshi's blog
• andrewroberts.net The Andrew Roberts's site
• kutil.org The google apps script tag of Ivan Kutil's blog
• googleappsscript.org Google Apps Script Tutorial
• scriptingwithshiva.blogspot.com Scripting With Shiva It will help those wants to start Google Apps script Development from scratch
• benlcollins.com Ben Collins's site
• pulse.appsscript.info User contributed tutorials and news
• yagisanatode.com Section in Yagi's blog about Google Apps Script, including tutorials and templates
• script.gs Discussions, tutorials and tips about Google Apps Script and related technologies

Awesome code & things

• Easy data scraping with Google Apps Script in 5 minutes
• Send SMS with Google Sheets and your Android Phone

Lists & collections

• Apps Script consultants
• Learning Google Apps Script The best resources for learning Google Apps Script, the glue that connects GSuite services including Gmail, Google Drive, Calendar, Maps, Analytics and more
• Google Apps Script Cheat Sheet
• Andrew Roberts' Scripts and Snippets
• google-apps-script-snippets Google Apps Script Snippets
• googleworkspace/apps-script-samples Various sample code and projects for the Google Apps Script platform
• googlesamples/apps-script-templates This repository contains a number of code templates for Google Apps Script that provide example frameworks for Apps Script projects
• ashtonfei/google-apps-script-projects A collection of Google Apps Script projects shared on YouTube

goto top ⇑

Development

• google/clasp Develop Apps Script projects locally using clasp (Command Line Apps Script Projects) CLI
• gas-local Execute and test your google app scripts locally in node.js
• brucemcpherson/gas-fakes A proof of concept implementation of Apps Script environment on node.js
• gamified_journal Proof of concept of a local development / push toolchain for Google Apps Scripting
• gas-github Chrome-extension to manage Google Apps Script(GAS) code with github/github enterprise
• ggsrun This is a CLI tool to execute Google Apps Script (GAS) on a terminal
• gdrive Google Drive CLI Client
• MaartenDesnouck/google-apps-script gas, for locally developing Google Apps Script projects
• gas-lib NPM package to add code auto-completion for Google AppsScript in your preferred code editor
• AppsScriptColor (3 700+ users) This Chrome extension provide 2 dark color themes for the google apps script editor. It also allows to use folders to sort your files more cleanly
• KaiShoya/autocomplete-gas Google Apps Script auto completion for Atom editor
• rudimusmaximus/DevFlow A Dev Flow for Google Apps Script
• fossamagna/gas-webpack-plugin Webpack plugin for Google Apps Script
• mahaker/esbuild-gas-plugin esbuild plugin for Google Apps Script
• Andrew Roberts' Dev Flow - Description of a dev flow using Github assistant.
• Set up a Local Development Environment for Apps Script - Write code faster inside VS Code.
• maelcaldas/clasp-types A d.ts generator for clasp projects
• namaggarwal/clasp-token-action Github actions for clasp for CI for your AppScript projects.
• selectnull/eslint-plugin-googleappsscript ESLint plugin for Google Apps Script environment
• VladimirMikulic/parcel-optimizer-gas 🌀 Parcel plugin that enables Google Apps Script bundling
• labnol/vscode-google-apps-script Recommended extensions and editor settings for working with Google Apps Script in VS Code

Starter Kits

• ez-clasp A starter kit for building Google Apps Script projects with TypeScript, ESLint, Prettier, Jest and Rollup support out of the box.
• apps-script-starter A starter kit for building Google Apps Script projects with modern JavaScript ES6, Webpack, Babel and ESLint inside Visual Studio Code
• realworld-apps-script JWT REST API following the RealWorld API spec
• gas-minimal-boilerplate A minimal boilerplate with webpack for Google Apps Script
• google-apps-script-template A feature rich task runner for Google Apps Script to write, lint and push modern code to your documents
• gas-shell Starter template to develop locally Google AppsScript project with your preferred code editor (include build and publish as Add-on commands)
• artnc/gas-es6-webpack ES6+Webpack boilerplate for Google Apps Script
• google-app-script-ts-jest Rest api in typescript with jest unit tests working with vscode debugger
• howdy39/gas-clasp-starter A starter template for Google Apps Script by clasp
• zaki-yama/webpack-google-apps-script-template Template for developing Google Apps Script with Webpack
• JeanRemiDelteil/gas-starter-kit Empty project to start develop in Google AppsScript locally
• faresd/google-apps-script_travis-ci Automating Apps Script build, test, deployment and publishing in Chrome Webstore as an add-on using Travis CI
• sao-clasp With one command, Generate a Google Apps Script project that uses clasp
• gazf/google-apps-script-ci-starter Google Apps Script with CI/CD(wercker) Starter Kit
• PopGoesTheWza/ts-gas-project-starter Sample repository for Typescript based Google Apps Script projects
• enuchi/React-Google-Apps-Script This is your boilerplate project for developing React apps inside Google Sheets, Docs, Forms and Slides projects. It's perfect for personal projects and for publishing complex add-ons in the G Suite Marketplace.
• atti187/esmodules Example repo of using esmodules with Apps Script
• WildH0g/apps-script-engine-template A robust, highly configurable template for Google Apps Script projects with essential development tools out of the box
• rupampoddar/apps-script-template Starter template for Google Apps Script using Vite with support for React, Vue, Svelte and other frontend frameworks
• MaksymStoianov/appsscript-boot A framework for Google Apps Script that simplifies API creation, route management, and maintains a clean project architecture.

Shims and polyfills

• Using Es6 with Apps Script

goto top ⇑

Libraries & Modules

• Google Apps Script Library Database Directory with more than 200 libraries

Using databases

• FirebaseApp The Google Apps Script binding for the Firebase Realtime Database
• oshliaer/alasqlgs AlaSQLGS is a library that enables the use of the AlaSQL.js library in Google Apps Script
• p3sn/FireScript Google Apps Script library for Firebase Admin, looking a lot like the NodeJS Admin SDK

ORM (O/RM and O/R mapping tool)

• Goodel An ORM for Google Apps scripts
• gs-spreadsheet-manager A slightly more object-oriented, ORM-y, and altogether pleasant way of dealing with Google Spreadsheets when using Google Apps Script
• Sheetfu An ORM to treat spreadsheet as database tables using Google Apps Scripts. Sheetfu's Python version
• itmammoth/Tamotsu Object-Spreadsheet Mapping for Google Apps Script
• Gexpress-middleware-RESTsheet Spreadsheet exposed as http REST endpoints (based on tamotsu)
• GoogleScriptSQL How to transform Google Sheet and Google App script into a SQL Database
• Ob2SS Another object-spreadsheet mapper for Google Apps Script
• Sintropiadotio/orma The Google Apps Script ORM

Utility

• SpeedStore Blazingly fast Properties storage for Google Apps Script ⚡
• gas-underscore Underscore for Google Apps Script
• lodashgs Lodash for Google Apps Script is a library that enables the use of the lodash.js library in Google Apps Script
• brucemcpherson/cUseful Various dependency free useful functions
• Gexpress Express-ish middleware for google appscript (build NODEJS-ish applications)
• tanaikech/RangeListApp RangeListApp is a GAS library for retrieving, putting and replacing values for Spreadsheet by a range list with a1Notation using Google Apps Script (GAS)
• syslogic/google-apps-script CloudDatastore.gs is a client for Google Cloud Datastore, which runs as a Service Account
• Sheetbase Build REST API server, websites and apps using Google Apps Script.
• UrlShortener A replacement for the Google Apps Script UrlShortener advanced service that uses bit.ly
• michalliu/google-app-script-jsonrpc An implementation of JSON-RPC 2.0 specification
• johndturn/google-apps-script-storageservice Utility class (built in TypeScript) for storing small or large values in Google Apps Script properties
• GetEditType Library for retrieving the edit types of the OnEdit event trigger of Spreadsheet using Google Apps Script
• tanaikech/FetchApp This is a GAS library for creating and requesting the type of multipart/form-data using Google Apps Script. This library enhances Class UelFetchApp of Google Apps Script.
• Apps Script Code Generator Generate "ready to run" code snippets for making HTTP requests with Google Apps Script. It supports query parameters, authorization, request body and headers
• classroomtechtools/ObjectStore A store for appscripts that utilizes Properties, Cache, and an in-memory map for speed
• EnhancedCacheService A cache service which wraps the GAS's native Cache to provide additional features
• XmlRpcMessageService A service for simplifying the usage of XML-RPC services from JavaScript in Google Apps Script
• GmailSearchBuilder A builder service for Gmail search queries. It provides a fluent API (chaining methods) for building a search query for mail threads in Gmail
• tanaikech/ProcessApp This is a library for retrieving the process and information of Google Apps Script. For example, one of methods retrieves the total execution time of all functions executed by the time-driven trigger at owner's account
• appsscript-utils A collection of reusable utilities and helpers for Google Apps Script development, written in TypeScript

Artificial Intelligence

• scriptit-fr/GenAIApp Google Apps Script binding for Gemini and OpenAI generative AI APIs

Parsing

• Apps-Script-htmlparser2-library A browserified version of fb55/htmlparser2 modified to work in Google Apps Script
• cheeriogs HTML manipulation library with jQuery-like interface
• PdfApp PdfApp is a library to extract text content from a PDF file using PDF.js.

oAuth

• apps-script-oauth1 An OAuth1 library for Google Apps Script
• apps-script-oauth2 An OAuth2 library for Google Apps Script
• brucemcpherson/cGoa OAuth2 for Apps Script in a few lines of code

Images & Pictures

• ImgApp This is a library of image tools for Google Apps Script
• GPhotosApp This is a Google Photos REST API library for Google Apps scripts
• InstagramApp Instagram images API for Google Apps scripts to download images and video

Data Studio community connectors

• googledatastudio/community-connectors This repository contains open source content for Google Data Studio

Pack modules and universal libraries

• classroomtechtools/modularLibraries A collection of importable, modular libraries for any GAS project

Services

• pamnard/Tinkoff-REST-API-via-Google-Apps-Script: Обёртка Tinkoff API на Google Apps Script (не официальная) A wrapper of Tinkoff REST API

goto top ⇑

Open Source Apps & Add-ons

• google-docs-add-on Publish to WordPress from Google Docs
• email-studio-gmail-addon Gmail add-on for Mail Merge and Email Scheduler
• erickoledadevrel/crop-sheet An add-on for Google Sheets that allows you to easily remove extra rows and columns
• ericyd/gdrive-transfer Web app to transfer ownership of a Google Drive folder, including all sub-folders and documents
• ericyd/gdrive-copy Google Drive Copy Folder
• stardotbmp/slack-gas-signup Google Apps Script Html Webapp as sign-up page for a slack channel
• Atlassian Cloud for Gmail add-on An add-on to view information about items from Jira Cloud & Bitbucket Cloud, and take action on them from Gmail.
• Davepar/gcalendarsync Apps Script for syncing a Google Spreadsheet with Google Calendar
• Google Forms Google Scripts for sending emails, generating PDFs and setting response limits inside Google Forms.
• Website Monitor Apps Script for monitoring the uptime of websites inside Google Sheets.
• Gmail Unsubscriber Google Script for unsubscribing from emails newsletters and other bulk email in Gmail with one click.
• Flubaroo Add-on for Google Spreadsheets that allows teachers to quickly grade assignments, get insights into student performance, and share grades with their students electronically
• Code Blocks Syntax highlighting for Google Docs
• mithunmanohar/woocommerce-orders-google-sheets-integration Connect and sync order data from your WooCommerce store to Google sheets automatically. A free alternative to Zapier-WooCommerce integration that saves new WooCommerce order details to google sheets. Version V2 with improved features is now available
• gauravgrover95/woocommerce-smartsheets Google Spreadsheets add on to import your WooCommerce supported E-Commerce website data to Google Sheets
• sajacy/google-sheets-what-if-analysis Replicates the Excel "What-If Analysis" feature, Data Tables
• zmandel/timeline-jira-google-sheets Create Jira timelines for multiple projects in Google Sheets

goto top ⇑

Chatbots

• Google Apps Script Sheet MQ Google Apps Script endpoint for Hangouts Chat bot using Sheets as a message queue
• Facebook-bot-Google-Apps-Script A Facebook messenger bot implemented in Google Apps Script
• GroupMe Bots with Google Apps Script Examples and resources for using the GroupMe Bot API with Google Apps Script
• Viber/build-a-bot-with-zero-coding An example of using Google Sheets to create a Viber survey chat bot without a backend server
• Google-Telegram transfer bot This Google Apps Script links a Telegram bot to a google spreadsheet and allows command-based information storaging
• banghasan/Telegram-Lib-GAS-V2 Library Telegram untuk Google Apps Script Versi 2
• Guf-Hub/TGBot Google Apps Script library for working with the Telegram API. Google Apps Script библиотека для работы с API Telegram

goto top ⇑

Testing

• huan/gast Google Apps Script TAP Testing-framework
• GSUnit is a Google Apps Script based testing framework based on JUnit by Kent Beck and JSUnit by Edward Hieatt. It will allow one to run tests while developing
• classroomtechtools/modularLibraries.gs/UnitTesting Assertion and unit testing of modular libraries
• simula-innovation/qunit An easy-to-use JavaScript Unit Testing framework
• artofthesmart/QUnitGS2 A Google Apps Script library that brings the power and simplicity of QUnit unit testing to your scripts and applications. In just 60 seconds you can add unit testing to any script.
• gasunit/GASUnit Testing library for Google Apps Script
• WildH0g/UnitTestingApp Unit Testing App for Google Apps Script that works online (in GAS environment) and offline (in your IDE).

goto top ⇑

Logging

• huan/gasl Google Apps Script Logging-framework
• BetterLog Logging library that extends the native apps script Logger, mainly to allow logging to a GSheet
• BBLog Logging library that further extends BLog to give logging to a Firebase DB multiple logging instances logging of function names and line numbers log the user's email address or ID, in a full or disguised format automatically format log GSheet

goto top ⇑

Benchmarking

• Benchmark Benchmark: Loop for Array Processing using Google Apps Script without V8

goto top ⇑

Snippets and assorted

Snippets

Collections

• Google Apps Script snippets ᕦʕ •ᴥ•ʔᕤ
• Collection of Apps Scripts for connecting to APIs

Spreadsheets

• [Apps Script] Getting the unmerged ranges within a range
• Google Apps Script to fill in a Document template with Spreadsheet data
• ReshapeReshaping functions for Google Spreadsheets
• Sample HTML/JS to parse a Google Spreadsheet
• Example on how to export a Google sheet to various formats, includes most PDF options

Gmail

• Apps-Script-Gmail-Push-Notifications-v2 Register a Gmail account for push notifications and programmatically set up the the proper pubsub publishing channels and subscriptions
• Gmail2GDrive Automatically stores and sorts Gmail attachments into Google Drive folders - replaced by Gmail Processor
• Gmail Processor Very powerful and flexible Google Apps Script library that automatically stores Gmail attachments into Google Drive folders and many more features

XML

• xmlToJson A function to convert an XML string to a JSON object in Apps Script, using logic similar to the sunset method Xml.parse()

JSON

• JSON Puller Transforms the data of a given Spreadsheet Sheet to JSON.
• JSONPath Extract data from complex data structures with simple expressions. Google Apps Script version of this library.
• ImportJSON Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet

Fetch

• mayrsascha/UrlFetchAppWithRetries.gs Retriable requests batch for Google Apps Scripts

Assorted

• GoogleSheets best code I've tested in Google Sheets
• google-docs Libraries and functions used within Google Docs
• youtube/api-samples/apps-script The youtube-data-api.gs file in this directory contains code snippets that are generated by the Data API code snippet tool at: https://developers.google.com/youtube/v3/code_samples/code_snippets
• derekantrican/Google-Apps-Script-Library A variety of functions/programs written for Google Apps Script and Google services
• stardotbmp/google-sheet-functions A single repository for open sharing of custom functions I have found to be useful generally
• googlesamples/apps-script Sample code for Google Apps Script, a cloud-based scripting service for Google Apps
• An Example of using an HTML form (e.g: "Contact Us" on a website) to send Email without a Backend Server (using a Google Script)
• rudimusmaximus/BurningGAS Demonstrate various Google Apps Script using a menu of functions inside a fresh Google Sheet and container bound editor
• GAS-Framework - library boilerplate that provides logging (BBLog) and error handling (Assert)
• AutoSteamGifts A Modified version based on Python script by joaopsys that run on Google server using Google App Script to automatically enter every giveaway that you can afford on SteamGifts.com
• BkperApp A simple and secure way to access the Bkper API through Google Apps Script infrastructure

goto top ⇑