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.
Once you have, add the connection using your token. In alteryx go to Input Data/Other Databases/ODBC. Select the data source you created using the smartsheet connector. Enter your email as the username & the API token as your password.
This works fine for me on my computer, but I haven't been able to figure out getting the same to work in the Gallery.
Also, the default syntax in Alteryx errors out for smart sheets specifically. You need to go to the SQL tab & update the syntax to remove your email address & the period in the FROM part of the statement: