Nithin Murali

I see. In that case i think pyghseets should do a cleanup (delete all with prefix pygsheets) in authorize before creating the tmp directory.

which specific function are you using? can you please provide a reproducible example?

This library internally calls the google sheets api, So this could be an issue from the api side. You could try running their native api code and check if you...

for a quick work-around what about `update_col('A1', ['']*1000)`. I think we can add such functionality in DataRange. To fill the whole range with same value.

This will require implimentation of AutoFill Request. https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request#autofillrequest

how many times (approx) does the script runs before it fails auth?

Using Authlib instead of google-auth might help resolve this. (using AssertionSession) This might need some changes in library code. [ref](https://gspread.readthedocs.io/en/latest/advanced.html)

There are no code changes for updating the library since there is no version pinning. I am unable to reproduce this, you can try deleting your existing credentials and try...

you are facing this issue when the script if running for long time right? you can access sheets initially but after some time when the token expires, this error happens?

ref #483