To clear a range, you can use the clear cell module:
To DELETE multiple rows, you would need to use the API call module:
Notes:
Replace “AAAA…AAAA” in the URL with your spreadsheet ID
In the body, replace “123456789” with your sheet ID
Rows are indexed from 0. The reference below refers to rows 2 through 1000001
“endRowIndex”: 1000000,
“startRowIndex”: 1
Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or Excel)