Bring useful data into project updates
Give a posted project update a companion view of the measures that matter.
Trigger
Project Update Posted
Fires when a project status update is posted on the Linear project's Updates tab. Covers projects in both public and private teams — polls with the connected user's token.
Action
Query
Query tool will run a sql query in bigquery. note: make sure the query being input in a single line format. for example, select * from sample dataset.sample table where column name = 'value'
Why this helps
Writing an update and locating its supporting numbers can become two separate tasks.
- Review update notes alongside relevant measures.
- Reduce the separate effort of finding supporting numbers.
- Make recurring project updates easier to compare.
Setup
Build it in a few focused steps.
- 1Connect Linear and Google BigQuery to Notis once through the portal.
- 2Create an automation in the portal or describe it to Notis conversationally.
- 3Use one prompt asking Notis to query BigQuery for a data snapshot relevant to each posted project update.
- 4Choose the Linear Project Update Posted trigger and a channel for reports.
- 5Test with one real project update and review the query output.
Questions about this workflow
Does the query edit the Linear update?
The available action runs a BigQuery query. Use the prompt to describe the result you want Notis to produce.
What measures should I request?
Pick measures already represented in BigQuery that help explain project progress, and name them in your prompt.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Linear to Google BigQuery. A trigger fires from one place; an action lands in another.
Linear triggers
Google BigQuery actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Query
Query tool will run a sql query in bigquery. note: make sure the query being input in a single line format. for example, select * from sample dataset.sample table where column name = 'value'
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Comment Received Trigger
Triggered when a comment is received.
Issue Created Trigger
Triggered when a new issue is created.
Issue Updated Trigger
Triggered when an issue is updated. For example labels are changed, issue status is changed, etc.
Private Team Comment Created
Fires when a new comment is posted on an issue in a private Linear team (polled with the connected user's token).
Private Team Issue Created
Fires when a new issue appears in a private Linear team (polled with the connected user's token).
Private Team Issue Properties Updated
Fires when properties on an issue change in a private Linear team (polled with the connected user's token).
Connect any two apps with Notis in the middle.
Linear and Google BigQuery, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Google BigQuery.