Datapipe
Read and report
Read current accessible contacts in one workspace and data region, including standard identifiers, names, email, roles and timestamps.
Read & reportOwner-approved writes
See your Intercom numbers in BigQuery.
Read current workspace contacts and approve supported name or custom-attribute corrections one change at a time.
BigQueryUpdated November 2026
What you can do with Intercom
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 Intercom.
Examples for your team
Illustrative workflows using the supported capabilities. Connect your own account to work with your data.
Prepare a current contact inventory
Refresh the accessible contact list before a customer-data review. Use standard roles and timestamps to understand the current records.
Correct an approved contact attribute
Propose a new name or supported existing custom attribute chosen by the owner. The owner reviews the exact value before it is applied and any source workflows react.
Supported Intercom 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 contact fields
Updates owner-selected contact name and existing API-writable custom text or boolean attributes in the approved workspace and region. Workflows and connected systems may react; outside edits can race execution. No email, phone, identifiers, consent, subscription status, messages, assignments, 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 workspace contacts
Current accessible contacts in one workspace and data region, independent of report dates. Standard ID, name, email, role and timestamps only. Existing custom attributes are discovered separately for supported owner-approved edits. Conversations, message content, historical support metrics and custom-attribute reporting are excluded.
Read current accessible contacts in one workspace and data region, with standard IDs, names, email, role and timestamps. Conversations, historical support metrics and custom-attribute reporting are excluded.
Metrics and dimensions
6 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 Intercom 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.
Better than exporting by hand
- You can keep a row per day instead of one lump sum.
- People and the way you reach them can be their own rows.
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
| Contact ID | Name | Role | Created at | Updated at | |
|---|---|---|---|---|---|
| 1,240 | Avery Chen | avery@example.test | user | 1,240 | Oct 27 |
| 640 | Jordan Blake | jordan@harbor.example | 640 | 640 | Oct 28 |
| 210 | Sam Okonkwo | sam@acme.example | 210 | 210 | Oct 29 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Read current accessible contacts in one workspace and data region, with standard IDs, names, email, role and timestamps. Conversations, historical support metrics and custom-attribute 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 6 report fields across 1 datasets. You pick the columns when you build the report.
Read current accessible contacts in one workspace and data region, with standard IDs, names, email, role and timestamps. Conversations, historical support metrics and custom-attribute 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