Skip to content

Google Apps Script

September 29, 2023
February 27, 2021

Apps Script | Google Developers
Overview of Google Apps Script | Google Developers

Standalone Scripts | Apps Script | Google Developers
Back in the old days, GAS had to be attached to a Spreadsheet or Document. Now we can create scripts in standalone Code project.

Apps Script console
Apps Script Quota
Quotas for Google Services | Apps Script | Google Developers

Simple way to interact with other Google services, enable (per project) in Resources > Advanced Google Services.

You can also deploy your GAS as web service, note access MUST be granted to anyone (so that they can execute your script). And remember to create a new project version following each update and redeploy, just like commit and redeploy in backend.

Reference Overview | Apps Script | Google Developers
Apps Script API | Google Developers
Built-in Google Services | Apps Script | Google Developers
Advanced Google services | Apps Script | Google Developers other Google services
Class ContentService | Apps Script | Google Developers
Properties Service | Apps Script | Google Developers

G Suite Developers Blog: Apps Script
Google Apps Script - YouTube

Google Apps Script snippets - Desktop Liberation
Apps Script - Desktop Liberation

Structure and simplify your Google Apps Script | by Jasper Duizendstra | JavaScript in Plain English
How to Learn Google Apps Script
Google Apps Script for Developers - Digital Inspiration
google-apps-script - Getting started with google-apps-script | google-apps-script Tutorial
Automating Google Forms & Sheets using Apps Script | by Varun Joshi | codeburst

Dev setup/examples

Since HTMLService fails silently and there's always a "TransportError: There was an error during the transport or processing of this request. Error code = 10, Path = /wardeninit" error (even if script working properly), it is recommended to use local environment to validate HTML and code before pushing to GAS to test.

Script Projects | Apps Script | Google Developers
google/clasp: 🔗 Command Line Apps Script Projects
clasp - The Apps Script CLI
Create and manage deployments | Apps Script | Google Developers
Develop Apps Script using TypeScript | Google Developers
Google Apps Script for Developers - Digital Inspiration

Taking Away the Pain From Unit Testing in Google Apps Script | by Dmitry Kostyuk | Geek Culture | Medium
mzagorny/gas-local: Execute and test your google app scripts locally in node.js
visual studio code - How to enable autocomplete for Google Apps Script in locally-installed IDE - Stack Overflow npm i -S @types/google-apps-script and import from dummy file (add to `.claspignore``)

clasp clone <project_id>
clasp open # online script editor

clasp pull
clasp push
clasp push --watch

clasp version "First version"
clasp deploy 1 "First deployment"

leonhartX/gas-github: sync gas code to github
LEARN BY EXAMPLE - Google Apps Script Examples
jasonjurotich/JJ-GAS: A collection of Google Apps Script code (GAS) for Google Apps and Classroom

googleworkspace/apps-script-samples: Apps Script samples for Google Workspace products.
noel-yap/science-test-grading: Google Sheets functions to aid with grading science tests including metrics unit conversions and significant figures.
Google Apps Scripts Collection - The Best Google Scripts

How to create an automated calendar with Google Apps Script with open source on top | Opensource.com
Create PDF files from templates with Python and Google Scripts | Codementor
Amazon Price Tracker Made With Google Docs

How to Use Google Docs as a Code Runner - Digital Inspiration

Verifying apps

My Google Apps Script app isn’t verified: Understanding why and how to fix – MASHe
Unverified apps - Google Cloud Platform Console Help
Google Sheets Script - Authorization Required/This app isn't verified - Explained - YouTube
Why does my apps script deployed as API executable return Permission Denied? - Stack Overflow

Google Cloud Platform Projects | Apps Script | Google Developers some API can only be accessed as GCP standard project; add-on or an API executable need GCP standard project

Add ons

Libraries | Apps Script | Google Developers
Extending G Suite with Add-ons | G Suite Add-ons | Google Developers
Use add-ons & Apps Script - Computer - Docs Editors Help

50 Google Sheets Add-Ons to Supercharge Your Spreadsheets - The Ultimate Guide to Google Sheets | Zapier
15 Best Google Sheets Add Ons & Power Tools to Supercharge Your Data - Automate.io Blog

Fetch

Class UrlFetchApp | Apps Script | Google Developers

Apps Script Navigator: UrlFetchApp Empowered With Cookie Management, Re-Login, and Much More! - DZone Performance
Navigator - Project Editor - Apps Script

Database

JDBC | Apps Script | Google Developers
Class Jdbc | Apps Script | Google Developers

mysql - Bulk insert to Cloud SQL by appscript using JDBC executeBatch() consuming too much time - Stack Overflow JDBC client is known to be slow

HTML UI

use alpine.js, Lit or other light-weight frameworks

HTML Service: Create and Serve HTML | Apps Script | Google Developers
Class HtmlService | Apps Script | Google Developers

HTML Service: Communicate with Server Functions | Apps Script "Server" is the App script
Class google.script.run (Client-side API) | Apps Script

Sending Email

dwyl/learn-to-send-email-via-google-script-html-no-server: 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) perfect for static websites that need to collect data.
Contact Form Example

Adding a Script to a Google Form to Email Responses - FormEmailer - YouTube
FormEmailer

Google Sheets

Spreadsheet Service | Apps Script | Google Developers

Google Sheet 自製股票監察表教學 一表自動監察股價上落 - ezone.hk - 教學評測 - 應用秘技 - D190329
How to Work with Google Sheets and Apps Script | Toptal

Form -> Sheet

Google Sheets API - HTML Form Data to Google Sheet - YouTube

Creating an Editable Webpage With Google Spreadsheets and Tabletop.js | CSS-Tricks use Papa Parse instead
jsoma/tabletop: Tabletop.js gives spreadsheets legs
Papa Parse - Powerful CSV Parser for JavaScript

jamiewilson/form-to-google-sheets: Store HTML form submissions in Google Sheets.
How to Submit an HTML Form to Google Sheets…without Google Forms
Google Spreadsheets as a Database – INSERT with Apps Script form POST/GET submit method – MASHe
Turn Google Sheets into Your Own Database with Python | by The PyCoach | Towards Data Science

Sheet -> Form

Forms Service | Apps Script | Google Developers

Google I/O 2013 - Use Apps Script to Create Dynamic Google Forms - YouTube
Google Forms - Drop Down List from Spreadsheet Using Apps Script - YouTube
Apps Script: Dynamic Forms Multiple Choice - YouTube
Create Dynamic Questions on a Google Form - Stack Overflow
Creating form with a script : Page Break and go to page issue - Stack Overflow
Google Forms - Drop Down List from Spreadsheet Using Apps Script - YouTube using Forms Service

NEW GAS TO CREATE FORMS FROM SHEETS WITH TEMPLATE - YouTube
JJ-GAS/formFromSheetComplete.gs at master · jasonjurotich/JJ-GAS

Google Forms Quiz functionality for Google Apps Script FormApp Class TextItem [117437423] - Visible to Public - Issue Tracker cannot set correct answer to text item (only choices)
Google Forms - Inserting an image in a multiple choice field using Apps Script - Stack Overflow
Get and set images to checkbox and multiple choice items. [36765518] - Visible to Public - Issue Tracker cannot add image to choice item choices