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

on YouTube ↗25m

" summary

Node.js code uses the Sheets API and Octokit to pull GitHub metrics, writes rows with a batchUpdate, builds charts via the Sheets chart spec, and sends scheduled reports using Cloud Functions triggered by Cloud Scheduler and the Gmail API. Authentication contrasts three-legged OAuth for user-owned emails versus service-account server-to-server for app-owned sheets. Prototype runs on GCP, emails a daily chart, and claims “good food yields good code” from the collected survey correlation.

AI-written summary · about

" chapters (5)

1. 0:00Start
2. 1:530. Prototyping
3. 12:45Types of Cloud Functions
4. 14:42Cloud Scheduler
5. 20:21Backend auth

" related talks

• 33mWork Less and Do More: Sheets for Node.js DevelopersFranziska Hinkelmann, Anu Srivastava · Google I/O 2019
• 54mFocus on Your Code, Not Infrastructure, with Google Cloud FunctionsMartin Omander · Windcity DevFest 2019
• 51mCloud Native Development Level Up for Smaller TeamsYoyu Li · Games Gathering Bratislava 2023
• 39mGetting Started with Node.JSDerek Watson · Spotlight: MEAN Stack 2014
• 26mKeynote talk - The future of Node.jsThomas Watson · jsPoland 2018
• 01h 06mAwesome Node.js microservices in the cloud for (almost) freeGojko Adzic · NDC Sydney 2016
• 38mFocus on your code, not infrastructure, with Cloud FunctionsMartin Omander · DevFest Florida 2019
• 46mBuilding an OAuth Flow in a Node.js CLITaylor Krusen · iJS London 2019