Hasaan Mehmood Back
2026Enterprise Supply Chain Gigs

Autonomous BOM Inventory Agent

A zero-touch workspace execution pipeline triggering dynamic database adjustments and text distribution loops from operational chat points.

Autonomous BOM Inventory Agent screenshot
Role
Automation Engineer
Client
Enterprise Supply Chain Gigs
Year
2026
Duration
3 weeks

The challenge

Processing asynchronous client text commands for Bill of Materials (BOM) validation required manual stock cross-referencing and updates across disconnected storage tables.

The approach

Designed an automated n8n workflow triggered directly by conversational chat webhooks. The workflow passes text elements to an active OpenAI model with simple memory, processes conditional logic branches, scans multi-sheet datasets, and writes live material inventory deductions.

The outcome

Removed manual order verification latency entirely, building a continuous tracking cycle across digital spreadsheets.

Highlights

  • Autonomous conversational branch filtering
  • Complex multi-sheet lookup validation execution
  • Live order modification callback confirmations
n8nOpenAIGoogle SheetsPython
Next project
Wander Hub AI