How to clear all the data of a google sheet?

[kkpatel (Kamal)]

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.

[Pankaj.Patil (Robot Master)]

@kkpatel,

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

https://www.ablebits.com/docs/google-sheets-clear-data/

Google Sheets Delete Rows (Or Clear)

Hi All, I am making a workflow which receives a report from a location and then puts the contents onto a google sheet, overwriting the existing data. With the current Google Sheets activities, there is no way for me to delete rows or to delete the contents. Does anyone have any work arounds doing such?