Google Sheets

Filter Google Sheets

Create Your Own APIs with Google Sheets and Google Apps Script (Part 1)

During development of an application, sometimes the APIs required to gather the data are not ready. You could hard code data into your application. However, that doesn’t provide the experience…

March 20, 2023 • 3 minute read

Populate and Filter Dates Between Start/End Dates in Google Sheets

Have you ever needed to populate a column with all the dates between a start and end date? What if you needed to ignore certain dates? What if you only…

May 17, 2022 • 4 minute read

Move Row on Edit using Google Sheets

Have you ever needed to move a row of data from one sheet to another when entering a specific value into a specific column? With this article, you’ll learn how…

December 11, 2021 • 4 minute read

Approval Process with Email Notification using Google Sheets

Imagine collecting requests on a Google sheet and wanting a way to process those requests by moving them to another sheet. At the same time, you’d like to email the…

January 6, 2021 • 8 minute read

Website Status Check

Is your website currently up and running? Wouldn’t it be nice to get notified if your website was down? Using Google Apps Script and Google Sheets, let’s create something that…

August 31, 2020 • 7 minute read