No PC or Mac client
iPhone or Android plus WiScanner is enough. Ideal for pop-up counts, market stalls, and back rooms without a fixed workstation.
Product feature
Scan barcodes straight into Google Sheets — no computer required
Connect your Google account once, choose or create a Drive folder, then scan with your phone. WiScanner writes each barcode as a row in Google Sheets over the Google API — no PC client, no keyboard wedge, no desk setup on the warehouse floor.
Phone-only workflow
Your phone is the whole scanning station
Many teams still drag a laptop to the aisle so scans can land in a spreadsheet. With Google Sheets direct mode, the phone talks to Google in the cloud. You never open the desktop app, never pair over WiFi to a PC, and never wait for a computer to wake up.
Google API connection
Authorize your Google account in the app. WiScanner creates or updates spreadsheets in the folder you specify — not a manual export at the end of the day.
Live rows in Sheets
Each scan appends to the sheet while you walk. Share the file with finance or ops and they see the same numbers in real time.
Your folder, your rules
Create a fresh folder per project or type an existing Drive folder name so files stay where your team already looks.
Setup
How Google Sheets scanning works
Three steps in the app — then you are scanning into a shared spreadsheet.
-
1
Connect your Google account
Sign in with Google inside WiScanner and allow access to create or update files in Drive. You stay in control of which account owns the spreadsheets.
-
2
Create a folder or enter a folder name
Start a new folder for this count or receiving run, or type the name of a folder that already exists in your Drive — for example WiScanner Counts or Warehouse 2026.
-
3
Scan — rows appear in Google Sheets
Open a scan group, read barcodes with the camera, and WiScanner pushes each value to the spreadsheet via the API. Barcode, time, and quantity (if enabled) land as new rows automatically.
What you get
Structured data in Google Sheets
Every session produces a spreadsheet your team can filter, pivot, or import into Shopify, WooCommerce, or an ERP — without retyping from paper.
Barcode column
The decoded value from each successful scan — EAN, UPC, Code 128, QR, or your internal SKU.
Timestamp
Know exactly when each item was read — useful for audits and shift handovers.
Quantity mode
Attach a count when the same SKU appears many times on a shelf or pallet.
Shared access
Because the file lives in Google Drive, colleagues with permission can open the same Sheet on any device.
Choose your path
Google Sheets direct vs PC keyboard wedge
WiScanner supports both workflows. Pick the one that matches where you work.
| Google Sheets (API) | PC client (local WiFi) | |
|---|---|---|
| Computer needed | No | Yes — Windows or Mac |
| Where data lands | Google Sheet in your Drive folder | Active cell in any app on the PC |
| Internet | Required for API sync | Not required for scanning |
| Best for | Aisle walks, no desk, team visibility in Sheets | ERP, Excel desktop, legacy software |
Also compare: scan into Sheets via PC · phone inventory counts · all features
FAQ
Google Sheets scanning questions
No. Google Sheets direct mode runs entirely from the WiScanner app on your phone. You do not install or run the desktop client.
After Google sign-in, WiScanner uses the Google API to create or update a spreadsheet in your chosen folder. Each scan becomes a new row with barcode and metadata.
Yes. Enter the folder name you already use, or let WiScanner create a new one for this job.
No. Google Drive and Sheets export works on every plan, including the free 100 scans. See pricing for scan packs and Pro.
Yes. You can scan into Sheets live and still use CSV, FTP, or webhooks for other groups. See export documentation.
Scan into Google Sheets from your pocket
Connect Google, pick a folder, and start scanning — no computer on the floor.