Alteryx Designer

Definitive answers from Designer experts.

How to retrieve the Client_ID and Secret_code from the Google account, to be used with the Alteryx Google Sheets connectors

Moderator
Moderator
Created
How to retrieve the Client_ID and Secret_code from the Google account, to be used with the Alteryx GoogleSheets connectors.

To download the Google Sheets Tool:Click here

Google sheets tool has 2 options of login:
1)    Using email and password:


idea Skyscrapers
 
•    By clicking this button, it redirects user to a pop-up window
•    Enter email and password and list of Spreadsheet should be shown;

2)    By clicking Checkbox “Optional OAuth2 Overrides” appears 2 fields:
a.    Client ID
b.    Client Secret


Getting Client ID and Client Secret:

Go to https://console.developers.google.com/


Select corresponding project and click tab “Credentials”.  

idea Skyscrapers

Click “Create Credentials”:
 
idea Skyscrapers

Select Options OAuth client ID:

idea Skyscrapers


Select “Others” and name application:
idea Skyscrapers

In the pop-up window you will be given Client ID and Client Secret which you can use in the tool.
 
idea Skyscrapers

Be careful with selection application type:
Web applications’ Client ID and Secret won’t work for Google Sheets Tool.
idea Skyscrapers

The following error will be thrown if Web application type will be used:
 
idea Skyscrapers

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:

idea Skyscrapers

Allow in the pop-up window all requested accesses.  

idea Skyscrapers

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.

https://support.google.com/cloud/answer/7454865
 
How to check verification status and modify your application:
idea Skyscrapers

 

1.    Click “OAuth consent screen”;
2.    Click “Edit app”;
 
idea Skyscrapers