Google Apps Script

on YouTube ↗09m

" summary

Google Apps Script (plain JavaScript) is used to connect Google services and external APIs to extract hundreds of key–value translation manifests from a large e‑commerce stack (examples: AndroidArmor, LOREAL). The approach consolidates those manifests into a single Google Sheet so clients can review and update translations without opening each file, using container‑bound vs standalone scripts, properties↔spreadsheet synchronization, and a custom sidebar UI; quotas are noted but corporate limits are sufficient.

AI-written summary · about

" related talks

• 31mAll About Apps ScriptGrant Timmerman · DevFest Florida 2019
• 43mHow to Simplify Business Processes with G SuiteAllen Yang · Google Cloud Next '18
• 15mExtending Google Workspace with AppSheet’s no-code platform and Apps ScriptMike Procopio · Google I/O 2022
• 43mDevelop, Market and Monetize a Google Add-on with Apps ScriptRomain Vialard · DevFest Paris 2015
• 32mWork Less and Do More: Google Sheets for JavaScript DevelopersFranziska Hinkelmann, Leah Cole · Node+JS Interactive 2019
• 34mIntegrate Google Workspace with your solutionsCharles Maxson, Olaf Hubel, Matthew Izatt, Steven Bazyl · Google I/O 2021
• 24mJavaScript, spreadsheets and APITomasz Stachewicz · ConfrontJS 2022
• 45mAutomate with Google Workspace Low Code and No CodeDararath BEAUVOIR · DevFest Toulouse 2024