Shopify Inventory Tracking in Google Sheets

What you'll build: A Google Sheet that receives Shopify inventory updates in real time. A dashboard tab shows current stock by SKU, flags low-inventory items, and tracks stock movement over time — no Shopify app required.

Why Track Shopify Inventory in Google Sheets?

Shopify's inventory dashboard is fine for day-to-day ops — but it doesn't easily show stock movement trends, multi-location consolidated views, or custom reorder point calculations. And it can't be shared with your warehouse team or suppliers without giving them Shopify access.

A Google Sheets inventory tracker connected via Autometon gives you real-time stock data in a format everyone can access and customize. Add your own formulas for reorder quantities, seasonality adjustments, or supplier lead times — none of which Shopify can calculate natively.

Setting Up Shopify Inventory Tracking

Create a Autometon pipeline

Add webhook in Shopify

In Shopify: Settings → Notifications → Webhooks → Create Webhook. Select 'Inventory levels: Update' as the event. Paste your Autometon webhook URL. Format: JSON.

Also add product and order webhooks

Add two more webhooks: 'Products: Update' (captures product detail changes including inventory policy) and 'Orders: Create' (lets you track sales-driven inventory depletion). Same Autometon URL for all three — or create separate pipelines per event type.

Send a test event

Update a product's inventory in Shopify to trigger the webhook. Autometon receives it and auto-detects fields: inventory_item_id, location_id, available, updated_at.

Map fields and activate

Map available → Stock Level, sku (from product webhook) → SKU, title → Product Name, updated_at → Last Updated. Share your sheet with Autometon's service account and activate.

Building the Inventory Dashboard

Current stock by SKU

Use MAXIFS to get the most recent stock level per SKU (since each webhook event is a point-in-time record):

=MAXIFS('Raw Data'!A:A,'Raw Data'!B:B,D2,'Raw Data'!A:A,">"&E2)

Or use a simpler approach: VLOOKUP to a pivot table that shows the last value per SKU.

Low-stock alerts

Add a column: =IF(C2<=10,"⚠️ REORDER","OK") where C2 is your stock level and 10 is your reorder threshold. Apply conditional formatting: cells containing "REORDER" turn red. Every stock level update re-evaluates this automatically.

Stock movement trend

Since every inventory event is a timestamped row, you can chart stock levels over time by SKU. Use a line chart with Date on the X-axis and Stock Level on the Y-axis, filtered by SKU.

Shopify Inventory Webhook Fields

Field	Description
inventory_item_id	Unique ID for the inventory item
location_id	Which location the update applies to (multi-location stores)
available	Current available stock quantity
updated_at	Timestamp of the inventory change

FAQ

Connect Shopify's inventory_levels/update webhook to Autometon. Every time inventory changes — from a sale, a manual adjustment, or a return — Autometon receives the event and writes a row to your Google Sheet automatically.

Yes. Shopify's inventory webhook includes a location_id field. Map it to a Location column in your sheet. Use SUMIF to aggregate stock across all locations, or filter by location for per-warehouse views.

Yes — set up a second Autometon pipeline for Shopify order webhooks. Each order event writes the SKUs and quantities ordered. Join this with your inventory data in a Dashboard tab to see sales velocity by SKU.

No. Autometon uses Shopify's native webhook system, which is built into every Shopify plan (Basic and above). No app installation, no app store fees, no additional Shopify permissions beyond your existing plan.

Shopify Inventory Tracking in Google Sheets: Real-Time Stock Alerts