Keep user reporting context current after Zoom changes
Make profile changes easier to reconcile with warehouse records.
Trigger
User Information Changed
Triggers when a Zoom user's information changes. Detects changes such as: - Profile information updates (name, email, display name) - Role or type changes - Department, job title, or location updates - Contact information changes (phone, timezone) - Status changes (active, inactive, pending) - Settings updates (language, pronouns, etc.)
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
Changed roles, departments, or contact details can leave reports out of sync.
- Surface affected ownership records
- Spot reporting mismatches
- Reduce manual reconciliation work
Setup
Build it in a few focused steps.
- 1Connect Zoom and ClickHouse in Notis once.
- 2Create an automation named User change context query.
- 3Tell Notis to query ClickHouse for the changed user's ownership, activity, department, and reporting context.
- 4Pick the Zoom User Information Changed trigger and choose the report destination.
- 5Test with one real user information update.
Questions about this workflow
Does this update ClickHouse records?
No. It queries and reports on the context already stored there.
Which profile changes matter?
Name, email, role, department, job title, location, contact details, timezone, and status changes can matter.
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.