All guides
Inventory guide

Free barcode scanner apps for Google Sheets, compared: what actually works

Barcode Sender, Orca Scan, Barcode to PC, GearChain, AppSheet, Google Forms, a USB scanner and a scanner link: what each does free, and where each stops.

By the QR to Sheets team 12 min readUpdated

Short answer

The genuinely free ways to scan stock into Google Sheets are a Google Form linked to a Sheet, which takes up to 500,000 responses per form, and a Google Apps Script web app with a JavaScript barcode library.

Free tiers of scanner apps break somewhere specific: Orca Scan keeps its Google Sheets integration for the Business plan and above, Barcode Sender is free only during its early access, and Google AppSheet scanning needs the Core or Enterprise plan.

QR to Sheets is free for 300 scans, one link and one device, then 7 USD per phone per month, so staff sharing four phones cost the same regardless of headcount.

Search for a free barcode scanner for Google Sheets inventory and you get two kinds of result: app store listings that are free to install but not free to use past a row limit, and tutorials for building your own. Both can be the right answer. Which one depends almost entirely on how many people are scanning and whether they have signal.

This guide covers the free routes properly, because for a lot of readers a free route is genuinely the correct choice. We build a paid tool in this category, and that bias is disclosed where it is relevant rather than hidden.

Route 1: a Google Form

Free, permanent, and available in about four minutes. Make a Form with a short-answer question, link responses to a Sheet, open the Form on a phone and tap the field. Most phone keyboards can invoke a scanner, and on Android the Google Lens button in the keyboard reads a barcode straight into the field.

  • Genuinely free, up to 500,000 responses per form, no trial.
  • Data lands in a Sheet you already own.
  • Anyone with the link can submit, with no account.
  • Breaks with no signal: a submission fails and that scan is simply gone.
  • One form per workflow, and respondents can edit their own responses unless you lock it down.
  • Every submission needs a tap into the field first, which is slow across a few hundred items.

The offline failure is the one that catches people out. Stockrooms, basements and metal-racked warehouses are exactly where signal dies, and a Form gives no warning that a submission was lost.

Route 2: an Apps Script web app

