Work Less and Do More: Sheets for Node.js Developers

on YouTube ↗33m

" summary

Claims that Node.js plus Google APIs can automate collecting GitHub metrics and food-survey data, build charts and generate/share reports end-to-end. Uses Octokit to fetch repo metrics, Sheets batchUpdate and AddChart to write ranges and create line charts, Cloud Functions deployed via gcloud with Cloud Functions + Scheduler to run daily, and Gmail/Slides/Drive APIs (using Gmail.users.messages.send and restricted drive.file scope) to email and produce templated reports; deployed pipeline runs and shows a positive correlation between food satisfaction and merged PRs.

AI-written summary · about

" chapters (7)

1. 0:00Start
2. 1:39Charts
3. 15:53Types of Cloud Functions
4. 19:16Cloud Scheduler
5. 22:13Three-legged OAuth
6. 24:05Backend auth
7. 24:59Two-legged OAuth

" related talks

• 25mWork Less and Do More: Google Sheets for Node.js DevelopersFranziska Hinkelmann, Do More, Anu Srivastava · NodeConf.EU 2019
• 32mWork Less and Do More: Google Sheets for JavaScript DevelopersFranziska Hinkelmann, Leah Cole · Node+JS Interactive 2019
• 54mFocus on Your Code, Not Infrastructure, with Google Cloud FunctionsMartin Omander · Windcity DevFest 2019
• 31mAll About Apps ScriptGrant Timmerman · DevFest Florida 2019
• 28mScale Down, People Up: Making the Web More ApproachableJessica Lord · ColdFront 2017
• 39mGetting Started with Node.JSDerek Watson · Spotlight: MEAN Stack 2014
• 26mObserving Node.js: Using Metrics to Improve your Application PerformanceGuilherme Hermeto · OpenJS World 2021
• 30mSpend More Time Coding & Automate the Boring StuffMartin Woodward · Developers Summit 2021