Skip to content
FROM STOCK ROWS TO EVERYDAY ACTIONS

Spreadsheet to inventory app.Try stock edits with sample data.

Explore a spreadsheet to inventory app with four sample products: search by SKU, edit a quantity, check low stock, and download the source CSV. This browser-only demo needs no sign-in and resets on reload; a real connected app uses approved Google Sheets data.

Google Sheets as your database Code you can inspect
Build with your own spreadsheet
INTERACTIVE EXAMPLE · SAMPLE DATA

Stock room

Download sample CSV ↗
4 products2 need reorder77 units in stock
Sample inventory. Change a stock quantity to update the reorder status.
Product / SKUIn stockReorder atStatus
House blendCOF-0110Reorder
Green teaTEA-028In stock
Ceramic mugCUP-036Reorder
Paper filtersFIL-0415In stock

Sample changes stay in this tab and reset on reload. This example does not connect to Google Sheets. In your own app, approved stock edits can be written to your connected sheet.

A FAMILIAR FOUNDATION
Keep business data in Sheets
Review access before sharing
Build and refine with AI

How to try the inventory app

  1. Type a product name or SKU in Search sample products to narrow the table.
  2. Select Low stock only to show products at or below their reorder level.
  3. Change an In stock quantity to update the stock total and reorder status.
  4. Click Reset to restore the sample, or Download sample CSV to inspect the four original rows. Demo edits stay in this tab and are not saved to the CSV.

Questions before you build

Can I track inventory from my phone?

You can open the sample and published web apps in a phone browser. The sample covers quantities and reorder levels; describe any purchase dates, sale prices, or other fields you need when building your own app.

Can I filter stock without rearranging the spreadsheet?

Yes. In this sample, Search sample products and Low stock only change the visible rows without rearranging the data. For your own app, request the filters you need and verify them in the private preview.

Does the example keep an inspection or stock-change history?

No. The sample stores only its current quantities in this tab and resets on reload. It has no inspection history or immutable audit log; use a system designed for those requirements if you need auditable records.

Can the app show when it is time to restock?

The sample marks a product for reorder when Quantity is less than or equal to ReorderLevel. Low stock only displays those products; the demo does not send email alerts or place purchase orders. Describe any notification workflow separately when building your own app.

Can I track the same product in different locations?

The sample has one stock quantity per SKU and no location field. For your own app, define a row for each product-location combination and request location filters; verify that editing one location leaves the others unchanged before using it for stock counts.

Does the example support barcode scanning?

No, the example provides text search and manual quantity editing, not a barcode scanner. If scanning or offline warehouse work is essential, evaluate and test a system that explicitly supports your scanner, devices, and connection conditions.

Give every stock record a clear meaning

The sample CSV has four fictional products and four columns: SKU, Product, Quantity, and ReorderLevel. SKU identifies a product; Product gives people a readable name. Quantity is the count currently on hand, and ReorderLevel is the threshold that marks a row for attention. The starting dataset has 77 units, with two products at or below their reorder level.

For your own sheet, decide what a unit means before making totals. A box of twelve and a single item should not both count as “1” without a clear rule. Keep product identifiers stable and distinct, even if names change. If stock is split across locations, decide whether each row represents a product or a product at one specific location; the four-row demo uses only one quantity per product.

You can check the sample’s rule directly: change House blend from 8 to 11 units and it no longer needs reorder because its threshold is 10. Set it back to 10 and it needs reorder again. These are fictional test values. Download sample CSV always gives you the original four rows, not an export of edits made in the browser.

Turn a stock count into a focused daily task

For a small stock room, a useful first app can answer three questions: what is this item, how many are on hand, and which items need attention? The example supports that narrow workflow with product/SKU search, editable quantities, and a low-stock filter. Search and filtering change what you see; they do not move the underlying rows or create a separate stock list.

The quantity field sets an absolute count. Entering 3 means “there are now three units,” not “add three units” or “remove three units.” That distinction matters when planning a receiving or picking screen. If you need movement history, specify separate receipt and issue records and how they should affect the current balance; the sample has no movement ledger.

An illustrative prompt is: “Build a stock-count app from this sheet. Search by SKU or product name, show products at or below ReorderLevel, and let authorized editors set Quantity after a physical count. Show total units and keep formula cells read-only.” This describes a desired workflow, not a prebuilt template. Test unknown SKUs, zero stock, and a quantity exactly at the reorder threshold in your generated app.

Connect real stock data and verify one controlled edit

Choose Google Sheets to app if your team already maintains a stock sheet. Use Excel to app conversion if you have a local workbook or CSV; uploads become Google Sheets in your account, and later changes to the original local file do not sync. Either route requires sign-in, Google connection, and review of the data the app can use.

Begin with a copy containing disposable test products. In Data settings, approve only the tables and columns required for stock work. Permit quantity editing only where intended and keep confidential columns out of shared data. In the private preview, change one known quantity, confirm the intended row changed in the connected sheet, and verify that a workspace viewer cannot make the same edit.

Then check an edit from the sheet back into the app after refreshing. Reads use a short cache, so the interface should not be treated as instantaneous proof of physical stock. Test the workflow on the devices your team actually uses before publishing. The spreadsheet to app builder can start from your chosen file or link; the demo above itself never connects to your inventory.

Recognize when a stock dashboard is not enough

A visible reorder flag is a cue for a person to act. The demo does not send an email, create a purchase order, reserve inventory, or synchronize orders from a sales channel. If those actions are part of your operation, describe each trigger and outcome explicitly, then check whether the resulting system implements it. Do not assume that a stock screen includes the surrounding inventory processes.

The sample also has no barcode scanner, location transfers, inspection history, or immutable audit log. For a location-based workflow, you need clear product-location records and a way to verify both sides of a transfer. For offline warehouse use, the system must handle disconnected changes and recovery; opening a web app on a phone does not establish those capabilities.

Consider a dedicated inventory system when fulfillment depends on reservations, strict concurrent updates, traceable stock movements, or reliable offline scanning. This platform does not promise database transaction isolation, and the current data gateway does not isolate different users’ rows within a shared table. A small, reviewed stock-count workflow can be a reasonable starting point; an operationally critical warehouse system needs requirements and tests beyond this demonstration.