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.
on 05-05-202012:09 AM - edited on 05-21-202006:42 AM by kcsrestapiuser
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.
Alteryx product - Designer
Version 2018.3 and up (Google connector authentication updated in Designer Version 2020.2 and later)
To obtain a Connection Token, you first need to authenticate the tool (either with End user credentials by clicking "Connect", or by clicking Optional OAuth Overrides checkbox and entering your Google Client ID and Client Secret)
Once successfully authenticated, you can find the tool's Connection Token in any screen of the Google Sheets or Google Analytics Input and Output tools
To use the Connection Token at login, either by itself, or in combination with any of the existing authentication options above, simply paste (Ctrl + v) the token in the Connection Token field. If the Connection Token was created with OAuth2 Overrides, then also enter credentials
Note a Connection Token allows you to access data under your Google account, and holds the permissions you have granted the specific tool from which you have copied the token. Therefore, a token copied from an Input tool will only have read rights and it won't work with an Output tool
To use the token in a working workflow, you can input the Connection Token in any screen of the Google Sheets or Google Analytics tools. Paste the token in the Connection Token field and select Apply(please make sure there are no white spaces before or after)
If you have inserted an invalid token, you can click on the canvas and back to the tool, and the old token will be displayed again.
Common Issues and Troubleshooting Tips
The Connection Token IS NOT the Access Token or the Refresh Token
Connection Tokens can not be shared across accounts. If a Connection Token from a different user is inserted, it will be valid initially but the tool will fail at runtime
A Connection Token obtained from an Input tool should not be applied to an Output tool due to it having only Read rights. This will lead to a runtime error. A Connection Token from an Output tool can be used for both types of tools
The Connection Token can be used by itself, but if the account for which this token belongs to has no right to access the selected data, the workflow will fail at runtime
The Apply button must be used after pasting the Connection Token inside the tools. Otherwise, the inserted token will be lost when clicking away from the tool
Please note Connection Tokens are shareable between Google Sheets and Google Analytics tools