Use registration changes to prompt webinar invitations
Let your registration tracking help keep the next webinar invitation step on schedule.
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
Send Invitation
Tool to send invitation emails to a clickmeeting conference. use after scheduling a conference to invite participants by email.
Why this helps
Registration activity changes in a spreadsheet, but the corresponding invitation follow-up is easy to overlook.
- Tie invitation follow-up to registration activity
- Reduce the need to watch totals manually
- Use a clear prompt to define when invitations should go out
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 what change in the registration count should prompt invitations and identify the conference.
- 4Choose Aggregate Metric Changed and configure the relevant aggregate metric.
- 5Choose a report channel and test with one real count change.
Questions about this workflow
Does a count change always send invitations?
State the condition in your prompt so Notis can determine whether the changed aggregate should start invitation sending.
What does this trigger provide?
It detects a change in an aggregate calculation such as COUNT or SUM for the monitored spreadsheet data.
What must be identified for the action?
The automation needs enough information to identify the ClickMeeting conference that should receive invitations.
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.