Smartsheet Setup Guide Private Preview
Follow our setup guide to connect Smartsheet to Fivetran.
Prerequisites
To connect Smartsheet to Fivetran, you need an active Smartsheet account with access to the sheets you want to sync.
Setup instructions
Create Smartsheet API token
Log in to your Smartsheet account.
On the home screen, click your profile icon and select Apps & Integrations.
In the popup window, select the API Access tab.
Click Generate new access token.
In the dialog that appears, enter a name for your token (we suggest
Fivetran).Click OK.
Make a note of your API token. You will need it to configure Fivetran.
Finish Fivetran configuration
In the connection setup form, enter the Destination schema name of your choice.
Enter the API Token you found in Step 1.
Click Save & Test. Fivetran will take it from here and sync your Smartsheet data.