ellisar/google-apps-script-awesome-list

Google Apps Script - Useful resources, libraries, videos and tutorials

Google Apps Script List

• Resources
  • Useful sites & blogs
  • Awesome code & things
• Development
• Libraries & Modules
  • Using databases
  • ORM (O/RM and O/R mapping tool)
  • Utility
  • Parsing
  • oAuth
  • Images & Pictures
• Add-ons
• Testing
• Logging
• Snippets and assorted
  • Snippets
  • Assorted

Resources

• Google Apps Script G+ Community
• Developing add-ons for Google Docs/Sheets/Forms G+ Community
• Search by label [google-apps-script] on GitHub
• SO [google-apps-script] tag
• Medium Google Apps Script tag

Useful sites & blogs

• ctrlq.org 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 Eveybody
• 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

Awesome code & things

• Making a virtual machine in Google Sheets
• Easy data scraping with Google Apps Script in 5 minutes

Development

• node-google-apps-script The easiest way to develop Google Apps Script projects
• gas-local Execute and test your google app scripts locally in 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-shell Starter template to develop locally Google AppsScript project with your prefered code editor (include build and publish as Add-on commands)
• gas-lib NPM package to add code auto-completion for Google AppsScript in your prefered 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
• google/clasp Develop Apps Script projects locally
• apps-script-starter A starter kit for building Google Apps Script projects with modern JavaScript ES6, Webpack, Babel and ESLint inside Visual Studio Code.

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)

• 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.
• itmammoth/Tamotsu Object-Spreadsheet Mapping for Google Apps Script

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

Parsing

• Apps-Script-htmlparser2-library A browserified version of fb55/htmlparser2 modified to work in Google Apps Script

oAuth

• 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

Add-ons

• google-docs-add-on Publish to WordPress from Google Docs

Testing

• 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

Logging

• gasl Google Apps Script Logging-framework

Snippets and assorted

Snippets

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

Assorted

• GoogleSheets best code I've tested in Google Sheets
• google-apps-script-snippets Google Apps Script Snippets
• 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
• google/google-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
• 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)