Find & hide rows in Google Sheets using Sheets Advanced Service Batch Update with Apps Script

This tutorial relies on the Google Sheets API Advanced Service to make a batch update request bundling all hide and unhide ranges into a single request to the Google Sheet.

00:00 What we will build
00:52 Add Sheets Advanced Service
02:10 Build batch update request
03:42 Update dimension properties JSON object
08:24 row range placeholder
08:47 Iterating through all occurrences.
15:28 testing the code

** Part of the Find and Replace with Apps Script Series **

** My Site **

** More on Google Apps Script **

** Products **
* Courses *

* Google Workspace Tools *

* Google Workspace Add-ons *