Create Asana tasks from ClickHouse metric anomalies
Catch unusual numbers while there is still time to investigate. Notis checks your ClickHouse metrics and turns meaningful anomalies into clear Asana follow-ups.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create task in asana with specific details
Creates a new asana task; requires 'workspace', 'parent', or 'projects' for association, and 'followers', 'projects', 'tags' are set only at creation.
Why this helps
Important metric swings can hide in dashboards until someone remembers to check them and assign an investigation.
- Put surprising changes into the team's existing task flow.
- Include the query result and comparison context in the task.
- Reduce manual dashboard checks.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and Asana once in Notis.
- 2Create an automation in the portal or from any channel.
- 3In one instruction, name the metric, threshold, comparison window, and task details to include.
- 4Choose a recurring schedule and a channel for run reports.
- 5Test with one real metric example.
Questions about this workflow
How does Notis know what counts as an anomaly?
Tell it the metric, threshold, and comparison window in your instruction. Notis can only evaluate data returned by the query.
Does it create a task on every run?
Ask Notis to create a task only when the stated condition is met. Specify how to avoid duplicate open tasks if that matters.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to Asana. A trigger fires from one place; an action lands in another.
ClickHouse triggers
Asana actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Followers to Task
Tool to add followers to a task in asana. use this tool when you need to add one or more users as followers to a specific task. this will notify them of updates to the task.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add Supporting Relationship to Goal
Tool to add a supporting goal relationship to a goal. use when you want to link a project, task, portfolio, or another goal as a supporting resource to a specific goal in asana.
Add task to section
Adds an existing task to a section, optionally positioning it before or after another task in that section; if no position is specified, the task is added to the end.
Create Allocation
Creates a new allocation. use when you need to schedule or assign a specific amount of a user's time per week to a task or project within a defined period.
Create a project
Creates a new asana project, requiring either a `workspace` or `team` gid for association, and returns the full project details.
Create a tag in a workspace
Creates a new tag, with properties like name and color defined in the request body, within a specific asana workspace (using `workspace gid`); this tag helps categorize tasks, is confined to the workspace, and is not automatically applied to tasks.
Create task in asana with specific details
Creates a new asana task; requires 'workspace', 'parent', or 'projects' for association, and 'followers', 'projects', 'tags' are set only at creation.
Create Attachment for Task
Tool to upload an attachment to a task. use when you need to attach a file to a specific task in asana.
Connect any two apps with Notis in the middle.
ClickHouse and Asana, 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 Asana.