Lightweight Collections: Simplifying Data Storage for Small Tasks and Rapid Prototyping1. Introduction to Lightweight Data StorageApr 14Apr 14
How to change user language with Google Apps ScriptIf you have a paid Google account (not @gmail), you can change the locale of your user:Apr 8Apr 8
Forward Gmail to Telegram VS AI/App Script/Make.comWould be great to run Google Apps script from Make scenario automatically. Here’s how it’s possible.Feb 18Feb 18
🛢️How to Connect Google Sheets to BigQuery: A Simple GuideIn the world of AI, Google Sheets is still cool. It’s loved for its functions, easy sharing, and the wonder of Google App Script. But…Dec 10, 2024Dec 10, 2024
Google Sheets Add-on. From idea to MVP (Story in pictures)September 2024. Now I have an add-on in closed beta.Sep 12, 20241Sep 12, 20241
Gantt Chart on Dependencies with Recursion in Google Sheets. Part 1Our goal is a GANTT chart in Sheets based on dependencies.Jun 21, 2024Jun 21, 2024
6 reasons you should be using the LET function in Google Sheets.The LET function can have an amazing impact on your Google Sheets formulas.Jun 17, 2024Jun 17, 2024
Evolution of VLOOKUP in Google SheetsMost of us start with a simple VLOOKUP but as our needs evolve — the tables grow and our requirements grow with them.Jun 10, 20241Jun 10, 20241
Google Sheets FILTER with “IN” Logic: List Has Value from Master ListBenchmark 4 different approaches and select the best formula for your Google Sheets project.May 5, 2024May 5, 2024