Hello @gwathiell
Thank you very much for using our plugin. The issue described is not exactly related to the “Calculated Fields Form” plugin but the commercial complementary plugin “Spreadsheet for Calculated Fields Form”.
However, the possible reasons stated into the Google documentation ( https://developers.google.com/identity/protocols/oauth2#expiration ) are:
1) The user has revoked your app’s access.
2) The refresh token has not been used for six months.
3) The user changed passwords and the refresh token contains Gmail scopes.
4) The user account has exceeded a maximum number of granted (live) refresh tokens.
5) The user belongs to a Google Cloud Platform organization that has session control policies in effect.
… and it has the following note: 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.
From the above points:
You can discard the #1 (explicit revocation by the user) and the #3 (user changed password) since the user account is yours.
We can discard the #2 (six months expiration) since it expires in less time.
We can discard the #4, unless you have a lot of applications connected to that account.
The #5, about the “Google Cloud Platform project” and the note about the expiration every 7 days seems to be the cause.
Please confirm if the #5 is the case and then consider requesting the approval of the application to remove its testing status (it may be a slow approval process by Google) or consider other account to setup the application.
You can read more about the Google application “publishing status” at the following page:
https://support.google.com/cloud/answer/10311615#publishing-status
Thanks.
