Smartsheets Source Connector

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:

1. Log into your Airbyte Cloud account.
2. In the left navigation bar, click Sources. In the top-right corner, click +new source.
3. On the Set up the source page, enter the name for the Smartsheets connector and select Smartsheets from the Source type dropdown.
4. Authenticate via OAuth2.0 using the API access token from Prerequisites
5. Enter the start date and the ID of the spreadsheet you want to sync
6. Submit the form

For Airbyte Open Source:

1. Navigate to the Airbyte Open Source dashboard
2. Set the name for your source
3. Enter the API access token from Prerequisites
4. Enter the ID of the spreadsheet you want to sync
5. Enter a start sync date
6. Click Set up source

Supported sync modes​

The Smartsheets source connector supports the following sync modes:

• Full Refresh | Overwrite
• Full Refresh | Append [Coming Soon]
• Incremental | Append [Coming Soon]
• Incremental | Deduped [Coming Soon]

Performance considerations​

At the time of writing, the Smartsheets API rate limit is 300 requests per minute per API access token.

Supported streams​

This source provides a single stream per spreadsheet with a dynamic schema, depending on your spreadsheet structure. For example, having a spreadsheet Customers, the connector would introduce a stream with the same name and properties typed according to Data type map (see below).

Important highlights​

The Smartsheet Source is written to pull data from a single Smartsheet spreadsheet. Unlike Google Sheets, Smartsheets only allows one sheet per Smartsheet - so a given Airbyte connector instance can sync only one sheet at a time. To replicate multiple spreadsheets, you can create multiple instances of the Smartsheet Source in Airbyte, reusing the API token for all your sheets that you need to sync.

Note: Column headers must contain only alphanumeric characters or _ , as specified in the Airbyte Protocol.

Data type map​

The data type mapping adopted by this connector is based on the Smartsheet documentation.

NOTE: For any column datatypes interpreted by Smartsheets beside DATE and DATETIME, this connector's source schema generation assumes a string type, in which case the format field is not required by Airbyte.

The remaining column datatypes supported by Smartsheets are more complex types (e.g. Predecessor, Dropdown List) and are not supported by this connector beyond its string representation.