Deleting Multiple Rows in Google Sheets

If you want to delete lots of rows (e.g.: >50), you won’t want to use 50 operations to delete the rows.

You can delete them in a single operation if you use the spreadsheets.batchUpdate endpoint with a DeleteRangeRequest, using the Google Sheets “Make an API Call” module.

It would be similar to How to bulk update non-consecutive rows in Google Sheets using the batchUpdate API? - #3 by samliew, with different endpoints.

3 Likes