Put changing spreadsheet metrics in front of you
A changing total or average can signal a decision point. Send the new result to Coda with a short explanation of what it measures.
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
Create a page
Create a new page in a doc. note that creating a page requires you to be a doc maker in the applicable workspace.
Why this helps
Key metrics can change between check-ins, so you may notice a shift only after it has already affected a decision.
- Bring a changed metric into a place where you plan work.
- Include the aggregate result and context supplied by the trigger.
- Make metric review a deliberate next step.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Coda once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a clear name.
- 3In one instruction, ask Notis to create a Coda page with the changed aggregate, what it measures, and a concise review prompt.
- 4Choose Aggregate Metric Changed as the trigger, then choose where run reports should go.
- 5Test it with one real example metric change.
Questions about this workflow
Which metrics can trigger this workflow?
The event monitors a SUM, COUNT, AVG, MIN, or MAX calculation and fires when the calculated result changes.
Can the workflow explain why the metric changed?
Only if the trigger data or supplied context provides that information. The aggregate event does not promise a cause for the change.
Can I monitor a subset of rows?
The trigger can optionally filter by a search column and value when it is configured.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Coda. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Coda actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add a category for pack
Add a publishing category for a given pack.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add a maker for pack
Set a maker for a given pack. used to display makers for a pack in the corresponding packs page.
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.
Add a permission for pack
Create or modify user, workspace, or global permissions for a given pack.
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.
Add custom domain
Add a custom domain to a published doc.
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.
Add permission
Adds a new permission to the doc.
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.
Begin content export
Initiate an export of content for the given page.
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.
Content export status
Check the status of a page content export
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.
Copy Document
Creates a copy of an existing coda document. this action allows you to duplicate a document while optionally specifying a new title and location for the copied document.
Connect any two apps with Notis in the middle.
Google Sheets and Coda, 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 Coda.