Turn a Metric Change Into a One-Off Meeting Type
When a tracked total or average changes, prepare a temporary Calendly event type for the milestone meeting you have in mind.
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 One-Off Event Type
Creates a temporary calendly one-off event type for unique meetings outside regular availability, requiring valid host/co-host uris, a future date/range for `date setting`, and a positive `duration`.
Why this helps
Important milestones can pass without anyone organizing the meeting they call for.
- Respond to changes in a SUM, COUNT, AVG, MIN, or MAX calculation.
- Create a temporary event type for a specific meeting need.
- Specify the host or co-host, future date or range, and duration in your instruction.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Calendly once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3Tell Notis to create a Calendly one-off event type when the monitored metric changes, including valid host or co-host URIs, a future date or range, and a positive duration.
- 4Pick the Google Sheets Aggregate Metric Changed trigger and choose where run reports go.
- 5Test with one real metric change and review the run report.
Questions about this workflow
What does this action create?
It creates a temporary Calendly one-off event type. It does not create a scheduled meeting with an invitee.
What details are required?
The action requires valid host or co-host URIs, a future date or range, and a positive duration.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Calendly. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Calendly actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Cancel event
Permanently cancels an existing, active scheduled event by its `uuid`, optionally providing a `reason`, which may trigger notifications to invitees.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create an invitee no-show
Marks an invitee, identified by their existing and valid uri, as a 'no show' for a scheduled 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.
Create One-Off Event Type
Creates a temporary calendly one-off event type for unique meetings outside regular availability, requiring valid host/co-host uris, a future date/range for `date setting`, and a positive `duration`.
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.
Create scheduling link
Create a single-use scheduling link. creates a scheduling link that can be used to book an event. the link allows invitees to schedule up to the specified maximum number of events. once the limit is reached, the link becomes inactive.
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.
Create share
Creates a customizable, one-time share link for a calendly event type, allowing specific overrides to its settings (e.g., duration, availability, location) without altering the original event type.
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.
Create single use scheduling link
Creates a one-time, single-use scheduling link for an active calendly event type, expiring after one booking.
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.
Create webhook subscription
Creates a calendly webhook subscription to notify a specified `url` (which must be a publicly accessible https endpoint) for selected `events` within a given `organization` and `scope`.
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.
Delete invitee data
Permanently removes all invitee data associated with the provided emails from past organization events, for data privacy compliance (requires enterprise subscription; deletion may take up to one week).
Connect any two apps with Notis in the middle.
Google Sheets and Calendly, 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 Calendly.