Keep manager availability in sync with your sheet
Change the monitored availability range and let Notis apply the relevant update to a Callpage manager.
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
Update Manager
Tool to update an existing manager. use when you need to modify a manager's availability or business hours after retrieving their record.
Why this helps
Maintaining hours in a spreadsheet and a separate callback tool creates duplicate admin and increases the chance of stale availability.
- Use a monitored range as the signal for an availability update.
- Avoid re-entering revised hours in multiple places.
- Keep changes tied to a specific manager and instruction.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Callpage once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a clear name.
- 3Tell Notis how to interpret changes in the availability range and which manager details or hours to update in Callpage.
- 4Choose Cell Range Values Changed as the trigger and select where run reports should go.
- 5Test with one real example change and review the updated manager details.
Questions about this workflow
What spreadsheet values should I include?
Include the availability or business hours information and enough context in your instruction to identify the intended manager. Notis cannot supply missing manager details.
Can the trigger watch a specific range?
Yes. Cell Range Values Changed monitors values in a specified A1 range and starts when values in that range change.
Will this create a manager?
No. The available Callpage action updates an existing manager. The relevant manager must already exist.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Callpage. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Callpage actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get All Managers
Tool to retrieve a list of managers for a specific widget with pagination. use when you need to page through all managers assigned to a widget after confirming its id.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get All SMS Messages
Tool to retrieve all sms messages for a widget. use when you need to fetch both default and custom sms templates after confirming the widget exists.
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.
Get All Users
Tool to retrieve a list of all users with pagination. use when you need to page through all users in your callpage account to synchronize or audit user records.
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.
Get All Widgets
Tool to retrieve a list of widgets with pagination. use when you need to page through all widgets after api authentication.
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.
Get API Root
Tool to get the root api greeting. use to verify connectivity and retrieve the initial api greeting after setting the api key.
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.
Get Manager Status Statistics
Tool to retrieve statistical data about manager statuses. use when you need summary counts of enabled and disabled managers for a specific widget.
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.
Get SMS Statistics
Tool to retrieve statistical data about sms messages. use when you need summary counts of sms messages for a given widget.
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 Widget
Tool to retrieve details of a specific widget by id. use when you have a widget id and need its complete configuration.
Connect any two apps with Notis in the middle.
Google Sheets and Callpage, 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 Callpage.