Get a focused total without digging through rows
Ask for a number through a webhook and have Notis use Cody context and matching spreadsheet data to calculate it.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Aggregate Column Data
Find rows matching a column value and calculate results from another column.
Why this helps
Answering simple business questions can take too long when the context is spread across documents and spreadsheet rows.
- Answer focused questions about matching spreadsheet records.
- Avoid manually scanning rows for a total.
- Keep the request and resulting calculation connected.
Setup
Build it in a few focused steps.
- 1Connect Cody and Google Sheets once in the Notis portal.
- 2Create an automation and name it for question-driven totals.
- 3Tell Notis to use the webhook question and Cody's available context to identify the relevant spreadsheet column and matching value, then calculate the requested total.
- 4Choose the Notis webhook trigger and a destination for run reports.
- 5Test with one question whose matching rows and expected total you can verify.
Questions about this workflow
Can it answer any spreadsheet question?
This workflow is for questions that can be answered by matching a value in one column and calculating data from another. Other analyses may need a different action.
What if the request does not identify the right rows?
Have Notis report that the match is unclear and ask for a more specific request rather than calculating an unreliable total.
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.