The number of queries, in a simplified form, is influenced by two factors - whether the spreadsheets has changed and whether the loading of third-party changes is enabled (setting the Spreadsheet change processing policy).
If downloading third-party changes is enabled, then every minute a request will be sent to the Drive API to compare spreadsheets versions.
When changing the spreadsheet itself, different types of queries are used, in general, up to 5 queries per spreadsheet per minute. Those. if 10 spreadsheets are actively changing, then there will be a maximum of about 60 requests per minute (Spreadsheets API + Drive API).
Authorization failed (Error 403: access_denied)
Detailed error text:The developer hasn’t given you access to this app. It’s currently being tested and it hasn’t been verified by Google. If you think you should have access, contact the developer
Solution: the application you have created for accessing the Google API is in test mode and the account from which you are trying to log in is not the creator of this application and is not in the list of test users. You can read how to publish an application or add a user to the list of test users in the same article. For more information, see Publishing a Project.