Turn a Priority Sheet Change Into a One-Time Booking Link
When the monitored range changes, prepare a Calendly link that expires after one booking for a focused handoff.
Trigger
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.
Action
Create single use scheduling link
Creates a one-time, single-use scheduling link for an active calendly event type, expiring after one booking.
Why this helps
A priority changes in the sheet, but creating a fresh link for the handoff is easy to forget.
- Create a link that can be used for one booking.
- Respond to a change in a specific monitored range.
- Keep link creation tied to the sheet update that signals a handoff.
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.
- 3In one instruction, tell Notis to create a single-use scheduling link when the monitored range changes and explain what the change means.
- 4Pick the Google Sheets Cell Range Values Changed trigger and choose where run reports go.
- 5Test with one real change in the monitored range and check the run report.
Questions about this workflow
Will the trigger watch the whole spreadsheet?
No. The Cell Range Values Changed trigger watches a specified A1 range.
How many bookings can the link make?
The single-use scheduling link expires after one booking.
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.