# Deleting Multiple Rows in Google Sheets **URL:** \ **Category:** Questions\ **Tags:** google-sheets\ **Created:** [January 30, 2024, 2:14pm UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906 "2024-01-30T14:14:20Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Charles\_Henderson](https://avatars.discourse-cdn.com/v4/letter/c/ee7513/32.png) [@Charles\_Henderson](https://community.make.com/u/Charles_Henderson)\ **Post date:** [January 30, 2024, 2:14pm UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/1 "2024-01-30T14:14:20Z")
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? ---
**Author:** ![Olly\_Ats](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/olly_ats/32/19458_2.png) [@Olly\_Ats](https://community.make.com/u/Olly_Ats)\ **Post date:** [January 30, 2024, 2:43pm UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/2 "2024-01-30T14:43:25Z")
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](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/d/7d0f98fcdcf2a82081e9ab3331edf800c38250e4.png) This way, all rows retrieved would be deleted in a single run. I hope this helps you. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [January 30, 2024, 3:01pm UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/3 "2024-01-30T15:01:27Z")
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](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/batchUpdate) endpoint with a [DeleteRangeRequest](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request#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](https://community.make.com/t/how-to-bulk-update-non-consecutive-rows-in-google-sheets-using-the-batchupdate-api/24544/3), with different endpoints. ---
**Author:** ![Charles\_Henderson](https://avatars.discourse-cdn.com/v4/letter/c/ee7513/32.png) [@Charles\_Henderson](https://community.make.com/u/Charles_Henderson)\ **Post date:** [January 30, 2024, 6:15pm UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/4 "2024-01-30T18:15:52Z")
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” ---
**Author:** ![Charles\_Henderson](https://avatars.discourse-cdn.com/v4/letter/c/ee7513/32.png) [@Charles\_Henderson](https://community.make.com/u/Charles_Henderson)\ **Post date:** [January 30, 2024, 6:21pm UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/5 "2024-01-30T18:21:38Z")
Thanks. But, honestly, over my head. Thanks anyway. ---
**Author:** ![Olly\_Ats](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/olly_ats/32/19458_2.png) [@Olly\_Ats](https://community.make.com/u/Olly_Ats)\ **Post date:** [January 31, 2024, 2:04pm UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/6 "2024-01-31T14:04:50Z")
Can you share screenshots of how you set up both modules? ---
**Author:** ![NikoHZP](https://avatars.discourse-cdn.com/v4/letter/n/848f3c/32.png) [@NikoHZP](https://community.make.com/u/NikoHZP)\ **Post date:** [April 1, 2024, 10:15am UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/7 "2024-04-01T10:15:28Z")
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 ☹ ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/3/037f4a6fde0ed15a56368eb44688e89265310cec.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/c/bca6780dacfee228eb8e1d9f3e1b19801d905356.png) ---
**Author:** ![DavieVT](https://avatars.discourse-cdn.com/v4/letter/d/f9ae1b/32.png) [@DavieVT](https://community.make.com/u/DavieVT)\ **Post date:** [June 20, 2024, 8:54am UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/8 "2024-06-20T08:54:14Z")
Hola Amigo!. Encontré este [ejemplo](https://community.make.com/t/delete-all-google-sheet-rows-except-header/3618/4) en la comunidad de cómo usar DeleteRangeRequest. Espero te ayude! ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 20, 2024, 9:01am UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/9 "2024-06-20T09:01:10Z")
Welcome to the Make community! Could you please create a separate topic for this? While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic. It helps other community users to respond to your query, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy. The “New Topic” link can be found in the top-right of the header: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/9/19db8a73cb15fc814d547cb51182fb0b856f453a.png) > ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers! ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [July 4, 2024, 9:04am UTC](https://community.make.com/t/deleting-multiple-rows-in-google-sheets/25906/10 "2024-07-04T09:04:09Z")