Let saved query changes trigger a Customer.io broadcast
When a query result changes in a meaningful way, let Notis trigger the broadcast you identify and include your stated context.
Trigger
Table Query Result Changed
Triggers when the result set of a saved table query changes in Google Sheets. Detects rows added, removed, or updated in the query output. This trigger monitors the result of a SQL query against a Google Sheets table and fires when changes are detected.
Action
Trigger Broadcast
Tool to manually trigger a broadcast. use when you need to override the default audience and provide personalization data after confirming the broadcast id.
Why this helps
Important changes in a query result can be overlooked when someone has to notice them and start campaign follow-up manually.
- React to added, removed, or updated query result rows.
- Use supplied query context in a broadcast trigger.
- Reduce manual monitoring of saved query output.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Customer.io once in the Notis portal.
- 2Create an automation in Automations by choosing New Automation and adding a name and prompt.
- 3Tell Notis what query-result changes matter and which existing broadcast to trigger with the supplied context.
- 4Choose Table Query Result Changed as the trigger and select a report channel.
- 5Test with one real query result change and confirm the broadcast ID is available.
Questions about this workflow
What changes can this trigger detect?
It detects rows added, removed, or updated in the saved query result.
Does this make a broadcast or campaign?
No. It triggers an existing broadcast whose ID you provide.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Customerio. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Customerio actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Suppress Customer Profile
Tool to suppress a person. use when you need to permanently delete a customer's profile and prevent them from being re-added.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Integrations
Tool to retrieve a list of integrations in your workspace. use when you need to discover configured integrations.
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 Messages
Tool to retrieve a list of messages sent from your workspace. use when you need paginated delivery metrics for messages, e.g., list email messages delivered between two timestamps.
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 Segment Details
Tool to retrieve details of a specific segment. use after identifying the segment id from list segments.
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 Segment Membership
Tool to retrieve people in a specific segment. use when you need to page through segment membership after identifying segment 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 Segments
Tool to retrieve a list of segments in your workspace. use when you need to fetch all segments after configuring segment rules.
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 Trigger
Tool to retrieve details about a specific trigger. use after triggering a broadcast to confirm its status and metadata.
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 Triggers
Tool to retrieve a list of triggers for a specific broadcast. use after identifying broadcast id to inspect associated triggers.
Connect any two apps with Notis in the middle.
Google Sheets and Customerio, 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 Customerio.