Close the week with fewer forgotten follow-ups
Use a short weekly scan to see what needs a clear next step before you sign off.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
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
Unfinished follow-ups can linger through the weekend because there was no time to gather them together.
- Create a predictable end-of-week review.
- Bring open loops into one compact view.
- Make Monday restarts easier by noting what is still waiting.
Setup
Build it in a few focused steps.
- 1Connect Linear and Google BigQuery to Notis once through the portal.
- 2Create an automation through the portal or by asking Notis conversationally.
- 3In one prompt, ask Notis to query BigQuery on Fridays for Linear follow-ups that need a next step.
- 4Select a weekly recurring trigger and choose your run-report channel.
- 5Test with one run and review whether the output is concise and actionable.
Questions about this workflow
Can it run on Friday afternoon?
Set the recurring trigger to the time that suits your end-of-week routine.
What should count as an open loop?
Describe the criteria in your prompt, using signals available in BigQuery.
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.