Keep Linear issues current with ClickHouse data
Give active work a useful data update without rebuilding the same context by hand.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create a comment
Creates a new comment on a specified linear issue.
Why this helps
Teams lose time reopening analytics tools to check whether the latest data changes an active issue.
- Add fresh query context to an existing issue on a recurring schedule.
- Keep comments concise and tied to the issue's decision or progress.
- Reduce repeated manual checks across tools.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and Linear once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis the desired outcome in plain language.
- 3In one instruction, ask Notis to review the specified ClickHouse result and comment on the related existing issue only when the result changes its status context or next decision.
- 4Pick a recurring schedule as the trigger and choose where run reports should go.
- 5Test with one real query result and issue, then review the comment for relevance.
Questions about this workflow
Does this workflow track a historical baseline automatically?
It can use history returned by the query. If the query does not provide a baseline or prior values, include them in the input or adjust the query; Notis cannot infer missing data.
Can it comment on every issue in Linear?
Keep the instruction scoped to the specified issue or a clearly defined set provided in the request. This workflow is for relevant data updates, not broad issue copying.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to Linear. A trigger fires from one place; an action lands in another.
ClickHouse triggers
Linear actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create linear attachment
Creates a new attachment and associates it with a specific, existing linear issue.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create a comment
Creates a new comment on a specified linear issue.
Create linear issue
Creates a new issue in a specified linear project and team, requiring a title and description, and allowing for optional properties like assignee, state, priority, cycle, and due date.
Get create issue default params
Fetches a linear team's default issue estimate and state, useful for pre-filling new issue forms.
Create a label
Creates a new label in linear for a specified team, used to categorize and organize issues.
Delete issue
Archives an existing linear issue by its id, which is linear's standard way of deleting issues; the operation is idempotent.
Get all teams
Retrieves all teams from the linear workspace without requiring any parameters.
Download issue attachments
Downloads a specific attachment from a linear issue; the `file name` must include the correct file extension.
Connect any two apps with Notis in the middle.
ClickHouse and Linear, 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 Linear.