Datapipe
Read and report
Read current rows in one selected US sheet, including row IDs, row positions and native cell values preserved as JSON. This is current inventory, independent of report dates.
Read & reportOwner-approved writes
See your Smartsheet numbers in BigQuery.
Read the selected sheet's rows, then review supported cell updates without handing teammates unrestricted write access.
BigQueryUpdated November 2026
What you can do with Smartsheet
Write with owner approval
Eligible teammates can propose the supported changes listed below. The owner reviews the exact values and approves every proposed change before it is applied to Smartsheet.
Examples for your team
Illustrative workflows using the supported capabilities. Connect your own account to work with your data.
Share a current sheet inventory
Refresh row IDs, positions and native cell JSON for the selected sheet. Keep complex cell values in their native form rather than treating every column as a metric.
Review a delivery status correction
The owner selects supported writable columns in the project sheet. A teammate proposes a text note, date, checkbox or existing choice; the owner reviews the exact row and values before the update.
Supported Smartsheet write actions
Writes start disabled. The owner enables permitted actions and eligible teammates. Only fields supported by an enabled action can be proposed; some actions also support individual owner-selected writable fields.
Update approved row cells
Updates supported literal text, date-only, checkbox and existing single-choice cells in one selected US Smartsheet sheet. The owner chooses writable columns. Locked, calculated, linked, system and project-dependency cells are excluded. Automations and notifications may react; external edits can race execution. No row moves, sharing, schema changes, creation or deletion.
The owner selects supported writable fields for this action before teammates can propose changes.
Every team member's change needs owner approval
- The owner sets access
Choose the connection, permitted actions and eligible teammates. Select individual writable fields where the action supports it.
- A teammate proposes a change
Choose an existing record and propose specific supported values. A proposal does not apply the change.
- The owner reviews the difference
Check the current and proposed values, then approve that individual change. Changed records or permissions require a fresh review.
- Datapipe records the result
View the result in the audit history. An uncertain write is not automatically retried.
Provider permissions and workflows still apply. Source automations or notifications may react to approved changes.
Connected assistants can read available reports. Source changes use the separate Actions & approvals workflow in Datapipe.
Start with a controlled connectionReports you can build
1 reporting datasets with their own fields. Choose a dataset in the app, then select the columns you need.
See included datasets and what they report
- Current sheet rows
Current accessible rows in one selected US Smartsheet sheet, independent of report dates. Row IDs, row positions and native cell values as JSON are retrievable. Cell JSON preserves provider types rather than inventing universal metrics. Historical activity and typed custom-column reporting are excluded.
Current accessible rows in one selected US Smartsheet sheet, independent of report dates. Row IDs, row positions and native cell values as JSON are retrievable. Cell JSON preserves provider types rather than inventing universal metrics. Historical activity and typed custom-column reporting are excluded.
Metrics and dimensions
3 report fields across 1 datasets.
Browse the documented fields below. In the app, choose your project connection to load its field list. Availability depends on API permissions, report type, and compatible field combinations. Property-specific custom fields appear after connecting.
No fields match. Try another search or choose All.
Send Smartsheet data anywhere
Google SheetsA sheet that refreshes every morning.
Looker StudioCharts that read the same numbers.BigQueryA warehouse table for the same columns.
Excel / CSVA Drive file you can open in Excel.
ClaudeAsk Claude about these numbers in a sentence.
ChatGPTAsk ChatGPT about these numbers in a sentence.
APIRead the same rows from your own tool.Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.Ask AI about your data
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
Use an assistant to understand the reports. Propose source changes separately in Datapipe, where the owner reviews and approves every change.
Start from a goal
How it works
- Create a project and choose this source in Connections.
- Pick where it goes. This one sends the numbers to BigQuery.
- Pick where it goes. Choose a report and destination, then configure optional writable fields and teammates separately.
Sample report
Sample
| Row ID | Row number | Native cells (JSON) |
|---|---|---|
| 12345 | 2 | [{"columnId":10,"value":"Review client brief"}] |
| 640 | 640 | 640 |
| 210 | 210 | 210 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Current accessible rows in one selected US Smartsheet sheet, independent of report dates. Row IDs, row positions and native cell values as JSON are retrievable. Cell JSON preserves provider types rather than inventing universal metrics. Historical activity and typed custom-column reporting are excluded.
Questions
Free to start. Paid plans add more connections and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 connections.
No. Name a project, add a connection, then choose a report and destination.
Datapipe reads the supported reports listed on this page and offers the write actions shown above. Writes start disabled. The owner enables permitted actions and eligible teammates; individual writable-field selection is available on supported actions. Every team member's proposed change needs a separate owner review and approval. Provider permissions still apply.
This page lists 3 report fields across 1 datasets. You pick the columns when you build the report.
Current accessible rows in one selected US Smartsheet sheet, independent of report dates. Row IDs, row positions and native cell values as JSON are retrievable. Cell JSON preserves provider types rather than inventing universal metrics. Historical activity and typed custom-column reporting are excluded. Account permissions and the records available from the provider determine which rows can be read.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
ActiveCampaign
Airtable
Asana
Attriboo
beehiiv