How to clear all the data of a google sheet?

Hi All

I have a google sheet which I need to clear in every run. So if I would use Delete Range then I need to specify the range. But how to know the range ?

Else let say I read the sheet and then I clear the data table and then using Write Range I write the blank data table into the same sheet. In this case its not working. The same data is there in the sheet.


I have not worked Google sheets till now but below weblink will probably solve your problem,