Explain changing stock metrics with BoxHero transactions
Move from a surprising metric to the transaction history that may explain it.
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
BoxHero - List Basic Transactions
Tool to list basic inventory transactions. Use when you need a high-level overview of in/out/move transactions.
Why this helps
A changed stock total triggers manual digging across spreadsheets and inventory records.
- Shortens anomaly investigation
- Adds transaction context to spreadsheet changes
- Creates a repeatable review habit
Setup
Build it in a few focused steps.
- 1Connect Google Super and Boxhero once in Notis.
- 2Create an automation named Stock Metric Investigation.
- 3Tell Notis to review the changed aggregate and summarize relevant recent BoxHero transactions that could explain it.
- 4Pick Aggregate Metric Changed as the trigger.
- 5Choose a report channel and test with one real metric change.
Questions about this workflow
Can Notis prove which transaction caused the change?
It can identify relevant transactions in the returned history, but the user must confirm causality.
Can I monitor different metrics?
Yes. Create separate automations for the metrics you need to watch.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Boxhero. A trigger fires from one place; an action lands in another.
Google Super triggers
Boxhero actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Delete Item
Tool to delete a specific item (barcode) by its ID. Use when you need to remove an item from the inventory.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
BoxHero - Delete Location
Tool to delete a specific warehouse location by its ID. Use when you need to remove a location from the system.
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.
Get Item
Tool to retrieve a specific item (barcode) by ID. Use when you need detailed information about a single item including its attributes, pricing, and inventory quantities.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
Get Item Attribute
Tool to retrieve a specific item attribute by ID. Use when you need to get detailed information about an item attribute specification.
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.
Get Location
Tool to retrieve a specific location by ID. Use when you need detailed information about a particular warehouse location including its name, quantity, and notes.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Get Member
Tool to retrieve a specific team member by ID. Use when you need to get details about a particular member.
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.
Get Linked Team Info
Tool to get information about the linked team and its mode. Use when you need to retrieve the currently linked team details.
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.
BoxHero - List Basic Transactions
Tool to list basic inventory transactions. Use when you need a high-level overview of in/out/move transactions.
Connect any two apps with Notis in the middle.
Google Super and Boxhero, 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 Boxhero.