Organize contacts when query results change
When a saved table query adds, removes, or updates rows, Notis can apply a chosen Dripcel tag to the relevant contact.
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
Add tags to a contact
Tool to add tags to a contact. use when you need to assign tag ids or tag names to an existing contact by msisdn. set create missing contact=true to auto-create the contact if it does not exist.
Why this helps
Important changes buried in query results can leave the right contacts unorganized for follow-up.
- Keep contact tags aligned with changing results
- Reduce manual review of query output
- Make relevant contacts easier to find
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Dripcel once in the Notis portal.
- 2Create a named automation in Automations, New Automation.
- 3Tell Notis which changed query rows identify contacts and which tag to apply.
- 4Choose Table Query Result Changed as the trigger and select a report channel.
- 5Test with one real query result change and inspect the tagged contact.
Questions about this workflow
What changes does this trigger detect?
It detects rows added, removed, or updated in the result set of a saved table query.
Will it tag every row in the query?
Describe in your instruction which returned rows and contacts should receive the tag. The event provides changed query results.
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.