What are you trying to achieve?
Return all rows in a google sheet so that I can clear the sheet/delete the rows
Steps taken so far
Its working, just not consistently. I have to run the process multiple times to delete all rows.
run it the first time, about 80% of the sheet is deleted. Run again, 5 more rows, run again 3 more rows, etc until the last row is finally deleted.
This tells me that with no filter active, not all rows are being returned, even though I am not setting a limit on rows and there are not that many to begin with (about 20).
The scenario is simple: Search google sheets module + Delete row google sheet module.
Is this a known issue with the search module and is there a workaround for my use-case? Such as “delete all rows” option I am overlooking?