Get BoxHero context when a tracked row changes
Track a key spreadsheet row and bring the matching item's BoxHero details into the run report when it changes.
Trigger
Spreadsheet Row Changed
Triggers when a looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the row's values change, when the row appears, or when the row disappears.
Action
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.
Why this helps
Important row updates can be easy to miss, especially when reviewing the inventory context means opening a second app.
- Get item details when the tracked row changes or appears.
- See when the searched row disappears and flag it for follow-up.
- Keep spreadsheet change context and item lookup in one report.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and BoxHero once in the Notis portal.
- 2Create an automation in the portal or tell Notis to create one from your usual channel.
- 3Ask Notis to use the tracked row's identifying value to retrieve and summarize the matching BoxHero item.
- 4Pick the Spreadsheet Row Changed trigger and choose where run reports should go.
- 5Test with one real row change and review the report.
Questions about this workflow
What happens if the row disappears?
The trigger can fire when the looked-up row disappears. In that case, there may be no current row value to use for a BoxHero item lookup, so the report should note that limitation.
Does this watch every row in the sheet?
No. It monitors a row located by searching for a query value within a user-specified range.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Boxhero. A trigger fires from one place; an action lands in another.
Google Sheets 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.
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 Item Attribute
Tool to retrieve a specific item attribute by ID. Use when you need to get detailed information about an item attribute specification.
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 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.
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.
Get Member
Tool to retrieve a specific team member by ID. Use when you need to get details about a particular member.
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.
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.
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.
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 Sheets 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.