Andrew Kamphey

Use Apps Script to receive emails whenever there’s a change in your Google Sheet structure Are you an organization with multiple people working on the same Google Sheets file? Then, you might want to know when one of your people changes something in the spreadsheet, whether that be adding

Does Google Sheets have an AI Formula? No but you can add one. Simple use Apps Script to add an AI formula to your sheets. You can use your own AI from Open AI and this comes out to be much cheaper than even $20 a month for ChatGPT at

In this post, we'll cover how to remove rows automatically in Google Sheets using Apps Script, ensuring you save time and streamline your spreadsheet management. You're probably already familiar with the manual way of right-clicking and deleting rows, but there's a more efficient way

A question from the Facebook group "I Love Google Sheets" wants to know how to count numbers between 1 and 16 in a series.  So let us break it down and look at the best way to do this. The question was "How can I count the

Determining whether two cells in Google Sheets are equal or not is a common task that can help streamline data analysis and ensure data accuracy. Open up your spreadsheet and follow along with this guide on how to do this using different methods. Are These Two Cells Equal or Not?

An Exclusive Interview with Becky, Owner of The Template Nook 📺Watch the entire 1 hour interview on YouTube In our latest edition of "Sheet Talking," we dove deep into the world of templates and organization with Becky, the owner of The Template Nook. Becky's unique approach