Investigate response patterns when a tracked metric changes
A changing total or average can prompt a closer look at the related Cabinpanda responses.
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
List form submissions
Tool to retrieve a list of all submissions for a specific form. use after obtaining the form id to review its submissions.
Why this helps
A metric can move without explaining why, leaving you to remember which source responses to inspect and where to find them.
- Use a meaningful metric change to start a response review.
- Retrieve submissions for a form id you provide.
- Ask Notis to summarize returned response details that may inform the shift.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Cabinpanda once in the Notis portal.
- 2Create an automation that retrieves submissions for your specified form and summarizes response details relevant to the changed metric.
- 3Pick the Google Sheets Aggregate Metric Changed trigger and set its aggregate in the trigger setup.
- 4Choose a report channel and test with one real metric change and a valid form id.
Questions about this workflow
Does the metric trigger explain what caused the change?
No. It signals that the configured aggregate changed. Notis can review returned submissions, but any causal explanation is an analysis, not a guarantee.
Which aggregate calculations are supported?
The listed trigger supports SUM, COUNT, AVG, MIN, and MAX on a target column, optionally filtered by a search column and value.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Cabinpanda. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Cabinpanda actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Form
Tool to create a new form with specified fields and settings. use before collecting submissions to define form structure.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete Form
Tool to delete a specific form by its id. use after confirming the target form exists and is safe to remove.
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 Integration
Tool to delete a specific integration by its id. use when you need to remove or disable an existing integration (e.g., webhook) after confirming the integration id.
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 Form Details
Tool to retrieve details of a specific form by its id. use when you need form metadata (fields, labels, timestamps) before processing or submitting data.
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 Integration Details
Tool to retrieve details of a specific integration by its id. use when you need to inspect integration settings or status after obtaining its id.
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 Profile
Tool to retrieve the authenticated user's profile information. use after obtaining valid api credentials to access user details.
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.
List Forms
Tool to retrieve a list of all forms associated with the account. use when you need to fetch form details for management or analysis.
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.
List Integrations
Tool to retrieve a list of all integrations for the account. use when you need to inspect available or active integrations before managing them.
Connect any two apps with Notis in the middle.
Google Sheets and Cabinpanda, 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 Cabinpanda.