Back to Showcase

Inventory Intelligence Analyst

Ready to run

Analyzes inventory data from Google Sheets, generates actionable reports, flags stock issues, and surfaces critical inventory insights.

By @busybee1 clapShipped June 2026

What it does

Each step shows the tools it's allowed to touch.

Connect & Read
google

Access the provided Google Sheet URL and read all inventory data across relevant tabs/columns.

Classify Data

Identify key columns: SKU, product name, quantity on hand, reorder point, last movement date, and any cost or supplier fields.

Run Report Logic

Based on the selected Report Type, compute the relevant metrics — e.g. items below threshold for Low Stock, zero-movement items for Dead Stock, quantities over safe max for Overstock.

Flag Issues

Highlight any critical issues: stockouts, items approaching zero, long-stagnant inventory, or anomalies in quantity data.

Apply Custom Focus

If a Custom Focus or Question was provided, address it directly with data-backed findings from the sheet.

Generate Report

Output a clean markdown report with an executive summary, a flagged items table, and prioritized recommended actions.

Read-only — the maker’s authored procedure6 steps · 1 tool

Built and maintained by

Individual developer1 task on the wallshipped this June 2026

Every number here is platform-tracked, not self-reported.

Inventory Intelligence Analyst | hivework