How to delete a row in Google sheets after applying filters in a workflow?

[akgshanmuga]

Hi Pabbly Team,

In my workflow, i wish to delete a row after using the filters.

But to do this when i select "Delete Row" option in the action trigger, i am prompted to enter the Start Row and End Row.

In my case i have only one row to delete (After applying the filters)

I get the following error
Error Code: 400
Error Message:Invalid requests[0].deleteRange: No grid with id: 0
Error Statur: INVALID_ARGUMENT

How to sort this issue? Kindly advise

Thanks and Regards

 

[Pabblymember11]

Hey @akgshanmuga

For your concern, please refer to the following thread with the "Delete Row" action step of Google Sheets.

- https://forum.pabbly.com/threads/qu...et-integration-through-pabbly.1387/#post-6540

Thanks!!

 

[akgshanmuga]

Hey @akgshanmuga

For your concern, please refer to the following thread with the "Delete Row" action step of Google Sheets.

- https://forum.pabbly.com/threads/qu...et-integration-through-pabbly.1387/#post-6540

Thanks!!

Hi Pabbly Team,

I tried resolving the issue. But still i get the same error message.

Can you please check my workflow named "Trial Data Cleaner" in my account.

Thanks

 

[Pabblymember11]

Hey @akgshanmuga

I was able to figure out the issue.

I was unable to delete the row in my "Form Response Sheet"

Whereas if I copied the data to a new spreadsheet and if the data lies in "Sheet1", i was able to perform the deleting the row option.

Is there any way wherein we can delete the row straightaway from the "Form Response Sheet"?

As of now, you have to maintain the respective sheet at index 1 in the Spreadsheet in terms to delete the row from the sheets.