Keep new Zoom recordings organized from day one
Turn each new recording into a quick retention and storage review.
Trigger
New Cloud Recording
Triggers when a new cloud recording meeting instance appears for a user.
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
New recordings accumulate without a consistent way to spot stale or oversized files.
- Identify oversized recordings
- Surface aging content patterns
- Support consistent retention reviews
Setup
Build it in a few focused steps.
- 1Connect Zoom and ClickHouse in Notis once.
- 2Create an automation named New recording retention review.
- 3Tell Notis to query ClickHouse for the new recording's size, age, access history, and retention indicators.
- 4Pick the Zoom New Cloud Recording trigger and choose where run reports go.
- 5Test with one real new recording.
Questions about this workflow
Can this delete recordings?
No. This workflow only queries and reports on retention signals.
What data is needed for access history?
ClickHouse must contain access or viewing records for that analysis.
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.