Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
How to Create Google API Credentials
View full article
Latest versions of the Google Sheets and Google Analytics Connectors introduce ability to share a Connection Token across tools helping to stay under refresh token limit
View full article
This article will walk through how to enable to Google Analytics APIs to be used in the Google Analytics Connector with OAuth2 login option
View full article
Connecting to Google Analytics is becoming more and more popular. There are a few things you need in order to use the Google Analytics macro; a Google Account (e.g., Gmail) and authorized access to an existing Google Analytics account. This article will help you get the rest of the way.
View full article
Want to learn how to connect to Google Sheets?  Start here!
View full article
Looking for more premium connector and tool content to better equip your Alteryx platform for success? Check out what our partners have been up to!
View full article
If you observe an error message like Error: Salesforce Input (1) File " ", line 1 os.environ['PATH'] = r"... please read on to learn how to adjust the environment variables to resolve it. This can happen with any one of several Connector tools, not just the tool mentioned in the example.
View full article
This KB explains how to query views with the Google BigQuery Input Tool
View full article
Use the Google BigQuery Input tool to query a table from Google BigQuery and read it into Designer...
View full article
Error when publishing or running on Gallery a workflow that contains a Google Sheets tool.
View full article
ERROR: "Could not build wheels for cryptography which use PEP 517 and cannot be installed directly" while installing OneDrive tools in Alteryx Designer
View full article
Leading Zeroes Removed When Writing String Data to Google Sheets   When writing string data to Google Sheets that contain leading zeros, the leading zeros are removed after being written to Google:     Environment   Product - Alteryx Designer All Versions Product - Google Sheets Diagnosis   Google automatically formats values when they are written to a cell. The same behavior occurs when manually entering data into the sheet directly. When looking at the web traffic, one can see that the following is sent to Google from Alteryx:   <batch:operation type="update"/> <id>https://spreadsheets.google.com/feeds/cells/1YW6I6543216gsgsgsgsgD24j-hHA6ydcA/od6/private/full/R4C1</id> <gs:cell row="4" col="1" inputValue="00004"/>   The correct value "00004" appears as the InputValue. Google then returns the following:   gs:cell [ row=3 col=2 inputValue=4 numericValue=4.0 ]   Google has interpreted "00004" as a number and automatically converted it to "4."   Solution   You can workaround this by placing an apostrophe in front of the value within Alteryx prior to writing the data:     This forces Google to interpret the data as a string and include the leading zeroes. The following is a sample formula that adjusts all rows within a field to include a leading apostrophe:   "'" + [Field1]   Additional Resources   Google Sheets Output Help Documentation
View full article