Also free, and far more capable. A small HTML page hosted by Apps Script, a JavaScript barcode library for decoding, and a script that appends to your Sheet. You control the whole thing and pay nothing beyond your existing Google account.

  • No per-user cost, ever, and no vendor to depend on.
  • You can build exactly the flow you want, including offline queueing if you write it.
  • You are now maintaining software. Camera permissions (since February 2026 some Apps Script web apps cannot open the camera inside Google's page), iOS quirks and library updates become yours.
  • Apps Script quotas apply, and debugging a failure while a count is happening is nobody's idea of a good afternoon.

This is the right call if you enjoy the work or already maintain scripts. It is the wrong call if the person who built it leaves and the stocktake still has to happen in April.

Route 3: free tiers of scanner apps

Plenty of mobile apps offer a free tier that writes to Sheets. Read the specific limit rather than the word free, because the limits differ in kind, not just size.

  • Row or scan caps that stop mid-count, which is the worst possible moment to discover them.
  • Per-user pricing after the free seat, so a second scanner costs as much again.
  • Google Sheets integration gated behind a paid tier while the free tier exports CSV only.
  • An install and often a linked Google account for every person scanning, which is the real cost with temporary staff.

Check whether the Sheets integration itself is on the free tier. It is common for a free plan to scan happily and then only offer a manual export, which is not the same thing at all.

Here is what eight named routes say about their own free tiers, with the case where each one is the better pick. Each vendor fact below was read on the vendor's own site, App Store listing or Google Workspace Marketplace listing on 2026-10-10, and anything a page did not state is marked as not stated rather than guessed. Prices and plans change, so check the page before you commit.

Free tiers as stated on each vendor's own page, read 2026-10-10; Google AppSheet re-read 2026-11-21. QR to Sheets is our product.
AppFree tier, as statedGoogle Sheets on the free tierInstall and account per person scanningWhere it wins
Barcode SenderDuring early access, every feature is free with no limitsYes: scans appear in Google Sheets the moment they happeniOS or Android app; sign in with GoogleFree with no limits today, for people happy to install an app on each phone
Scan to Sheets - QR & Barcode (iOS)Free download with in-app purchases, Starter Plan from 4.99 USDNot stated on the App Store listing130.6 MB iOS app, iOS 15.0 or later; Google sign-in, or a public spreadsheet without sign-inOne person on an iPhone who wants a native app
Orca Scan1 user and 1 sheet; the row cap is stated as 100 in the plan table and 50 in one FAQNo: Google Sheets integration is on the Business plan and above (Business is 99 USD a month or 79 USD a month billed annually)1 user on the free plan; iOS and Android appsOffline scanning on every plan, and a REST API and webhooks on Business
Barcode to PC300 total scans and 1 smartphone; its FAQ says the free plan lasts one monthGoogle Sheets output is ticked for the Free plan in its comparison tableA phone app that sends each scan to a computerTyping scans straight into whatever window is open on a computer, Excel included
GearChainFree of charge with paid features; prices not stated on the listingYes: inventory activity is recorded in Google SheetsMobile app from the App Store or Google Play, or its web appStock across several locations, with receiving, issuing and transfers
Google AppSheetExplore and test with up to 10 users at no cost; its help lists barcode scanning on the Core and Enterprise plans onlyYes: AppSheet apps connect to Google SheetsThe AppSheet mobile app, since scanning does not work in a browser, and a Core or User Pass licence per userA custom no-code app with forms, barcodes, signatures and photos on top of your Sheet; Core is 10 USD per user per month and included in most paid Google Workspace editions
Google FormsFree; Google's help states up to 500,000 responses per formYes: responses go to a linked SheetNone for the person submitting; no scanner of its ownNo cost and minutes to set up, for one person counting in signal
A USB or Bluetooth barcode scannerHardware bought once; no subscriptionTypes each code into the active cell of an open Sheet, with no timestamp unless you add oneA computer with the Sheet openFast scanning at a single desk
QR to Sheets (our product)300 scans in total, 1 scanner link, 1 deviceYesNone: a link in the phone browserMany people, including temporary staff, scanning on phones with no installs, priced per phone rather than per person
Free tiers as stated on each vendor's own page, read 2026-10-10; Google AppSheet re-read 2026-11-21. QR to Sheets is our product.

Barcode Sender states that every feature is free during its early access, with one condition to plan around: its site states that it "requires an internet connection" and that "Offline mode is on the roadmap". Orca Scan's free plan suits one person trying the app, but the Google Sheets integration sits on its Business plan. Barcode to PC is built around a computer: each scan is sent from the phone and typed into the active window. Google AppSheet is the most flexible of the list, but scanning needs the Core or Enterprise plan and every user is licensed; if your Google Workspace already includes AppSheet Core, that cost is already paid. The installed apps share one cost to weigh with temporary staff: every person scanning needs the app and usually a sign-in.

Where one person scans at a desk, a plain USB scanner with a short timestamp script is the cheapest route of all: the scanner types each code into the open Sheet, and the script writes the time beside it.

This is the category we build, so treat this section as informed and interested. The model is that the admin connects a Sheet once and shares a URL; whoever is scanning opens it in a normal phone browser with no install and no account. If the signal drops, the open scanner keeps saving scans on the phone and sends them when the signal is back. Inventory scanning into Google Sheets shows it on a stock count.

It is worth understanding the pricing shape rather than the number, because it is what differs. QR to Sheets is free for 300 scans, one link and one device, then $7 per phone per month with unlimited scans. Per-phone pricing means thirty temporary staff sharing four phones costs the same as four people. Tools priced per user charge for every person instead, which is the expensive shape for casual and seasonal labour.

Google Forms / Apps Script (DIY) compared with QR to Sheets
CapabilityGoogle Forms / Apps Script (DIY)QR to Sheets
Cost to startFree (Form or Apps Script)Free for 300 scans
Keeps scans when the signal dropsForm: no. Apps Script: only if you build itYes, while the scanner is open; sent when signal is back
Install for scannersNoneNone
Account for scannersNoneNone
Multiple scanners at onceYes, but no per-device attributionYes, per-device records
Who maintains itYouVendor
Where data livesYour Google SheetYour Google Sheet
Barcode Scanner to Google Sheets, No App: Full Tour with Pip (1:38, hosted by Pip). Pip tours route 4 in QR to Sheets: scanning from a phone's browser, repeat scans, lost signal, one code filling several columns, and the dashboard. It uses QR codes; barcodes scan the same way.Watch on YouTube Chapters and transcript

How to choose in one minute

  • One person, occasional counts, always in signal: use a Google Form and stop reading.
  • You maintain scripts and want zero vendors: build the Apps Script web app.
  • Several people scanning, or dead spots in the building, or you need to know who scanned what: a hosted scanner link earns its cost.
  • Thousands of items and a barcode-heavy operation: consider a real inventory system rather than a spreadsheet.

The mistake that costs the most

Overwriting quantities instead of appending scans. It feels tidier and it destroys everything useful: you can no longer tell when a discrepancy appeared, who counted a shelf, or whether an item was double-counted. Append one row per scan and derive the totals. Storage is free; history is not recoverable once you have thrown it away.

Step by step

  1. 1

    Decide what one scan has to mean

    A stock count, a goods-received line, or a movement between locations. The three need different sheets, and picking later means re-keying. Write the sentence down before choosing a tool.

  2. 2

    Try the genuinely free route first

    A Google Form with a short-answer field, opened on a phone, is free forever and works today. If your counts are small, occasional and always in signal, you may not need anything else.

  3. 3

    Find your breaking point

    Count how many people scan, whether they are in signal, and whether you need to know who scanned what. Those three answers, not features, decide whether free is enough.

  4. 4

    Keep the sheet append-only

    One row per scan, never edited. Derive current stock with a pivot or a formula. Overwriting a quantity column destroys the audit trail that makes a count defensible.

  5. 5

    Test with a dead phone signal

    Turn on airplane mode and scan five items. Whatever happens next is what will happen in your stockroom, and it is the single most useful five minutes of evaluation.

Frequently asked questions

What is the best free barcode scanner for Google Sheets?+

It depends on who scans. One person at a desk: a USB or Bluetooth scanner typing into the open Sheet, or a Google Form, both free. One person willing to install an app: Barcode Sender, which states every feature is free during its early access. Many temporary people on phones with no installs: a browser scanner link such as QR to Sheets, which we make, free for one phone and 300 scans, then 7 USD per phone per month.

Is there a genuinely free barcode scanner for Google Sheets?+

Yes. A Google Form linked to a Sheet is free (up to 500,000 responses per form), and an Apps Script web app with a JavaScript barcode library is free too. The Form loses scans with no signal, and the Apps Script route means you maintain the code. Neither has a hidden limit.

Why do free scanner apps stop being free?+

Usually a scan or row cap, per-user pricing after the first seat, or the Google Sheets integration itself being reserved for a paid tier while the free tier only exports CSV. Read the specific limit rather than the word free.

Can several people scan into the same Google Sheet at once?+

Yes with every route here. The difference is attribution: a shared Form cannot tell you which person submitted which row unless you add a field they might mistype, whereas per-device tools record it automatically.

What happens to a scan when the phone has no signal?+

With a Google Form the submission fails and the scan is lost with no warning. Tools that write to the device first keep working and sync later. Test this with airplane mode before you commit to anything.

Should I track stock levels or stock movements?+

Movements. Append one row per scan and derive the current level with a formula or pivot. A single overwritten quantity column cannot tell you when a discrepancy appeared or who counted what.

Do I need barcode labels, or can I use what is already on the box?+

Manufacturer barcodes work fine for retail goods and are one less thing to print. Print your own only for items with no barcode, or where you need an internal ID that survives repackaging.

Try it on your own Google Sheet

Connect Google, create a scanner link, and open it on the phone that will scan. Have that phone at hand: setup takes a few minutes and ends with your first row in the Sheet. Free covers 300 scans on one phone, and the people you scan never install anything.

Start for free

No credit card required

A second door, booth or classroom is a second phone

Free covers one phone and one scanner link. Premium lets several phones scan at the same time, one per door, booth or classroom, into the same Sheet: $7 per phone per month. Running several classes, events or lists from one phone? Premium on that one phone is $7 a month, with a separate scanner link for each. Paid yearly, it is $70 per phone per year (2 months free).

How many phones will scan at the same time?

$7 x 2 = $14 a month

Sign in with Google and, on the free plan, the billing page opens with this choice. Nothing is charged until you confirm the card checkout, and you can change the number of phones later.

Keep reading