I have a workflow that uses OAuth to write to a Google Spreadsheet. Works fine - at first.
But at some stage it just stops working and I have to re-connect it.
Authorizations by a test user will expire seven days from the time of consent. If your OAuth client requests an offline access type and receives a refresh token, that token will also expire.
Yes, Service Account credentials can make some things easier . Alternatively, you should also be able to make this an Internal application (if you’re a Google Workspace user with a Google Cloud Organization) according to the documentation linked above.
Yeah, unfortunately it seems my account does not allow me to create “internal” applications. A bit of a bummer. I guess it’s back to using a service account then.