How to build inventory in Google Sheets & Excel

1. Manual inventory tracking in Google Sheets and Excel

Manual doesn’t have to mean messy. Start by turning one spreadsheet into your single source of truth.

‍

Method 1: Simple stock list (great for small catalogs)

1. Create your file
   • Google Sheets: Go to https://sheets.google.com → Blank.
   • Excel: Open Excel → New → search for "inventory" or choose Blank workbook.
2. Define your columns (row 1):
   SKU | Item name | Category | Location | Min stock | On hand | Unit cost | Status
3. Add data validation for clean SKUs
   • Google Sheets: Data → Data validation (docs: https://support.google.com/docs/answer/139705) and restrict SKUs to text of fixed length or a list.
   • Excel: Data → Data Validation (docs: https://support.microsoft.com/office/apply-data-validation-to-cells-29c714d0-6da3-4f95-9c8a-9b1b90731052).
4. Flag low stock visually
   • Sheets: Format → Conditional formatting, rule: On hand < Min stock, style red fill (docs: https://support.google.com/docs/answer/78413).
   • Excel: Home → Conditional Formatting → Highlight Cells Rules → Less Than… and compare On hand to Min stock.
5. Manually update after every movement
   When stock comes in or goes out, edit the On hand cell and adjust Status ("OK", "Reorder", "Discontinued").

‍

Pros: Fast to set up, perfect for founders proving demand.
Cons: Easy to forget updates, no audit trail, fragile when multiple people edit.

‍

Method 2: Transaction‑log model (the grown‑up way)

Instead of overwriting On hand, you log every movement.

1. Keep your Products tab as in Method 1.
2. Add a Transactions tab with columns:
   Date | SKU | Type (IN/OUT) | Quantity | Source (PO, sale, adjustment) | Notes
3. Each time stock moves, add a row. Never overwrite old ones.
4. Compute On hand from transactions:
   • Sheets: use =SUMIFS(Transactions!C:C, Transactions!B:B, A2, Transactions!C:C, ">0") + SUMIFS(Transactions!C:C, Transactions!B:B, A2, Transactions!C:C, "<0") or separate IN/OUT columns.
   • Excel: same formula logic; see Microsoft’s inventory guide: https://support.microsoft.com/office/track-product-inventory-df87e413-3c9f-46be-87d4-173882c19a07.
5. Link that calculated On hand back into the Products tab via lookup (VLOOKUP/XLOOKUP in Excel, VLOOKUP/INDEX MATCH in Sheets).

‍

Pros: Full history, easier audits, supports multiple channels.
Cons: More formulas, more typing unless you automate inputs.

‍

Method 3: Add a quick inventory dashboard

1. In Sheets, use Insert → Pivot table (docs: https://support.google.com/docs/answer/7572895) on your Transactions tab to summarize quantity by SKU, category, or location.
2. In Excel, select your table → Insert → PivotTable (docs: https://support.microsoft.com/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576).
3. Add charts for:
   • Stock value by category.
   • Top 10 fastest moving SKUs.
4. Place charts on a Dashboard tab so sales, ops, and finance all read the same story.

‍

Pros: Clear visibility, better forecasting talks with your team.
Cons: Still depends on humans remembering to log transactions.

‍

2. No‑code automation around your inventory templates

Once the basics work, remove as much manual typing as possible.

‍

No‑code Idea 1: Forms that write straight into your sheet

1. Receiving form for warehouse or office staff:
   • Sheets: Tools → Create a form or build a Google Form that writes into a Receipts tab.
   • Excel (online): use Microsoft Forms to capture receipts into an Excel file on OneDrive.
2. Map form fields (SKU, Qty received, PO #, Location) to transaction columns.
3. Use formulas or Power Query to merge Receipts into your main Transactions table.

Result: Every time someone receives stock, they hit a simple form on mobile instead of editing formulas.

‍

No‑code Idea 2: Connect your store or CRM

Use tools like Zapier, Make, or Power Automate so sales orders update inventory.

Example flow:

1. Trigger: New order in Shopify, WooCommerce, or your CRM.
2. Action: Find or create row in your Transactions tab in Google Sheets or Excel table.
3. Log one row per line item with Type = OUT and the sold quantity.

You can follow app‑specific recipes in their marketplaces, but the pattern is always: order event → append row → formulas recalc On hand.

‍

Pros: Removes re‑typing web orders, near real‑time stock.
Cons: Still fragmented—POs, supplier emails, and spreadsheets live in different tools.

‍

No‑code Idea 3: Email‑to‑sheet parsing

1. Use Parseur, Mailparser, or similar to extract SKU, quantity, and PO number from vendor emails.
2. Push parsed data into your Transactions or Receipts tab in Sheets/Excel.
3. Let your existing formulas do the math.

‍

Pros: Automates a painful copy‑paste loop.
Cons: Parsers break when vendors change their email format.

‍

3. Scaling with AI agents that work inside Sheets and Excel

At some point, your inventory life is less about one integration and more about hundreds of tiny actions: opening attachments, checking supplier sites, reconciling exports, updating multiple tabs, and sending summaries. This is where a computer‑use AI agent like Sai shines.

‍

AI Method 1: Agent as your daily inventory operator

Picture your Monday morning. While you drink coffee, your Simular agent:

1. Opens your Google Sheets or Excel inventory template on your Mac.
2. Downloads the latest CSV exports from Shopify, Amazon, or your warehouse tool.
3. Cleans column names, fixes formats, and pastes them into the Transactions tab.
4. Checks which SKUs fell below Min stock and writes a "Reorder" list to a new tab.
5. Drafts an email or Slack summary: "12 SKUs below threshold, 4 at risk this week," linking directly to the sheet.

Because Sai works like a power user—clicking, typing, and navigating across browser, desktop apps, and cloud—it doesn’t need rigid APIs. You give it the playbook once; it can follow thousands of steps with production‑grade reliability.

‍

Pros: End‑to‑end workflow automation, human‑like flexibility, transparent actions you can inspect.
Cons: Requires a short onboarding run, best for teams ready to standardize their process.

‍

AI Method 2: Agent monitoring suppliers and price changes

1. Define a "Suppliers" tab in Sheets/Excel with URLs for each product page and target price.
2. Have your Simular agent:
   • Open each supplier page.
   • Scrape current price and availability.
   • Update the Supplier price and Available? columns.
3. Let formulas compute margin and flag products where margin drops below your target.

Now your weekly pricing review appears as a neat sheet, not a three‑hour clickfest.

‍

Pros: Data you’d never bother collecting manually, fast reaction to margin erosion.
Cons: Needs occasional tuning if sites change layout.

‍

AI Method 3: Agent‑generated inventory stories for sales and marketing

Sales and marketers don’t want a raw table; they want a story. Your Simular agent can:

1. Read inventory and sales tabs in Sheets/Excel.
2. Identify overstocked items and slow movers.
3. Draft a campaign brief: "Run a 20% promo on these 8 SKUs; you have 90+ days of stock" and drop it into a Google Doc or email draft.

‍

Pros: Turns operational data into marketing actions with almost no human effort.
Cons: Still need a human to approve final campaigns.

By combining robust Google Sheets and Excel templates with an AI agent that actually clicks the buttons for you, you stop being the bottleneck and start being the strategist.