Work Less and Do More: Google Sheets for JavaScript Developers
summary
Prototype pulls GitHub metrics via octokit and survey results from Google Forms, writes them into Google Sheets using the Sheets API, programmatically creates charts and inserts them into Slides, and deploys as an HTTP Google Cloud Function triggered daily by Cloud Scheduler; front-end uses three‑legged OAuth for Gmail sending and server‑to‑server service account auth for app-owned sheets. Results show a clear hump where food satisfaction tracks with closed issues and merged PRs, and the system emails reports via the Gmail API and stores templates on Drive.
AI-written summary · about
chapters (14)
- 0:00Introduction to talk
- 1:47Why spreadsheets matter
- 4:23Hello world with Sheets API
- 7:52Batch updates and API efficiency
- 8:55Prototyping a real-world problem
- 14:53Moving from local to cloud
- 16:59Cloud Functions hello world
- 18:25Automating with Cloud Scheduler
- 19:50Adding a frontend and Gmail API
- 21:58OAuth 2 authorization flow
- 24:10Server-to-server authentication
- 26:40Analyzing food and GitHub metrics
- 28:04Automating report generation
- 31:21Summary and code review
related talks
33mWork Less and Do More: Sheets for Node.js Developers
51m30 Ways Google Sheets Can Help Your Company Uncover and Share Data Insights
22mAutomating Custom Reports from JIRA to GoogleSheets
16mDo It For Yourself: Creating a data input platform using R
31mAll About Apps Script
43mHow to Simplify Business Processes with G Suite
15mExtending Google Workspace with AppSheet’s no-code platform and Apps Script
09mGoogle Apps Script