As per the documentation of *Sheets API v4*

*This version of the Google Sheets API has a limit of 500 requests per 100 
seconds per project, and 100 requests per 100 seconds per user. *

Reference: https://developers.google.com/sheets/api/limits

I am planning to work on a web application that uses Google Sheets API v4 
as a place to store user data. The reason is that the user is 100% owner of 
the data instead of me/application. 

I want the user to click on *Sign In with Google* button on the application 
page, and give the application access to use Sheets on their (user's) 
behalf.

I want to be in a situation, where API usage falls under *100 requests per 
100 seconds per user*.  What do I need to do to make sure that my 
application uses usage quota per user and *not* by the application?

I searched for references to the term "API requests on the user's behalf", 
assuming if user signs in to the app using their credentials, the app will 
get an access token that can be used with Sheets API. My understanding is 
that in this case, the interaction with Sheets API is counted for the 
individual user (since they gave the permission to access Drive, Sheets 
scope) and not the project (which is the web application). However, that's 
my understanding, but I need to make sure that it really is the case. The 
references that made me believe the way I said are below

<https://developers.google.com/identity/protocols/oauth2/javascript-implicit-flow#callinganapi>
https://developers.google.com/identity/protocols/oauth2/javascript-implicit-flow#callinganapi

<https://cloud.google.com/docs/authentication#strategies>
https://cloud.google.com/docs/authentication#strategies

<https://cloud.google.com/docs/authentication/end-user>
https://cloud.google.com/docs/authentication/end-user

<https://developers.google.com/sheets/api/guides/authorizing>
https://developers.google.com/sheets/api/guides/authorizing
Could someone please help me understand the API usage limits for project vs 
user?

Thank you very much

-- 
You received this message because you are subscribed to the Google Groups 
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-spreadsheets-api/5ab7a7a1-76a4-4f2f-8068-f784c0ffd58en%40googlegroups.com.

Reply via email to