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

Find & Select or Format Rows in Google Sheets with Apps Script

Find and Select or Format rows in Google Sheets with Apps Script

In this tutorial, we create 3 Google Apps Script functions that are used to: Find and select the row containing the first or last value in a Google Sheets sheet tab. Find and select all rows containing the search value. Format all rows containing the search text. You can grab a copy of the starter … Continue reading "Find and Select or Format rows in Google Sheets with Apps Script" ...

Read More
Insert Special Characters by Sheets Help GWAOw

GWAOw! 5 – Insert Special Characters by Sheets Help

In this episode of GWAOw!!! we look at Insert Special Characters by Sheets Help. About Insert Special Characters for Google Sheets. As the name suggests, the Insert Special Character Add-on allows you to access the complete list of special characters like maths symbols, shapes and arrows, currency symbols, dingbat and Greek and Coptic symbols from … Continue reading "GWAOw! 5 – Insert Special Characters by Sheets Help" ...

Read More
Analysis of Google Apps Script Create Finder Class Retrieve n found values findAll findNext

Performance of Google Apps Script Text Finder Class on 2 Approaches to Searching Large Datasets

Inspired by research into a recent blog post, the Google Apps Script Text Finder Class’ Find All (findAll()) and Find Next (findNext()) methods were benchmarked over two different datasets containing 50,000 rows. The first dataset contained 1,000 cells matching the search text. The second dataset contained 100 matching cells. For each dataset, a test was … Continue reading "Performance of Google Apps Script Text Finder Class on 2 Approaches to Searching Large Datasets" ...

Read More
Find 1st Last nth value in a range with Apps Script

Find first, last & nth value in a Google Sheets range with Apps Script

In this tutorial, we will explore how to find the first and last values in a Google Sheets Range using Google Apps Script. Then we will modify our code to find a value at a specific location. We will then find the position of the first set of values in our Google Sheets range. Lastly, … Continue reading "Find first, last & nth value in a Google Sheets range with Apps Script" ...

Read More

Courses

A growing list of free and paid course:

Social

YoutubeICON
TwitterICON
LinkedinICON

%d bloggers like this: