Deleting Multiple Rows in Google Sheets

Questions & Answers
1

I would like to delete multiple rows in a Google Sheets file. From the list of options there you can only delete one row. Anybody have any ideas?

2

Hey @Charles_Henderson

This is indeed very possible and it just depends on the kind of module that you have placed before the ‘Delete a row’ module.

For example, if you use the ‘Get a Range’ module to retrieve the range of rows to be deleted, then you can simply map in the ‘Row ID’ into the ‘Delete’ module:

image
image3135×940 379 KB

This way, all rows retrieved would be deleted in a single run. I hope this helps you.

2 Likes
3

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
4

Sorry, but that didn’t work. I received a RuntimeError

400: INVALID_ARGUMENT - Invalid value at ‘requests.delete_dimension.range.sheet_id’ (TYPE_INT32), “ASC”

5

Thanks. But, honestly, over my head. Thanks anyway.

6

Can you share screenshots of how you set up both modules?

2 Likes
7

Hello, i have the same problem:
400: INVALID_ARGUMENT - Invalid value at ‘requests.delete_dimension.range.sheet_id’ (TYPE_INT32), “Effectif”
please help me, i don’t find solution :frowning:
image

image
image1136×576 87.5 KB