Review Brevo contacts from changing queries
Keep audience research current as your operational query changes.
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
Get all contacts
This tool retrieves all contacts from your brevo account. it allows for pagination and filtering based on modification/creation dates, list ids, segment ids, and contact attributes.
Why this helps
Query results evolve, but the corresponding contact review is often postponed.
- Keeps reviews current
- Reduces manual exports
- Supports faster audience decisions
Setup
Build it in a few focused steps.
- 1Connect Google Super and Brevo in Notis.
- 2Create an automation for table-query audience review.
- 3Tell Notis to retrieve and summarize relevant Brevo contacts for changed query results.
- 4Pick Table Query Result Changed as the trigger.
- 5Choose a report channel and test with one query change.
Questions about this workflow
What changes can trigger it?
The trigger detects rows added, removed, or updated in the saved query output.
Does it write back to the sheet?
No. It reviews Brevo contacts based on the changed query result.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Brevo. A trigger fires from one place; an action lands in another.
Google Super triggers
Brevo actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create a company
This tool allows you to create a new company in your brevo account.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create or Update Email Template
This tool creates a new email template or updates an existing one in brevo. if a 'templateid' is provided, it performs an update; otherwise, it creates a new template.
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 SMS Campaign
This tool allows you to create a new sms campaign in brevo. you can specify the campaign name, sender, content, recipients (by providing list ids, exclusion list ids, or segment ids), and optionally schedule the campaign for a specific time. you can also enable unicode characters, add an organization prefix, and include unsubscribe instructions.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
Delete a company
Deletes a company from brevo using its unique identifier.
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.
Delete Contact
Deletes a contact from brevo using its unique identifier.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Delete Email Template
This tool deletes an inactive email template from brevo. you need to provide the 'templateid' of the email template you want to delete. only inactive templates can be deleted.
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.
Delete SMS Campaign
This tool deletes an existing sms campaign.
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.
Find Contact
This tool checks if a contact exists in brevo. it searches for a contact using either an email address or mobile number, with the email being prioritized if both are provided.
Connect any two apps with Notis in the middle.
Google Super and Brevo, 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 Brevo.