Using Python to clear all the cell values in google sheet before adding data

Question

I have a Google Spreadsheet which I'm populating with values using a python script and the SQL query. I need to run the script every one hour, I'd like the script to first clear all the data from the rows before populating it, that way I have a fresh set of data every time I run the script.

Answer 1

What you are looking for seems to be: gspread.Worksheet.clear()