Advanced Analytica Advanced Analytica: IBOM
← All connectors
Smartsheets logo

Source connector

Smartsheets

Set up Smartsheets as a source and move its data into your chosen destination.

Version 1.1.46 community beta

Smartsheets

Set up the Smartsheets source connector by following this guide.

Prerequisites

To configure the Smartsheet Source for syncs, you’ll need:

  • A Smartsheets API access token generated by a Smartsheets user with at least read access
  • The ID of the spreadsheet you want to sync

Step 1: Set up Smartsheets

Get an API access token

Generate an API key from your Smartsheet webapp session by selecting:

  • Account (top-right icon)
  • Apps & Integrations
  • API Access
  • Generate new access token

For guidance on advanced authorisation flows, see this.

Find your spreadsheet ID

You’ll also need the ID of the Spreadsheet you want to sync. Unlike Google Sheets, this ID isn’t in the URL. Find the required spreadsheet ID in your Smartsheet app session by selecting:

  • File
  • Properties

Step 2: Set up the connector

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, name the Smartsheets connector. Then select Smartsheets from the Source type dropdown.
  4. Authenticate through 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. Go 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 these sync modes:

  • Full Refresh | Overwrite
  • Full Refresh | Append
  • Incremental | Append
  • Incremental | Deduped

Performance considerations

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

Supported streams

This source provides one stream for each spreadsheet. Its dynamic schema depends on your spreadsheet structure. For example, a spreadsheet named Customers creates a stream with the same name. Its properties follow the Data type map shown in below.

You can also include specific sheet or row metadata fields in the stream. Specify these fields in the configuration to include them.

Supported Metadata Fields
sheetcreatedAt
sheetid
sheetmodifiedAt
sheetname
sheetpermalink
sheetversion
sheetaccess_level
row_id
row_access_level
row_created_at
row_created_by
row_expanded
row_modified_by
row_parent_id
row_permalink
row_number
row_version

Key details

The Smartsheet Source pulls data from one Smartsheet spreadsheet. Unlike Google Sheets, Smartsheets allows only one sheet per Smartsheet. Each Airbyte connector instance can therefore sync only one sheet at a time. To replicate multiple spreadsheets, create multiple Smartsheet Source instances in Airbyte. You can reuse the API token across every sheet you need to sync.

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

Data type map

This connector’s data type mapping is based on the Smartsheet documentation.

NOTE: For column data types interpreted by Smartsheets, except DATE and DATETIME, the connector assumes a string type. In this case, Airbyte doesn’t require the format field.

Integration TypeAirbyte TypeAirbyte Format
TEXT_NUMBERstring
DATEstringformat: date
DATETIMEstringformat: date-time
anything elsestring

Smartsheets supports other, more complex column data types, such as Predecessor and Dropdown List. This connector supports only their string representation.

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review
VersionDatePull RequestSubject
1.1.462025-05-2560558Update dependencies
1.1.452025-05-1160205Update dependencies
1.1.442025-05-0459584Update dependencies
1.1.432025-04-2759014Update dependencies
1.1.422025-04-1958374Update dependencies
1.1.412025-04-1257999Update dependencies
1.1.402025-04-0557490Update dependencies
1.1.392025-03-2956830Update dependencies
1.1.382025-03-2255651Update dependencies
1.1.372025-03-0155076Update dependencies
1.1.362025-02-2254529Update dependencies
1.1.352025-02-1554107Update dependencies
1.1.342024-11-1446379Add support for Smartsheet Reports (full refresh only)
1.1.332025-02-0153108Update dependencies
1.1.322025-01-2552426Update dependencies
1.1.312025-01-1852017Update dependencies
1.1.302025-01-1151402Update dependencies
1.1.292024-12-2850747Update dependencies
1.1.282024-12-2150382Update dependencies
1.1.272024-12-1449441Update dependencies
1.1.262024-11-2548646Starting with this version, the Docker image is now rootless. Please note that this and future versions will not be compatible with Airbyte versions earlier than 0.64
1.1.252024-11-0448185Update dependencies
1.1.242024-10-2847024Update dependencies
1.1.232024-10-1246783Update dependencies
1.1.222024-10-0546427Update dependencies
1.1.212024-09-2846154Update dependencies
1.1.202024-09-2145722Update dependencies
1.1.192024-09-1445575Update dependencies
1.1.182024-09-0745214Update dependencies
1.1.172024-08-3145012Update dependencies
1.1.162024-08-2444738Update dependencies
1.1.152024-08-1744244Update dependencies
1.1.142024-08-1043686Update dependencies
1.1.132024-08-0343108Update dependencies
1.1.122024-07-2742632Update dependencies
1.1.112024-07-2042359Update dependencies
1.1.102024-07-1341825Update dependencies
1.1.92024-07-1041410Update dependencies
1.1.82024-07-0941092Update dependencies
1.1.72024-07-0640844Update dependencies
1.1.62024-06-2540285Update dependencies
1.1.52024-06-2240003Update dependencies
1.1.42024-06-0639166[autopull] Upgrade base image to v1.2.2
1.1.32024-05-2138505[autopull] base image + poetry + up_to_date
1.1.22024-01-081234prepare for airbyte-lib
1.1.12023-06-0627096Fix error when optional metadata fields are not set
1.1.02023-06-0222382Add support for ingesting metadata fields
1.0.22023-05-1226024Fix dependencies conflict
1.0.12023-04-2725562Update testing dependencies
1.0.02023-02-1923237Fix OAuth2.0 token refresh
0.1.142023-02-0722419OAuth2.0 support - enabled; add allowed hosts
0.1.132022-12-0220017OAuth2.0 support - disabled
0.1.122022-04-3012500Improve input configuration copy
0.1.112022-04-2712203Doc improvements
0.1.102022-04-1512077Implement incremental read and improve code test coverage
0.1.92022-04-1211911Bugfix: scrambled columns
0.1.82022-02-049792Added oauth support
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.