Connect changing campaign metrics to a banner review
When a tracked total changes, have Notis gather current banner statuses and report what may need a closer look.
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
List Banners
Tool to list all banners and their statuses. use when you need to retrieve banners after creation or to audit existing banners. ensure you apply filters to narrow down results (e.g., status='ready').
Why this helps
A changing campaign metric can call for a creative review, but that check is easy to postpone when it lives in another app.
- Pair a metric change with a current banner status snapshot.
- Keep campaign review closer to the signal that prompted it.
- Receive a report that highlights missing context for interpretation.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Adrapid once in the Notis portal.
- 2Create an automation by naming it and describing the outcome in one instruction.
- 3Pick Aggregate Metric Changed and select the metric to monitor.
- 4Choose where run reports go, then test with one real example metric change.
- 5Tell Notis to list Adrapid banners and summarize their statuses with the changed metric, without assuming the metric explains banner performance.
Questions about this workflow
Can this identify which banner caused the metric change?
No. The available action retrieves banners and statuses, while the trigger reports an aggregate change. The workflow should not claim causation.
Can I filter the metric by a campaign value?
The trigger supports an optional search column and value. Select those trigger settings when setting up the automation if they are relevant.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Adrapid. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Adrapid actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get API info
Tool to retrieve api root information. use when you need to discover the api's description and version details.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get user and API info
Tool to get user account and api information. use when you need to retrieve authenticated user details and api versions.
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.
List Banners
Tool to list all banners and their statuses. use when you need to retrieve banners after creation or to audit existing banners. ensure you apply filters to narrow down results (e.g., status='ready').
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.
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.
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.
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.
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.
Connect any two apps with Notis in the middle.
Google Sheets and Adrapid, 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 Adrapid.