Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
💡 Learn moreLearn how to write Apps Script and turbocharge your Google Workspace experience with the new Beginner Apps Script course Google Sheets Macros are small programs you create inside of Google Sheets without needing to write any code. They’re used to automate repeatable tasks. They work by recording your actions as you do something … Continue reading The Complete Guide to Simple Automation using Google Sheets Macros
New course Stop dabbling with Gemini. Start building AI systems. One-off prompts → repeatable workflows Gemini across all your Workspace tools Automations and agents that save hours NotebookLM, vibe coding, Gemini Gems $149 Get instant access → This Google Sheets tutorial will help take you from an absolute beginner, or basic user, through to a … Continue reading How to use Google Sheets: A Beginner’s Guide
Editor’s Note: Strava updated their OAuth workflow (see here), which may break the code shown below. This post looks at how to connect the Strava API with Google Sheets and create a visualization in Google Data Studio. Strava is an insanely good app for athletes to track their workouts. I use it to track my … Continue reading How to connect the Strava API with Google Sheets and Data Studio
Slicers in Google Sheets are a powerful way to filter data in Pivot Tables. They make it easy to change values in Pivot Tables and Charts with a single click. Slicers are extremely useful when building dashboards in Google Sheets.
Behold the Google Sheets Formula Clock, a working analog clock built with a single Google Sheets formula: It’s a working analog clock built with a single Google Sheets formula. That’s right, just a single formula. No Apps Script code. No widgets. No hidden add-ons. Just a plain ol’ formula in Google Sheets! Google Sheets Formula … Continue reading Google Sheets Formula Clock