Create a Coda metric brief when totals change
Give important numbers context while the change is still fresh.
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 doc
Creates a new coda doc, optionally copying an existing doc. note that creating a doc requires you to be a doc maker in the applicable workspace (or be auto-promoted to one).
Why this helps
A changing total raises questions, but the reason and response are rarely documented.
- Document KPI movement
- Prompt investigation
- Keep decisions near the numbers
Setup
Build it in a few focused steps.
- 1Connect Google Super and Coda once in Notis.
- 2Create an automation named Aggregate metric brief.
- 3Tell Notis to create a Coda doc with the old and new metric, likely drivers from available data, questions, and a proposed action.
- 4Pick Aggregate Metric Changed as the trigger.
- 5Choose a report channel, test with one metric change, and review the brief.
Questions about this workflow
Which aggregate functions are supported?
The trigger supports SUM, COUNT, AVG, MIN, and MAX.
Can it filter the monitored records?
Yes. Configure an optional search column and value in the trigger.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Coda. A trigger fires from one place; an action lands in another.
Google Super 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.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
Add custom domain
Add a custom domain to a published doc.
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 permission
Adds a new permission to the doc.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Begin content export
Initiate an export of content for the given page.
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.
Content export status
Check the status of a page content export
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.
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 Super 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.