This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Select corresponding project and click tab “Credentials”.
Click “Create Credentials”:
Select Options OAuth client ID:
Select “Others” and name application:
In the pop-up window you will be given Client ID and Client Secret which you can use in the tool.
Be careful with selection application type: Web applications’ Client ID and Secret won’t work for Google Sheets Tool.
The following error will be thrown if Web application type will be used:
After Entering Client ID and Secret, user should enter email and password.
If Application API isn’t verified by Google yet, proceed with using this link:
Allow in the pop-up window all requested accesses.
Good to know: OAuth rate limits Your user app The user cap limits the number of users that can grant permission to your app when requesting unapproved sensitive or restricted scopes. The user cap applies over the entire lifetime of the project, and it cannot be reset or changed. Verified apps will still display the user cap on this page, but the user cap does not apply if you are requesting only approved sensitive or restricted scopes. If your users are seeing the "unverified app " screen , it is because your OAuth request includes additional scopes that haven't been approved.