Managing inventory is a headache for small businesses. Scribbling on clipboards leads to errors, and dedicated software costs $50+ per month. But did you know you already own the most powerful inventory tool? It's Google Sheets.
Why Google Sheets + QR Codes?
Combining the flexibility of spreadsheets with the physical utility of QR codes creates a "phygital" (physical + digital) system.
- Zero Cost: No monthly subscriptions.
- Cloud Synced: Your team can check stock from their phones anywhere.
- Customizable: Track exactly what *you* need (Expiry dates, Location, Supplier).
Step 1: Structure Your Database
Open a new Google Sheet. This will be your "Master Inventory". Create the following header columns in Row 1:
Fill in your product details. For the QR Data column, you can either put the unique SKU
(e.g., SKU-101) or, for advanced users, a link to a Google Form to update that stock item.
Step 2: Generate the Labels (The Magic Part)
This is where most people get stuck. How do you turn a spreadsheet into printable stickers? You don't want to copy-paste into a website 100 times.
The solution is the Bulk QR Code Generator add-on.
Automate this step
Don't create codes manually. Our tool generates thousands of codes directly inside your sheet in seconds.
Install Free Add-on- Install and open the add-on from Extensions > Bulk QR Code Generator.
- Select your "QR Data" column as the source.
- Choose a label template (e.g., "Avery 5160" for stickers) or standard images.
- Click Generate.
The tool will create a new sheet with perfect, printable layouts containing your QR codes and item names.
Step 3: Managing the Flow
Print your labels and stick them to your shelves or boxes. Now, when an employee needs to check the stock:
- 1 They open the Google Sheets app on their phone.
- 2 Scan the code (or use the search function).
- 3 Update the "Stock Level" cell directly.
Pro Tip: Using Google Forms for Check-In/Out
If you don't want people editing the sheet directly, create a Google Form called "Stock Update".
1. Get the "Pre-filled link" for the Form.
2. Use a formula in Sheets to insert the Item Name into that link.
3. Generate QR codes from that link.
Now, scanning the QR code opens a Form pre-filled with "Drill Bit Set". The user just types "Checked Out" and hits submit. Safe, secure, and timestamped.