I’m running into a problem similar to what others have described, namely I must reauthorize my connection to Firestore every day. In my case, there’s one nuance, namely that when I connect via a gmail account (the gmail user is a project member in Firestore), the connection is persistent. It’s only when I connect via my Google Workspace account (for the org that owns the Google Cloud account) that the connection needs daily re-authorization.
I’ve read this thread:
And a few of those referenced in that thread as well, with no luck.
I tried setting up a service account in Google Cloud, which seems like it ought to be the right approach, but I can’t figure out how to make the connection in Make point to that.
Is the custom OAuth application the only way to do this? It just seems odd that connecting via a gmail account works, but the google workspace account does not. If anything, I’d expect the opposite.