Smartsheets
This page guides you through the process of setting up the Smartsheets source connector.
Prerequisites
To configure the Smartsheet Source for syncs, you'll need the following:
- A Smartsheets API access token - generated by a Smartsheets user with at least read access
- The ID of the spreadsheet you'd like to sync
Step 1: Set up Smartsheets
Obtain a Smartsheets API access token
You can generate an API key for your account from a session of your Smartsheet webapp by clicking:
- Account (top-right icon)
- Apps & Integrations
- API Access
- Generate new access token
For questions on advanced authorization flows, refer to this.
Prepare the spreadsheet ID of your Smartsheet
You'll also need the ID of the Spreadsheet you'd like to sync. Unlike Google Sheets, this ID is not found in the URL. You can find the required spreadsheet ID from your Smartsheet app session by going to:
- File
- Properties
Step 2: Set up the Smartsheets connector in Airbyte
For Airbyte Cloud:
- Log into your Airbyte Cloud account.
- In the left navigation bar, click Sources. In the top-right corner, click +new source.
- On the Set up the source page, enter the name for the Smartsheets connector and select Smartsheets from the Source type dropdown.
- Authenticate via OAuth2.0 using the API access token from Prerequisites
- Enter the start date and the ID of the spreadsheet you want to sync
- Submit the form
For Airbyte Open Source:
- Navigate to the Airbyte Open Source dashboard
- Set the name for your source
- Enter the API access token from Prerequisites
- Enter the ID of the spreadsheet you want to sync
- Enter a start sync date
- Click Set up source