Turn Zoom usage changes into ClickHouse cost insights
Keep a live view of Zoom consumption without exporting reports by hand.
Trigger
Daily Usage Report Changed
Triggers when the Zoom daily usage report changes for a selected year/month. This trigger monitors daily usage statistics including: - New users added - Number of meetings held - Participant counts - Meeting minutes consumed
Action
Execute ClickHouse Query
Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases.
Why this helps
Usage data is spread across reports, making cost review easy to postpone.
- See usage totals after each report change
- Spot unusual consumption quickly
- Keep cost analysis in one queryable warehouse
Setup
Build it in a few focused steps.
- 1Connect Zoom and ClickHouse in Notis once.
- 2Create an automation named Zoom usage cost review.
- 3Tell Notis to query ClickHouse for monthly minutes, participants, and estimated costs using the changed Zoom usage period.
- 4Pick the Zoom Daily Usage Report Changed trigger and choose where run reports go.
- 5Test with one real usage report change.
Questions about this workflow
Does this calculate actual Zoom billing?
It can estimate costs only when your ClickHouse data includes the pricing assumptions or rates you provide.
What starts the workflow?
A change to the selected Zoom daily usage report starts it.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Zoom to ClickHouse. A trigger fires from one place; an action lands in another.
Zoom triggers
ClickHouse actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute ClickHouse Query
Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. essential for ai agents to understand the complete database structure in a single call.
Daily Usage Report Changed
Triggers when the Zoom daily usage report changes for a selected year/month. This trigger monitors daily usage statistics including: - New users added - Number of meetings held - Participant counts - Meeting minutes consumed
Get Table Schema
Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. this is essential for ai agents to understand table structure before constructing queries.
Meeting Details Changed
Triggers when a specific meeting's details change. Detects changes such as: - Meeting topic changes - Agenda updates - Schedule changes (timezone, duration) - Settings modifications (waiting room, recording, video, etc.) - Password changes - Recurrence pattern updates
List ClickHouse Databases
List all databases in the clickhouse instance. useful for discovering available databases before querying tables.
Meeting Recording Changed
Triggers when a specific meeting's cloud recordings change. Detects changes such as: - New recording files appearing - Recording processing completion (status changes) - Recording metadata changes (count, size, etc.) - New participant audio files
List ClickHouse Tables
List tables in clickhouse databases. returns information about tables including their engine, size, and row count.
Meeting Summary Created or Updated
Triggers when a meeting summary is created or updated for a specific meeting. IMPORTANT: This trigger requires a PAID Zoom account (Pro, Business, or Enterprise plan). Free Zoom accounts cannot use this feature. Additionally requires: - AI Companion feature enabled in account settings - Meeting must not be end-to-end encrypted (E2EE) - Meeting summary must be enabled and generated for the meeting
New Cloud Recording
Triggers when a new cloud recording meeting instance appears for a user.
New Meeting Created
Triggers when a new Zoom meeting is created for a user.
Connect any two apps with Notis in the middle.
Zoom and ClickHouse, 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 ClickHouse.