Google Sheets for Inventory Management: Template and Guide

Managing inventory in Google Sheets is one of the most practical ways for small and mid-sized businesses to track stock without investing in expensive software. Whether you run a Shopify store, a local retail shop, or a small warehouse, a well-built Google Sheets inventory management system can handle product tracking, low-stock alerts, and supplier lookups for free. In this guide, you'll learn how to build a complete inventory tracker from scratch, use essential formulas, and automate alerts so you never miss a reorder.

Key Takeaways:Google Sheets can handle inventory for businesses tracking up to 5,000 SKUs effectivelySUMIF, COUNTIF, and IF formulas automate stock valuation and reorder alertsConditional formatting flags low-stock items instantly without manual checkingSmoothSheet imports large CSV inventory exports from Shopify or WooCommerce without browser crashes

Why Use Google Sheets for Inventory Management?

Dedicated inventory software like TradeGecko, Cin7, or Sortly can cost $50-$300 per month. For businesses tracking a few hundred to a few thousand SKUs, that's often overkill. Google Sheets gives you a surprisingly capable alternative at zero cost.

Here's why teams choose Google Sheets for inventory tracking:

• Free and accessible: No subscription fees, and anyone with a Google account can use it
• Real-time collaboration: Multiple team members can update stock counts simultaneously
• Customizable: Build exactly the tracker you need, not the one a vendor designed
• Integration-friendly: Import data from Shopify, WooCommerce, Square, and other platforms via CSV exports
• Formula-powered automation: Calculate stock values, flag low inventory, and generate reorder lists automatically

According to Google's official documentation, Sheets supports up to 10 million cells per spreadsheet, which is more than enough for most inventory needs.

Building Your Inventory Tracker Step by Step

A solid inventory spreadsheet needs the right columns to capture all the data you'll use for tracking, ordering, and reporting. Here's the structure I recommend:

Essential Columns

Setting Up the Spreadsheet

1. Create a new Google Sheet and name it "Inventory Tracker [Year]"
2. Add headers in row 1: Product Name, SKU, Quantity, Reorder Point, Supplier, Unit Cost, Location, Total Value, Reorder Status
3. Format the Unit Cost column as currency (Format > Number > Currency)
4. Freeze row 1 so headers stay visible when scrolling (View > Freeze > 1 row)
5. Add data validation to the Location column with a dropdown of your warehouse locations

The "Total Value" and "Reorder Status" columns will be formula-driven, which I'll cover in the next section.

Essential Formulas for Inventory Management

Formulas turn your static spreadsheet into a dynamic inventory system. Here are the four most important ones.

SUMIF: Calculate Total Stock Value by Supplier

To see how much inventory value you hold from each supplier, use SUMIF:

=SUMIF(E2:E100, "Acme Electronics", H2:H100)

This sums the Total Value column (H) for all rows where the Supplier column (E) matches "Acme Electronics." You can also use this to calculate total stock value across all items:

=SUM(C2:C100 * F2:F100)

This multiplies Quantity (C) by Unit Cost (F) for every row and sums the results, giving you total inventory value in one cell.

COUNTIF: Count Low-Stock Items

Want a quick count of how many products need reordering? COUNTIF makes it simple:

=COUNTIF(I2:I100, "REORDER")

This counts all cells in the Reorder Status column that say "REORDER." Place this in a dashboard cell at the top of your sheet for an at-a-glance alert.

IF: Create Reorder Flags

In the Reorder Status column (I), add this formula to automatically flag items running low:

=IF(C2 <= D2, "REORDER", "OK")

This compares Quantity on Hand (C2) against the Reorder Point (D2). If stock is at or below the threshold, it flags "REORDER." Otherwise, it shows "OK." Drag this formula down for all rows.

VLOOKUP: Supplier Contact Lookup

If you have a separate "Suppliers" sheet with contact details, use VLOOKUP to pull supplier info:

=VLOOKUP(E2, Suppliers!A:D, 3, FALSE)

This looks up the supplier name from column E in your Suppliers sheet and returns the value in the third column (perhaps phone number or email). For more flexible lookups, consider using INDEX MATCH instead of VLOOKUP.

Automating Inventory Alerts

Manual stock checks waste time. Here's how to make your inventory sheet alert you automatically.

Conditional Formatting for Low Stock

Conditional formatting visually highlights items that need attention. Set it up in three steps:

1. Select the Quantity column (C2:C100)
2. Go to Format > Conditional formatting
3. Set the rule: "Custom formula is" with =C2 <= D2
4. Choose a red background color and click Done

Now any item where quantity drops to or below the reorder point turns red instantly. You can add a second rule with a yellow background for items within 10 units of the reorder point using =C2 <= D2 + 10.

Email Notifications via Apps Script

For proactive alerts, you can use Google Apps Script to send email notifications when stock runs low. Go to Extensions > Apps Script and paste this code:

