Turn every Zoom participant event into attendance insight
See the pattern behind attendance without opening several reports.
Trigger
New Meeting Participant
Triggers when a new participant appears in a past meeting's participant report.
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
Participant history is hard to review when it is scattered across past meetings.
- Spot repeat attendance patterns
- Support relationship follow-up
- Reduce manual participant research
Setup
Build it in a few focused steps.
- 1Connect Zoom and ClickHouse in Notis once.
- 2Create an automation named Participant attendance query.
- 3Tell Notis to query ClickHouse for the participant's attendance history, meeting frequency, and recent context.
- 4Pick the Zoom New Meeting Participant trigger and choose where run reports go.
- 5Test with one real participant event.
Questions about this workflow
Does this identify a person automatically?
It uses the participant information available in the Zoom event and ClickHouse records.
Can it measure attendance trends?
Yes, when historical participant records are stored in ClickHouse.
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.