Keep a clear record of every new Linear issue
Turn incoming issues into a searchable view of what is landing on your team.
Trigger
Issue Created Trigger
Triggered when a new issue is created.
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
New work can arrive faster than you can pause to sort it, making intake patterns easy to lose.
- Build a durable view of issue volume over time.
- Review incoming work without reopening every issue.
- Spot changes in demand before they become a backlog surprise.
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 ask Notis conversationally.
- 3In one plain-language prompt, ask Notis to query BigQuery and record a concise snapshot for each new Linear issue.
- 4Select the Linear Issue Created trigger and choose where run reports should arrive.
- 5Test with one real issue and confirm the query result is useful.
Questions about this workflow
Does this create a BigQuery table automatically?
The automation runs a BigQuery query. Specify in your prompt how the result should be used, and ensure the required dataset and table are available.
Can I narrow the issues it records?
Describe the intended scope in the plain-language automation prompt; there is no separate field-mapping screen.
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.