Make room to review capacity trends
When capacity needs attention, find open time for a focused review without manually checking calendars first.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Find free slots
Finds free/busy time slots in google calendars for specified calendars within a defined time range (defaults to the current day utc if `time min`/`time max` are omitted), enhancing busy intervals with event details; `time min` must precede `time max` if both are provided.
Why this helps
Capacity questions often linger because finding a shared opening takes another round of calendar checking.
- Pair a supplied capacity result with a concrete scheduling next step
- Search calendar free slots across a defined time range
- Reduce the back-and-forth needed to find review time
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, describe the capacity signal to review, the calendars to check, and the time range for possible slots.
- 4Pick a recurring schedule and choose where run reports should go.
- 5Test with one real capacity result and a defined availability window.
Questions about this workflow
Does this create the review event?
No. Find free slots returns availability. Notis can report a suitable slot, but creating an event requires a separate instruction and action.
What does the availability search need?
Specify the calendars and time range. If the time range is omitted, the action defaults to the current day in UTC.
Can it decide whether capacity needs a review?
Only according to criteria you supply, such as a utilization threshold. The automation should not invent a threshold or expected baseline.
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.