Send qualifying query results to ActiveTrail
Use a saved query result to identify contacts ready for a particular email audience. Tell Notis how to interpret qualifying rows and which ActiveTrail group should receive them.
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
Create or Update Group Member
Tool to create or update a member in a group. Use when you need to add a new contact to a specific group or update an existing member's details. The API will not return errors if the address is already in the group.
Why this helps
Useful segments in a spreadsheet query often require another manual step before they can receive the right communications.
- Act on changes to a saved query result.
- Keep a described audience segment in the ActiveTrail group you choose.
- Avoid rechecking query output and manually updating contacts.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and ActiveTrail once in the Notis portal.
- 2Create an automation in the portal or tell Notis from any channel.
- 3In one instruction, name the saved table query, define qualifying rows, and name the ActiveTrail group.
- 4Pick Table Query Result Changed as the trigger and choose where run reports go.
- 5Test with one real query result change and confirm the group member in ActiveTrail.
Questions about this workflow
Does the trigger run on any spreadsheet query?
It monitors the result set of a saved table query in Google Sheets. Specify which saved query the automation should use.
Does Notis know my qualification rules?
Describe the qualifying rows in your instruction. The trigger reports rows added, removed, or updated in the query output.
What if a result row does not include an email?
The group member action requires an email. Explain how Notis should handle rows without one.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to ActiveTrail. A trigger fires from one place; an action lands in another.
Google Sheets triggers
ActiveTrail actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Group Member
Tool to add a member to a group in ActiveTrail. Use when you need to add a contact to a specific group with their email and optional contact details.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Contact Growth
Tool to retrieve executive report on contact growth showing daily active and inactive contact growth. Use when you need to measure the increase in amount of contacts over a date range.
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.
Create or Update Group Member
Tool to create or update a member in a group. Use when you need to add a new contact to a specific group or update an existing member's details. The API will not return errors if the address is already in the group.
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.
Create a New Group
Tool to create a new group in ActiveTrail. Use when you need to add a new group to organize and segment contacts.
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.
Create Contact
Tool to create a new contact in ActiveTrail. Use when you need to add a new contact to the system. Note: Newly created contacts won't be linked to any group, making email/SMS delivery impossible until assigned to a group. Either email or sms must be provided.
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.
Create Content Category
Tool to create a new content category in ActiveTrail account. Use when you need to add a new category for organizing campaigns and templates.
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.
Create New Mailing List
Tool to create a new mailing list in ActiveTrail. Use when you need to add a new mailing list to organize and manage contacts.
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.
Create Order
Tool to create new orders in ActiveTrail commerce system. Use when you need to add order records with customer information, products, and transaction details. Accepts an array of order objects for batch creation.
Connect any two apps with Notis in the middle.
Google Sheets and ActiveTrail, 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 ActiveTrail.