Real-Time Inventory Lookup from a Shared Sheet

Your warehouse team maintains stock in a Google Sheet. Sales reps ping the agent from WhatsApp with a SKU, and the agent returns live availability, location, and last restock date.

WhatsApp Groupinventorylookupreal-time

Conversation example

Stock on WDG-PRO-V2 and WDG-LITE?

http_request → Sheets API v4 values.batchGet

Querying 'Warehouse Stock' → tab 'Live' on the SKU column...

Stock check — 2 SKUs WDG-PRO-V2 (Widget Pro V2) - On hand: 234 units - Reserved: 48 - Available: 186 - Location: Bay 4 / Shelf C - Last restock: Apr 8 (500 units) WDG-LITE (Widget Lite) - On hand: 8 units (LOW) - Reserved: 6 - Available: 2 - Location: Bay 1 / Shelf A - Last restock: Mar 22 Heads up: WDG-LITE is below the 25-unit reorder threshold. Want me to draft a PO to the supplier?

More Google Sheets use cases

Deploy this in minutes

Create a LunoGen agent, connect Google Sheets, and start running this workflow from WhatsApp today.