Datapipe
Read and report
Read accessible current issues in one team, including archived issues, with identifiers, titles, descriptions, workflow states and timestamps.
Read & reportOwner-approved writes
See your Linear numbers in BigQuery.
Read current team issues and approve supported title, description or workflow-state changes in the selected team.
BigQueryUpdated November 2026
What you can do with Linear
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 Linear.
Examples for your team
Illustrative workflows using the supported capabilities. Connect your own account to work with your data.
Share the current delivery picture
Refresh issues from the connected team for a delivery review. Keep the archive timestamp visible so archived work is distinguishable from current work.
Review a workflow-state change
Propose a supported existing workflow state for an unarchived issue in the approved team. The owner reviews the exact change before Linear receives it.
Supported Linear 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 issue fields
Updates owner-selected title, Markdown description and existing workflow state in the approved team. Description edits replace existing Markdown; new mention links are rejected. Linear automations and notifications may react. External edits can race execution. No assignment, team moves, comments, creation, archive 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 team issues
Current accessible issues in one Linear team, including archived issues, independent of report dates. IDs, title, Markdown description, workflow state and timestamps. Custom fields, comments and historical cycle, velocity or productivity metrics are excluded.
Current accessible issues in one Linear team, including archived issues, independent of report dates. IDs, title, Markdown description, workflow state and timestamps. Custom fields, comments and historical cycle, velocity or productivity metrics are excluded.
Metrics and dimensions
9 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 Linear 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.
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
| Issue ID | Issue key | Issue title | Markdown description | Workflow state ID | Workflow state | Created at | Updated at |
|---|---|---|---|---|---|---|---|
| 1,240 | 1,240 | Review delivery plan | Card payment | 1,240 | In progress | 1,240 | Oct 27 |
| 640 | 640 | 640 | Refund | 640 | 640 | 640 | Oct 28 |
| 210 | 210 | 210 | Invoice | 210 | 210 | 210 | Oct 29 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Current accessible issues in one Linear team, including archived issues, independent of report dates. IDs, title, Markdown description, workflow state and timestamps. Custom fields, comments and historical cycle, velocity or productivity metrics 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 9 report fields across 1 datasets. You pick the columns when you build the report.
Current accessible issues in one Linear team, including archived issues, independent of report dates. IDs, title, Markdown description, workflow state and timestamps. Custom fields, comments and historical cycle, velocity or productivity metrics 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