Use Google Cloud Console > OAuth consent screen > set to Testing.
Choose minimal scopes (avoid sensitive ones).
Create OAuth credentials (Client ID + Secret).
In your tool, use these and enable refresh tokens to keep access persistent.
For no 7-day limit, get app verified or use Make’s built inOAuth

built it in Make, which uses its own verified Google OAuth connection for Gmail/Drive/Sheets. That means the tokens stay valid and don’t run into the 7-day expiration you get with personal GCP projects in testing mode. I only adjusted the scopes to what I actually needed

Hi! I haven’t shared this code publicly yet — it’s a personal project I use within my company. Feel free to message me if you’d like to try it out. Happy to connect, and thanks for the follow back! 😉

Hi Michael sorry for my late response yes this is active and a workflow that i build would you like to try it out? I can send you the worklfow:)

Thankyou glad to be here!