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

To the written tutorial and Starter sheet: https://yagisanatode.com/find-and-hid...

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 **
   • Apps Script - Find & Replace in Googl...  

** My Site **
https://yagisanatode.com/

** More on Google Apps Script **
https://yagisanatode.com/google-apps-...

** Products **
Courses *
https://yagisanatode.com/products-cat...

Google Workspace Tools *
https://yagisanatode.com/products-cat...

Google Workspace Add-ons *
https://yagisanatode.com/products-cat...