Google Sheets Configuration
Get a free key at console.cloud.google.com
→ APIs & Services → Credentials → Create API Key
Then enable Google Sheets API for your project.
Then enable Google Sheets API for your project.
Found in your Google Sheets URL: docs.google.com/spreadsheets/d/[ID HERE]/edit
The sheet containing your item catalog (itemid, itemname, itembarcode, itemprice, itemmanifest)
Scan records will be appended here. Must have columns: scanningid, scanningdate, barcode, itemname, count, itemprice, itemmanifest
Sheets Setup Guide
Step 1: Import your ITEMS.xlsx into Google Sheets
Step 2: Make the sheet publicly readable: Share → Anyone with link → Viewer
Step 3: For writing scans, you need a Service Account with editor access, OR use a Google Apps Script Web App as a proxy
Step 4: Enter your credentials above and click Connect
Step 2: Make the sheet publicly readable: Share → Anyone with link → Viewer
Step 3: For writing scans, you need a Service Account with editor access, OR use a Google Apps Script Web App as a proxy
Step 4: Enter your credentials above and click Connect
1
QTY
Current Session
No items in session yet.
Start scanning to add items.
Start scanning to add items.
All Scanned Items
No items in session yet.
Load history from Google Sheets