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

Get Hidden or Visible Google Sheet Tabs with Google Apps Script

Get Hidden or Visible Google Sheet Tabs with Google Apps Script

Based on a viewer’s recent question, here is how you can get a list of all hidden or visible Google Sheet tabs with Google Apps Script. You can integrate these scripts into your own projects. The Video ...

Read More

Create links to the first item of each group in Google Sheets

Last Updated on 2022-09-07 by Yagi Imagine you have a Google Sheet tab containing a course worth of hundreds of students sorted into classes or groups. After each exam, quiz or assignment, your teacher for each class needs to enter in the grades. To make life easier for your teachers, we want to create a … Continue reading "Create links to the first item of each group in Google Sheets" ...

Read More
Duplicating Sheet Views in other Sheet Tabs using Google Apps Script

Duplicate Filter Views in Selected Google Sheet Tabs with Google Apps Script

Last Updated on 2022-08-19 by Yagi While there is not way to directly duplicate Filter Views into other sheet tabs in Google Sheets we can do this with a little bit of Google Apps Script magic. In this tutorial, we will walk through how to duplicate all filter views from a source Google Sheets tab … Continue reading "Duplicate Filter Views in Selected Google Sheet Tabs with Google Apps Script" ...

Read More
Adding links to images in Google Sheets

Adding Links to Images and Buttons in Google Sheets

Last Updated on 2022-08-10 by Yagi Have you ever tried to add a link or URL to an image in Google Sheets only to discover it is deleted and replaced by just the URL? It’s a pain. In this tutorial, we will cover a few simple approaches to adding links to images in Google Sheets. … Continue reading "Adding Links to Images and Buttons in Google Sheets" ...

Read More

Courses

A growing list of free and paid course:

Social

YoutubeICON
TwitterICON
LinkedinICON

%d bloggers like this: