Route ClickHouse signals to GitHub issue owners
When your analytics pipeline sends a flagged result, let Notis assign the related GitHub issue using the ownership rule you provide.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Add assignees to an issue
Adds or removes assignees for a github issue; changes are silently ignored if the authenticated user lacks push access to the repository.
Why this helps
A useful analytics finding can sit untouched when nobody has a clear next step or owner.
- Turn a flagged analytics result into an assigned GitHub issue.
- Keep ownership decisions close to the data that triggered them.
- Reduce the handoff work between analytics and issue tracking.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and GitHub in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3In one instruction, describe the webhook payload, the ownership rule, and the GitHub repository, issue number, and assignee information it provides.
- 4Pick the webhook trigger and choose where run reports go.
- 5Test with one real webhook example for an issue and an assignable GitHub user.
Questions about this workflow
Does ClickHouse provide webhook triggers for this workflow?
No. ClickHouse has no trigger events in this package. A Notis webhook starts the automation when your pipeline sends an HTTP request.
What should the webhook payload include?
Include the GitHub repository and issue number, plus the information needed to apply your ownership rule and identify the assignee.
What happens if the user cannot be assigned?
GitHub may ignore assignment changes when the authenticated user lacks push access, or reject an invalid assignee. Check the run report and access before relying on the automation.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to GitHub. A trigger fires from one place; an action lands in another.
ClickHouse triggers
GitHub actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Accept a repository invitation
Accepts a pending repository invitation that has been issued to the authenticated user.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
List repositories starred by the authenticated user
Deprecated: lists repositories starred by the authenticated user, including star creation timestamps; use 'list repositories starred by the authenticated user' instead.
List stargazers
Deprecated: lists users who have starred a repository; use `list stargazers` instead.
Star a repository for the authenticated user
Deprecated: stars a repository for the authenticated user; use `star a repository for the authenticated user` instead.
Add email for auth user
Adds one or more email addresses (which will be initially unverified) to the authenticated user's github account; use this to associate new emails, noting an email verified for another account will error, while an existing email for the current user is accepted.
Add app access restrictions
Replaces github app access restrictions for an existing protected branch; requires a json array of app slugs in the request body, where apps must be installed and have 'contents' write permissions.
Add a repository collaborator
Adds a github user as a repository collaborator, or updates their permission if already a collaborator; `permission` applies to organization-owned repositories (personal ones default to 'push' and ignore this field), and an invitation may be created or permissions updated directly.
Add a repository to an app installation
Adds a repository to a github app installation, granting the app access; requires authenticated user to have admin rights for the repository and access to the installation.
Connect any two apps with Notis in the middle.
ClickHouse and GitHub, 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 GitHub.