- Source
- Files
- Beta
Move Smartsheets data anywhere it matters.
Send Smartsheets data to any warehouse, lake or AI app.
Source
Smartsheets
Snowflake
BigQuery
Postgres
Databricks
Claude
- Destinations
- 50+
- Standard support
- 1.1.46
Overview
What is the Airbyte Smartsheets connector?
The Airbyte Smartsheets connector extracts data from Smartsheets and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes tables and events you can select per connection.
- 01
Sync to your warehouse
Land Smartsheets data in 50+ destinations on a schedule you control.
- 02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
- 03
One authorization
Authenticate Smartsheets once and Airbyte keeps every scheduled sync running on it.
- 04
Cloud or self-hosted
Run the Smartsheets connector on Cloud, OSS, Hybrid.
Setup
Live in eleven steps
Open the Smartsheets source connector page on Airbyte.com.
Click on the "Add Source" button.
Enter a name for your Smartsheets source connector.
Enter your Smartsheets API access token in the "API Access Token" field.
Enter your Smartsheets account ID in the "Account ID" field.
Click on the "Test" button to ensure that the credentials are correct.
If the test is successful, click on the "Save & Continue" button.
Select the tables that you want to replicate from Smartsheets.
Choose the replication frequency and the destination where you want to store the data.
Click on the "Create Connection" button to start the replication process.
Once you have completed these steps, Airbyte will start replicating the data from your Smartsheets account to the destination that you have chosen. You can monitor the replication process and view the data in the destination by logging into your Airbyte account.
Configuration fields
| Field | Type | Description |
|---|---|---|
| credentials* | object | Not documented. |
| spreadsheet_id* | string | The spreadsheet ID. Find it by opening the spreadsheet then navigating to File > Properties |
| is_report | boolean | If true, the source will treat the provided sheet_id as a report. If false, the source will treat the provided sheet_id as a sheet. |
| metadata_fields | array | A List of available columns which metadata can be pulled from. |
| start_datetime | string | Only rows modified after this date/time will be replicated. This should be an ISO 8601 string, for instance: 2000-01-01T13:00:00 |
Hybrid deployment
Sovereign by architecture, not by policy.
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
- Cloud
- OSS
- Hybrid
Your environment
Airbyte control plane
FAQ
Smartsheets connector questions
What data can I sync from Smartsheets with Airbyte?
The Smartsheets connector syncs the tables and events published in Airbyte docs.
Does the Smartsheets connector support incremental sync?
Yes. The Smartsheets connector supports incremental sync on selected streams, and full refresh on every stream.
Where can I run the Smartsheets connector?
Run the Smartsheets connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.
Didn't find your answer? Talk to sales
Start syncing Smartsheets in minutes.
Free 14-day trial. No credit card needed.