The project comprises 8 Google spreadsheets and one library; it implements logic to support a business operating in a remote location with a requirement to track the earnings and expenses of its collaborators. The spreadsheets’ and library’s logic rely solely on standard Google Sheets and Drive logic.

My goal is to set it up to minimize, if not eliminate, Google authorization requests issued to users for each script in the application.

I’ve read the Google OAuth for its workspaces and cloud projects documentation; it is too deep, and I could not form a coherent mental model of how it works and how to implement it for a simple application like mine. I’ve consulted a plethora of AI engines, each suggesting slightly different approaches, all leading to Google OAuth dead-ends, e.g., despite being the owner of the workspace and project and having the required credentials, I cannot create a secret key required to configure the application.

I hope that among us, there is someone who has a template to configure Google OAuth for a simple project like mine.