Check Doppler activity when a tracked metric changes
When a Sheets metric moves, bring recent Doppler activity logs into the same review so you can quickly look for related changes.
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
Activity Logs List
Tool to list workplace activity logs. Use when you need to fetch recent activity logs.
Why this helps
A sudden metric shift can prompt investigation, but gathering the relevant Doppler activity adds another context switch.
- Bring recent Doppler activity into a metric review.
- Reduce manual app switching during an investigation.
- Use the run report to keep the metric change and fetched logs together.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Doppler in the Notis portal once.
- 2Create an automation in Automations, New Automation, and give it a name and prompt.
- 3Tell Notis which changing aggregate should prompt a Doppler activity log review and what time window to request if supported.
- 4Choose Aggregate Metric Changed as the trigger and select where run reports should go.
- 5Test with one real metric change.
Questions about this workflow
Does a metric change prove a Doppler change caused it?
No. The metric is a prompt to review logs. The workflow gathers activity for investigation and does not establish causation.
What history can it inspect?
The action lists activity logs. Specify a useful time window in your instruction if the action supports it; otherwise the available history may be limited to what the action returns.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Doppler secretops. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Doppler secretops actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Activity Logs List
Tool to list workplace activity logs. Use when you need to fetch recent activity logs.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Retrieve Activity Log
Tool to retrieve a single activity log entry by id. Use when you have a valid Activity Log id.
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.
Retrieve Config Log Entry
Tool to retrieve a specific config log entry. Use when needing details of a single config log; call after specifying project, config, and log identifiers.
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.
Config Logs List
Tool to list config change logs for a specific config. Use when you need the audit trail for a config after confirming its identity.
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.
Config Logs Rollback
Tool to rollback a config to a selected log version. Use when needing to undo a specific change by its log ID, after confirming project, config, and log 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.
Clone Config
Tool to clone a branch config including all its secrets. Use after confirming the source config details.
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 Branch Config
Tool to create a branch config. Use when you need to programmatically establish a new branch-based configuration for a specified project and environment. Use after selecting the target project and environment.
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.
Configs Delete
Tool to delete a config permanently. Use when you need to remove a config that is no longer needed.
Connect any two apps with Notis in the middle.
Google Sheets and Doppler secretops, 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 Doppler secretops.