function checkLowStock() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
  var data = sheet.getDataRange().getValues();
  var lowItems = [];

  for (var i = 1; i < data.length; i++) {
    if (data[i][2] <= data[i][3] && data[i][0] !== "") {
      lowItems.push(data[i][0] + " (SKU: " + data[i][1] + ") - " + data[i][2] + " left");
    }
  }

  if (lowItems.length > 0) {
    MailApp.sendEmail(
      "[email protected]",
      "Low Stock Alert",
      "The following items need reordering:\n\n" + lowItems.join("\n")
    );
  }
}

Set a daily trigger (Edit > Current project's triggers) to run checkLowStock every morning. You'll get an email listing every product below its reorder point.

Importing Inventory Data from E-commerce Platforms

Most e-commerce platforms let you export inventory data as CSV files. The challenge is getting that data into Google Sheets cleanly, especially when files are large.

CSV Exports from Shopify, WooCommerce, and POS Systems

Shopify exports products as CSV with columns like Handle, Title, Variant SKU, Variant Inventory Qty, and Variant Price. WooCommerce uses a similar format. Square POS exports inventory with Item Name, Variation, Current Quantity, and Price.

Before importing, you may need to clean up the CSV:

• Use the CSV Duplicate Remover to eliminate duplicate SKU rows from partial exports
• Use the CSV Merger to combine inventory exports from multiple locations or platforms
• Map columns to match your tracker's format (Variant SKU to SKU, Variant Inventory Qty to Quantity, etc.)

For a detailed walkthrough on importing e-commerce CSV files to Google Sheets, check out our dedicated guide.

Bulk Updates with SmoothSheet

If you're dealing with large inventory exports (10,000+ rows from a busy Shopify store or a warehouse management system), the standard Google Sheets file import will either crawl or crash your browser.

SmoothSheet handles this by processing files server-side. Instead of your browser struggling with a 50MB CSV, SmoothSheet uploads and processes the file on its servers, then delivers the clean data directly into your spreadsheet. At $9/month, it pays for itself the first time you avoid a 30-minute browser crash during a stock update.

The typical workflow looks like this:

1. Export inventory CSV from your platform (Shopify, WooCommerce, Square)
2. Open your Inventory Tracker in Google Sheets
3. Use SmoothSheet to import the CSV file directly into a new tab
4. Use VLOOKUP or INDEX MATCH to pull updated quantities into your main tracker

Limitations and When to Upgrade

Google Sheets is excellent for inventory management up to a point. Here are the signs you've outgrown it:

• More than 5,000 active SKUs: Sheets slows noticeably, and formulas take seconds to recalculate
• Multi-warehouse tracking: Managing inventory across 3+ locations in a single spreadsheet becomes error-prone
• Barcode scanning: While possible through third-party Apps Script integrations, it's clunky compared to dedicated systems
• Real-time POS sync: Google Sheets can't automatically sync with point-of-sale systems in real time
• Audit trails: Version history exists but isn't designed for inventory audit compliance
• Multiple users editing quantities simultaneously: Merge conflicts can cause stock count errors

When you hit these limits, consider dedicated inventory software like inFlow, Sortly, or Cin7. Many of these tools support CSV export, so you can still use Google Sheets for reporting and analysis by importing their data with SmoothSheet.

That said, for businesses with under 5,000 SKUs, a single warehouse location, and a small team, Google Sheets handles inventory tracking better than most people expect.

Frequently Asked Questions

Can Google Sheets handle inventory for a small business?

Yes. Google Sheets works well for businesses tracking up to 5,000 SKUs with basic inventory needs like stock counts, reorder alerts, and supplier tracking. It becomes less practical for multi-warehouse operations or businesses needing real-time POS integration.

How do I set up low-stock alerts in Google Sheets?

Use an IF formula like =IF(C2 <= D2, "REORDER", "OK") to flag items below their reorder point. Combine this with conditional formatting to turn low-stock cells red, and optionally add an Apps Script email trigger for daily notifications.

What formulas are essential for inventory tracking in Google Sheets?

The four core formulas are: SUMIF for calculating stock value by supplier or category, COUNTIF for counting low-stock items, IF for generating reorder flags, and VLOOKUP or INDEX MATCH for pulling supplier details from a reference sheet.

How do I import inventory data from Shopify into Google Sheets?

Export your Shopify products as CSV from the admin panel (Products > Export). For small files, use File > Import in Google Sheets. For large catalogs with 10,000+ products, use SmoothSheet to import the CSV without browser crashes, then map the columns to your inventory tracker.

Conclusion

A well-structured Google Sheets inventory tracker can save you hundreds of dollars per month compared to dedicated software. With the right columns, formulas like SUMIF and COUNTIF, and conditional formatting for low-stock alerts, you get a system that's surprisingly powerful for daily inventory management.

Start by setting up the seven essential columns (product name, SKU, quantity, reorder point, supplier, unit cost, and location), add the IF formula for reorder flags, and layer on conditional formatting. As your catalog grows, use SmoothSheet to handle bulk CSV imports from your e-commerce platform without the browser crashes that come with large files.

Your inventory tracker doesn't need to be perfect on day one. Build the basics, use it for a week, and refine based on what your team actually needs.