All About Apps Script

on YouTube ↗31m

" summary

Concrete takeaways about Apps Script: it runs serverless in Google Cloud, integrates with Gmail Drive Sheets Slides with often one line of code, and skips manual OAuth boilerplate. Watch for demos that actually exist: a BTC custom function calling Coinbase and a button that emails the result, a progress bar per slide generator that edits rectangles, a YouTube-to-slides generator that creates a presentation from search results, and the clasp CLI plus TypeScript workflow. Limits include no Node filesystem or arbitrary native modules.

AI-written summary · about

" chapters (21)

1. 0:00Start
2. 2:15Google Slides Add-Ons
3. 2:57Qa
4. 3:16What Is Apps Script
5. 4:41Advantages
6. 5:42It's Serverless
7. 6:59Disadvantages
8. 8:24Add-Ons
9. 8:52Standalone Web Apps
10. 10:09Sidebar Applications in Google Docs
11. 10:56Google Translate
12. 11:39Translate Add-On
13. 12:57Google Sheets
14. 13:51Add Custom Functions
15. 15:37Buttons and Google Sheets
16. 19:01Translation Demo
17. 20:42Progress Bar
18. 23:20Meeting Assistant
19. 24:39Advanced Services
20. 29:08Auto Completion with Javascript
21. 30:21Summary

" related talks

• 09mGoogle Apps ScriptAndrey Shulga · Frontend fwdays'17
• 17mHow to build apps with AppSheet and Apps Script ConnectorChristian Schalk · Google I/O 2022
• 15mEnhancing user experiences within Google WorkspaceCharles Maxson · Google I/O 2021
• 32mWork Less and Do More: Google Sheets for JavaScript DevelopersFranziska Hinkelmann, Leah Cole · Node+JS Interactive 2019
• 45mAutomate with Google Workspace Low Code and No CodeDararath BEAUVOIR · DevFest Toulouse 2024
• 43mHow to Simplify Business Processes with G SuiteAllen Yang · Google Cloud Next '18
• 33mWork Less and Do More: Sheets for Node.js DevelopersFranziska Hinkelmann, Anu Srivastava · Google I/O 2019
• 15mExtending Google Workspace with AppSheet’s no-code platform and Apps ScriptMike Procopio · Google I/O 2022