Keep your data review event current
When the numbers change before a review, refresh the event details so the latest context is easy to find at a glance.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Patch Event
Updates specified fields of an existing event in a google calendar using patch semantics (array fields like `attendees` are fully replaced if provided); ensure the `calendar id` and `event id` are valid and the user has write access to the calendar.
Why this helps
A calendar event can point to stale numbers, leaving you to reconstruct the latest context right before a review.
- Refresh a known review event with current query output
- Keep changed metrics and reporting windows attached to the appointment
- Reduce last-minute searches for the latest figures
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 how the webhook identifies the existing event and which returned results should update its details.
- 4Choose the webhook trigger and where run reports should go.
- 5Test with one real result and a known event that you can edit.
Questions about this workflow
Can it update an event without knowing which event to change?
No. Provide a reliable way in the webhook data or instruction to identify the Google Calendar event, such as its event id and calendar id.
Which update action is used?
Patch Event. It updates only the fields Notis is instructed to change. If attendees are supplied, the attendee list is replaced in full.
Will a ClickHouse query start this automatically?
ClickHouse exposes no trigger events here. The webhook must be called by a process that sends the relevant query result to Notis.
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.