Put ClickHouse anomalies on your calendar
A surprising metric should lead to a clear next step. Send query results to Notis and put an investigation block on your calendar.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Create Event
Creates an event on a google calendar, needing rfc3339 utc start/end times (end after start) and write access to the calendar. by default, adds the organizer as an attendee unless exclude organizer is set to true.
Why this helps
Metric alerts can get buried while you switch between dashboards, messages, and your calendar.
- Turn a returned metric and threshold into a review block
- Include the query time window and relevant result details
- Keep investigation follow-up visible on your calendar
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and Google Calendar once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis to create it from any channel.
- 3In one instruction, say to review webhook query results and create a calendar event when a specified metric crosses your threshold.
- 4Choose the webhook trigger and where run reports should go.
- 5Test with one real ClickHouse result and confirm the event details.
Questions about this workflow
Does ClickHouse start this automation by itself?
No. ClickHouse has no trigger events in this workflow package. A Notis webhook starts the automation, and you can send it query results from a system that runs your ClickHouse query.
Can the automation decide what counts as an anomaly?
Tell Notis the metric and threshold in its instruction, or include them with the webhook request. The workflow should not assume a threshold or baseline that was not supplied.
Which calendar event action does it use?
It uses Create Event. Google Calendar requires valid RFC3339 UTC start and end times, with the end after the start.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to Google Calendar. A trigger fires from one place; an action lands in another.
ClickHouse triggers
Google Calendar actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Insert Calendar into List
Inserts an existing calendar into the user's calendar list.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Update Calendar List Entry
Updates an existing entry on the user\'s calendar list.
Delete Calendar
Deletes a secondary calendar. use calendars.clear for clearing all events on primary calendars.
Update Calendar
Updates metadata for a calendar.
Clear Calendar
Clears a primary calendar. this operation deletes all events associated with the primary calendar of an account.
Create Event
Creates an event on a google calendar, needing rfc3339 utc start/end times (end after start) and write access to the calendar. by default, adds the organizer as an attendee unless exclude organizer is set to true.
Delete event
Deletes a specified event by `event id` from a google calendar (`calendar id`); this action is idempotent and raises a 404 error if the event is not found.
Create a calendar
Creates a new, empty google calendar with the specified title (summary).
Connect any two apps with Notis in the middle.
ClickHouse and Google Calendar, 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 Calendar.