How to fix Google tokens Expiring after seven days

Question

Is there anyway to get a permanent oauth2 token for Google Sheet API or a semi permanent ?

The one I'm using right now expires once every 7 days which is not very helpful.

If not, is there any alternative for an online spreadsheet application that you can connect with python ?

Answer 1

This depends upon what you are doing if you are accessing a sheet that you own personally then you could use a service account. Service accounts are preauthorized and will not expire.

If you are access sheets that are owned by your users then you will need to use Oauth2. If you request off line access then you will get what is called a refresh token. Refresh tokens can be used to request new access tokens when the access token expires.

As you say that the token is expire after seven days implies that you are using an a refresh token currently. However you have not set your project in google cloud platform to production. As it is still in testing your refreshtoken will expire after seven days.

A Google Cloud Platform project with an OAuth consent screen configured for an external user type and a publishing status of "Testing" is issued a refresh token expiring in 7 days.

How to switch to production.

Go to Google cloud console for your project

Find the Oauth consent screen on the left.

Click got to production