Keep user profile analysis aligned with the data schema
Verify the fields you rely on after every important Zoom user change.
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
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.
Why this helps
Profile updates can expose missing or renamed fields in operational reporting tables.
- Catch field mismatches early
- Protect ownership reporting
- Reduce debugging after profile changes
Setup
Build it in a few focused steps.
- 1Connect Zoom and ClickHouse in Notis once.
- 2Create an automation named User schema consistency check.
- 3Tell Notis to retrieve the ClickHouse table schema for user and ownership data and flag fields needed for reporting.
- 4Pick the Zoom User Information Changed trigger and choose where run reports go.
- 5Test with one real user profile change.
Questions about this workflow
Can it repair missing fields?
No. It identifies the current schema and reports potential gaps.
Which fields can it review?
It can review fields available in the relevant ClickHouse table, such as role, department, contact, and status.
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.