InventoSheet – A Simple light WMS Built on Google Sheets 

Scan barcodes with a Bluetooth scanner and keep your stock updated in Google Sheets — without heavy WMS software or expensive licenses. 

🟩With Inventosheet, you can:

• Register products by scanning their barcodes into Google Sheets
  (products are identified by their barcode — the app does not create a separate product catalog)
  
  

• Add missing items directly from the phone when receiving goods
  by scanning their barcode and assigning quantity, location and category.
  
  

• Assign barcodes to locations, shelves and zones
  so stock can be tracked physically inside the warehouse
  
  

• Move and regroup stock between locations
  even when several operators are scanning at the same time
  
  

• Pick products for orders
  and automatically update stock across all operators
  
  

• Run shared inventory counts
  with multiple people scanning in parallel
  
  

• Generate stock movement logs in Google Sheets
  (who scanned what, where, and when)
  
  

• Print simple order or packing summaries via Bluetooth
  
  

All data is stored in Google Sheets, so it can be viewed, shared, filtered and audited by anyone with access.

🟨 How it is used

Each operator uses a barcode scanner connected to their phone.
The app records who scanned what and when, so stock movements can be traced and reviewed — not for surveillance, but to keep stock accurate and avoid mistakes.

🟧 What it is NOT

Inventosheet is not a full ERP or a heavy WMS.
It focuses only on one thing: making warehouse stock accurate, shared and easy to update using barcode scans and Google Sheets.

🟧Limitations & Requirements

Inventosheet is designed to operate with coded locations (shelves, classes, zones, etc.) using scannable tags.
Without these location codes, most features (location tracking, put-away, multi-zone inventory, history) cannot work.

🔷 1) Location codes are mandatory

Shelves, classes, and zones must be identified by scannable codes containing tags (special characters placed before and/or after the code(you define them), different from digits).
These tags allow the application to recognize that a scanned code represents a location and not a product.

If your locations are not encoded with these tags, the application cannot distinguish a location from an item.
In that case, Inventosheet becomes a simple product scanner with no location tracking.

🟢 2. Workshop storage

Products are assigned to a physical location.
Items are scanned and stored on shelves, racks, or zones inside the warehouse.

🟡 3. Team inventory

Stock is verified and counted by multiple operators.
Team members scan products at the same time and write inventory logs into the shared Google Sheet.

🔴 5. Picking

Products are taken out of stock for orders or transfers.
Scanning items automatically updates quantities in the inventory.

🟣 6. Solo partial inventory>not on google all local

One operator can run an independent stock check.
Products are scanned into a local ODS or XLSX file, allowing the operator to keep a separate record to review, audit, or compare with the shared Google Sheets inventory.

⚫ 7. Custom checkout mode (offline)
Barcodes can be scanned to build a quick summary of items taken, sent, or used.
The list can be printed on 56 mm or 80 mm thermal printers or saved locally.

⚠️ This is not an official POS system.
InventoSheet does not handle taxes, fiscal compliance, certified accounting, or legal receipts.

🟩  Download

Inventosheet is available on Google Play (early access).

Because the app is still in active development, Google requires users to be registered before they can install it.

To get access:

1️⃣ Send your Google Play email address to
📧 guillaume1745@gmail.com (that's me)

2️⃣ You will be added to the tester list

3️⃣ Once registered, you can install Barcode2Sheet from the Google Play link