05-05-2020 12:09 AM - edited 08-03-2021 09:24 AM
How to use the "Connection Token" for the Google Sheets and Google Analytics Connectors
Google allows users up to 50 refresh tokens per account, so if you are a heavy user of Google Sheets or Google Analytics, you can easily reach this threshold. A clear sign of having reached the limit is that the tools start asking for re-authentication.
Starting with the Version 2.2 of the Google Sheets Connector and Version 8.0.0 of the Google Analytics Connector, you are able to share the same Connection Token across tools, helping you stay under the refresh token limit.
Prerequisites
Procedure
Common Issues and Troubleshooting Tips
There no longer is an Other option when created new credentials (see below). I tried selecting Desktop app and after attempting to connect, I was asked to Sign into Google, which failed because my "browser" was not authorized. Signing in with username and password yields the same results.
All documentation about getting Alteryx authorized no longer aligns with the options Google is offering. Please help. I have a lot of processes depending on getting this corrected.
Hi everybody and thanks Sabrina and Diana for this great post. Unfortunately, I'm having trouble at Step One too. After entering my Client ID and secret key in the Google Analytics connector, I click the Connect button and I can't sign in (please see error pasted below). I'm using the latest Google Analytics tool (v8) and I chose "Desktop app" from the Application Type drop-down (in the absence of the "other" option). I have also tried "Web application" as I'm sure this worked for me last year with the old GA tool, but that didn't work either.
It would be useful to know if anyone IS successfully using this version of the GA tool, or are we all having these issues? Thank you in advance for your kind help. Completely stuck.
The following is the short-term workaround to get my old Client ID and Secret from the pre-2.2 Google Input Tool to work again since they will no longer work in the version 2.2 of the Google Input Tool:
When rehosting the Alteryx server to a new server, I found a flow using an older version the Google Input tool was now failing on the new server. I tried installing the latest Google Input tool = version 2.2 with the Client ID and Secret from the old version. But ran into the similar issues as the previous 2 posts have mentioned when I tried to create new credentials for the v2.2 Google Input Tool. In short there is no longer an application type = Other available to select when creating credentials. The Google API documentation is like very dense forest and I needed a quick short-term work around to get this flow working again.
From The 'How to Guide' to Google Sheets link provided above in the right hand site navigation link panel, I learned that the Google Tools are packaged as .yxi files - the Server documentation refers to this on page 57 The .yxi package design issues are noted also at the end of the How to Guide to Google Sheets. This means that Alteryx looks to find the Google Input Tool in at least one of 3 specific locations copied below from p. 57. So, I copied the Tool folder from C:\ProgramData\Alteryx\Tools on the old server to the new server and the flow began working again.
1.) C:\Users\<username>\AppData\Roaming\Alteryx\Tools
2.) C:\ProgramData\Alteryx\Tools
3.) Alteryx install folders
Have you got any solution for the same. I am in the same boat actually and I have not got any head and tail of Google Connector till now.
Please help if you have achieved it at your end!
Regards
Hello, @arpit_tyagi
I don't remember how I resolved the issue. I believe I had to return to an earlier version of the google connector. Sorry I couldn't be more helpful.
MLD