Turn growing webinar interest into a scheduled event
Use a spreadsheet interest count to spot when it is time to plan a webinar in ClickMeeting.
Trigger
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Action
Create Conference
Tool to create a new conference. use when you need to schedule or start a meeting/webinar after authentication.
Why this helps
Interest counts rise in a sheet, but the signal can be missed while other founder work takes priority.
- Notice when interest reaches a useful level
- Connect demand tracking to event planning
- Reduce the need to watch spreadsheet totals manually
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and ClickMeeting once in the Notis portal.
- 2Create an automation in Automations, New Automation.
- 3Tell Notis the interest threshold and the conference details to use when the monitored count reaches it.
- 4Choose Aggregate Metric Changed and configure the monitored aggregate in the trigger.
- 5Choose a report channel and test with one real count change.
Questions about this workflow
Does the trigger know my interest threshold?
No. State the threshold in the automation prompt so Notis can assess the changed aggregate result against it.
What does the trigger monitor?
It monitors a selected aggregate calculation such as SUM, COUNT, AVG, MIN, or MAX and fires when the result changes.
What information is needed to create the conference?
The prompt or available sheet data must provide the conference details needed by ClickMeeting.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Clickmeeting. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Clickmeeting actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Conference
Tool to create a new conference. use when you need to schedule or start a meeting/webinar after authentication.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Contact
Tool to create a new contact in your clickmeeting account. use when you need to add or pre-register an attendee before scheduling an event.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Delete Conference
Tool to delete a specific conference. use after confirming the conference is no longer needed.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Delete Recording
Tool to delete a specific recording for a conference room. use when you need to remove an unwanted or outdated recording after confirming the conference and recording ids. deletion is irreversible.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Delete Recordings
Tool to delete all recordings for a conference room. use when you need to clear all saved recordings for a specific conference before archiving or reusing it.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Generate Autologin URL
Tool to generate an autologin url for a conference participant. use when you need to provide direct access to a conference room without separate login.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Generate Session PDF Report
Tool to generate a pdf report for a specific session. use when you need to download session analytics as a pdf file.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Get Chat Details
Tool to retrieve details of a specific chat session. use when you have the chat id and need its metadata and messages.
Connect any two apps with Notis in the middle.
Google Sheets and Clickmeeting, 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 Clickmeeting.