Bring important cell range changes into Coda
When a key range changes, a short Coda update helps you spot the change without revisiting the spreadsheet immediately.
Trigger
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.
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
Updates to critical cells are easy to miss when you are focused on other work.
- Surface changes to a specific range in Coda.
- Ask Notis to summarize the reported values for quick review.
- Keep important spreadsheet updates visible.
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 summarizing the changed range values and any review needed.
- 4Choose Cell Range Values Changed as the trigger, then choose where run reports should go.
- 5Test it with one real example range change.
Questions about this workflow
What does the trigger monitor?
It monitors a specific cell or range of cells in Google Sheets and fires when values change.
Can Notis say what caused the values to change?
The trigger reports that values changed. A cause can be stated only when it is present in the event details or supplied context.
Can I use this for a particular section of a spreadsheet?
Yes. The trigger is configured to watch a specified A1 range.
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.