Refresh selected business metrics from company knowledge
Request a focused update, have Cody find the relevant figures, and let Notis update matching cells in your spreadsheet.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Batch Update Values by Data Filter
Updates spreadsheet values in ranges that match data filters.
Why this helps
Manual metric updates often get delayed because the latest figures are buried in company notes or documents.
- Refresh selected values from knowledge Cody can access.
- Keep a spreadsheet's existing structure in place.
- Reduce manual copying for recurring updates.
Setup
Build it in a few focused steps.
- 1Connect Cody and Google Sheets once in the Notis portal.
- 2Create an automation and name the metric update.
- 3Tell Notis which metric context the webhook request will include, ask Cody to find the relevant values, and update matching spreadsheet values only when the target rows can be identified.
- 4Choose the Notis webhook trigger and where run reports should go.
- 5Send one real update request and confirm the intended values changed.
Questions about this workflow
Does this create new metric rows?
This workflow uses a data-filter update action, so it is intended for matching existing values. Use a different workflow if you need to append new records.
What if Cody cannot find a value?
Ask Notis to report the missing value instead of guessing or updating a cell with unsupported information.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Cody to Google Sheets. A trigger fires from one place; an action lands in another.
Cody triggers
Google Sheets actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Sheet to Existing Spreadsheet
Adds a grid sheet with rows and columns to an existing spreadsheet.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Aggregate Column Data
Find rows matching a column value and calculate results from another column.
Append Dimension
Adds empty rows or columns to the end of a sheet.
Batch get spreadsheet
Retrieves data from selected spreadsheet ranges.
Auto-Resize Rows or Columns
Automatically adjusts row heights or column widths to fit their contents.
Batch Update Values by Data Filter
Updates spreadsheet values in ranges that match data filters.
Clear Basic Filter
Removes the basic filter from a sheet.
Batch update spreadsheet (Deprecated)
Connect any two apps with Notis in the middle.
Cody and Google Sheets, 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 Google Sheets.