Index

In this episode of Google Workspace Add On Walkthroughs (GWAOw!), we take a look at Workbook Statistics by Sourabh Choraria. Workbook Statistics is a FREE add-on that allows you to get intimate with all of your Google Sheets stats from your menu bar. You can grab stats on the number of rows, sheet names, pivot … Continue reading "GWAOw! 1 – Workbook Statistics by Sourabh Choraria" ...

Working with IMPORTRANGE data in Google Sheets can be a little tricky. It may feel at times that it does not play by the same rules as when you are building formulas with data in the same Google Sheet. In this tutorial, we’ll go through two approaches to filtering and sorting your IMPORTRANGE data by … Continue reading "Filtering IMPORTRANGE data in Google Sheets" ...

If you have tried to seamlessly subscribe a user to a Google Calendar as part of an automation workflow in Google Apps Script and discovered that all that happens is that the user gets an automated email request to join, and then it is up to them to accept the calendar invitation to add it … Continue reading "How to force subscribe a user in your domain to a Google Calendar with Google Apps Script." ...

There have been a few instances in my work where I need to remove a button (more accurately, a button drawing) or and image from a Google Sheets tab once the associated script has been run. Perhaps we just want the user to run a process on a Google Sheet workbook, just once but not … Continue reading "How to remove a Google Sheets button (drawings) or images connected to a Google Apps Script after the script has been run" ...