/google-apps-script-awesome-list

The usual list of links to interesting resources for Google Apps Script

Google Apps Script List

Resources

Useful sites & blogs

Awesome code & things

Lists & collections

goto top ⇑

Development

Starter Kits

Shims and polyfills

goto top ⇑

Libraries & Modules

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

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

Utility

  • 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
  • zlib.js for Google Apps Script Compact zlib, deflate, inflate, zip library in 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.

Parsing

oAuth

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

Pack modules and universal libraries

Services

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
  • Data Connector Import JSON and other data to Google Sheets
  • Mailman Mail merge for Google Sheets and Gmail

goto top ⇑

Chatbots

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

Spreadsheets

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

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

Assorted

goto top ⇑