Get a text when a key sales metric changes
Track an aggregate in Sheets and send a concise SMS when its value changes, so important movement is easier to catch.
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 SMS
Tool to send a single sms to a contact. use when you need to deliver a targeted message immediately or schedule it for later.
Why this helps
Checking a dashboard repeatedly adds busywork and makes metric changes easier to overlook.
- Notice movement in a key business metric
- Reduce repeated spreadsheet checks
- Bring important changes into a direct notification
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Dripcel once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name the metric alert.
- 3Tell Notis which metric change matters and what concise SMS to send to the intended contact.
- 4Choose Aggregate Metric Changed as the trigger and choose where run reports go.
- 5Test with one real example and confirm the alert is clear.
Questions about this workflow
Which metrics can trigger it?
The trigger supports SUM, COUNT, AVG, MIN, and MAX on a target column, optionally filtered by a search column and value.
Does the trigger compare against a target threshold?
It fires when the calculated result changes. A threshold rule must be described with available information, and the trigger itself does not promise threshold crossing detection.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Dripcel. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Dripcel actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Delete Contact
Tool to delete a contact by their cell number. use when you need to remove a contact from dripcel after confirming the msisdn.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Dripcel Campaigns
Tool to retrieve a list of all campaigns. use after authenticating when you need to paginate or filter campaigns.
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 current credit balance
Tool to get current credit balance. use after authenticating and when you need to verify account balance before credit-consuming operations.
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 Deliveries
Tool to retrieve a list of deliveries. use when you need to fetch delivered messages optionally filtered by cell or customerid.
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 email templates
Tool to list all available email templates. use when you need to retrieve available templates before sending email campaigns.
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 sales
Tool to retrieve a list of all sales. use when you need comprehensive sales data for reporting or analytics.
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.
Dripcel Post Compliance Send
Tool to check a list of cell numbers against campaign targeting criteria. use when ensuring suppliers comply with your campaign rules before sending messages.
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.
Search replies based on filters
Tool to search replies based on filters. use when you need to find replies by id, campaign, date range, or content.
Connect any two apps with Notis in the middle.
Google Sheets and Dripcel, 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 Dripcel.