Home: Google Workspace Development, Google Sheets, Front-end, Google Cloud

A place to expand your knowledge of Google Workspace, learn new Google Sheets formulas and tricks, and automate the boring stuff with Google Apps Script.

More?! Well, I also explore front-end development (JavaScript, HTML, CSS) and dive into other Google Cloud products like Firebase, and all the fancy Google APIs like Maps, Document AI, Chat, Admin Directory and so… so much more.

You can select from the 3 main categories below and see what I have been writing lately. In the sidebar, you can select a category item or use the search bar in the top right.

Want some more structured content? Head over to my courses pages for FREE and quality courses to upskill than grey mush 🧠! Need a handy solution for Google Sheets? Check out my products page or my list of Google Workspace Add ons.

All Posts

Latest Posts

Create and Array from the difference between two arrays in JavaScript

Get the Difference Between Two Arrays in JavaScript

Sometimes we want to compare the difference between two arrays in JavaScript and return the remaining values in a new array. This can be useful for inventory or purchase management where we could compare the selected items against the available stock, for example. In this tutorial, we will cover two approaches to this: A single … Continue reading "Get the Difference Between Two Arrays in JavaScript"...

Read More

How do I reverse a range by Rows or Columns in Google Sheets

Google Sheets: SORT, INDEX, ROWS Sometimes you have a need to reverse a list quickly in Google Sheets. That’s pretty easy to do if the list is sorted alphabetically. Just go on into the <Data> menu and choose from one of the sort functions. But what if the data you want to flip is not … Continue reading "How do I reverse a range by Rows or Columns in Google Sheets"...

Read More
add date and time to a google sheets adjacent cell on edit apps script

Add the Current Date to a Sheet When Data Is Added So That The Date Does Not Change(Static) – Google Sheets (Updated July 2023)

Google Sheets, Google Apps Script: onEdit You’ve probably come across the problem where you need to know when a piece of data has been added to your spreadsheet. You probably have been equally frustrated that there is no out-of-the-box function that will do just this. You’ve tried TODAY() and NOW(), but they change dynamically. What … Continue reading "Add the Current Date to a Sheet When Data Is Added So That The Date Does Not Change(Static) – Google Sheets (Updated July 2023)"...

Read More
List all files and Folders in a Directory Tree in Google Drive with Apps Script

List all files and folders in a selected folder’s directory tree in Google Drive: Apps Script

If you have ever tried to get a list of all the child files and folders of a parent folder in Google Drive, you’ve no doubt discovered that it is a slow old process. Iterating over each item in a folder and then reading the metadata of that file or folder before calling the next … Continue reading "List all files and folders in a selected folder’s directory tree in Google Drive: Apps Script"...

Read More

Courses

A growing list of free and paid course:

Social

YoutubeICON
TwitterICON
LinkedinICON

%d bloggers like this: