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
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