kutorlabs
Guides••4 min read

Create Code 128 Inventory Barcodes in Google Sheets (Bulk)

Legacy chart APIs cannot generate linear Code 128 barcodes for SKUs and scanners. Batch-generate scan-ready inventory barcodes in Google Sheets.

By Kutor Labs Workspace Engineering

If you run an e-commerce warehouse, prep FBA/3PL shipments, or track IT hardware inside Google Sheets™, your master sheet already holds every SKU, serial number, and bin location.

The friction starts the moment you try to turn Column B (SKU / Barcode) into scannable linear barcodes.

Old chart.googleapis.com formulas only drew QR codes and now fail intermittently due to API deprecation. Meanwhile, installing a "barcode font" like Libre Barcode 128 inside Google Sheets™ leads to a subtle trap: raw text formatted in a Code 128 font is unscannable by laser handhelds unless you first run an Apps Script checksum calculator to prepend Start-B, modulo-103 check digits, and Stop symbols. And if a warehouse tablet opens the sheet without that custom font cached cleanly, the barcode turns back into gibberish.

Generating proper Code 128 image barcodes directly from your selected column solves both encoding accuracy and cross-device scanning.


Code 128 vs. QR Codes: Which One Does Your Scanner Expect?

Criterion Code 128 (1D Linear Barcode) QR Code (2D Matrix)
Primary Hardware Handheld laser scanners, USB 1D guns, POS checkouts Smartphone cameras, 2D CMOS imagers
Best Payload Alphanumeric SKUs (SONY-WH1000-BLK), bin codes, serial IDs Full URLs (https://...), vCards, multi-line payloads
Label Geometry Wide horizontal strip—fits narrow shelf edges & product boxes Square block—fits square stickers & flyers
Error Checking Mandatory modulo-103 check digit Configurable Reed-Solomon error correction (Level M)

In practice, teams need both: Code 128 for shelf bins, SKUs, and packing slips; QR codes for asset portal links and customer manuals.


Why Atomic Batch Generation Beats Manual =IMAGE() Formulas

Writing =IMAGE(...) formulas by hand across 300 rows means dealing with ENCODEURL() escaping, header row offsets, accidental formula overwrites when two teammates edit the sheet, and mismatched column alignment.

QR Code & Label Generator for Google Sheets™ handles the entire pipeline cleanly from the Google Sheets™ sidebar:

  1. Instant Live Canvas Preview: Before writing anything to your sheet, the sidebar renders the first selected SKU locally using JsBarcode (CODE128 format with human-readable SKU text printed underneath) so you can verify readability immediately.
  2. Header-Aware Range Parsing: Toggle First row is header (skip Row 1) and pick your exact source column without manually slicing ranges.
  3. Concurrency-Safe Atomic Write: Clicking Insert Codes to Sheet executes a single batch formula write guarded by Google Apps Script's LockService (withDocumentLock), preventing race conditions when multiple team members work in the same inventory sheet.
  4. 1-Click Sample Dataset: Testing on a blank sheet? Click + Sample Data to populate 5 realistic product and SKU rows (IPHONE-16P-256, SONY-WH1000-BLK, LOGI-MX3S-GRY, etc.) so you can verify your scanner workflow in seconds.

Step-by-Step: Generate Bulk Code 128 Barcodes in Google Sheets™

  1. Install the Add-on: Add QR Code & Label Generator for Google Sheets™ from the Google Workspace™ Marketplace. It uses strictly spreadsheets.currentonly and script.container.ui (CASA Tier 2 exempt).
  2. Open the Sidebar: Select your SKU column (or range of columns), then click: Extensions → QR Code & Label Generator for Google Sheets™ → Open Generator (Full walkthrough available in the Quick Start Guide.)
  3. Select Barcode 128 & Preview: Choose Barcode 128 under Code Format, confirm your source column and header checkbox, and inspect the live preview.
  4. Insert or Print:
    • Click Insert Codes to Sheet to populate scannable Code 128 barcodes into the adjacent column.
    • Or click Print Avery Label Sheet to open a dedicated 3-column print-ready sheet pairing each product title with its barcode.

Minimal Access, Clear Limits

Free users can batch-generate or print up to 50 rows per batch with no watermarks. Upgrading to Pro ($19/year or $34.99 one-time Lifetime) unlocks unlimited bulk batches for large warehouse catalogs.

If you also need QR codes or run into sticker alignment drift when printing sheets directly from Google Sheets™, read our companion guides on bulk QR codes and Avery labels and fixing Avery 5160 label margin drift.

Install QR Code & Label Generator from Google Workspace™ Marketplace →

Filed under:#Google Sheets#Barcode Generator#Code 128#Inventory Management#SKU Labels#Workspace Add-ons

Frequently Asked Questions

Why choose Code 128 barcodes over QR codes for warehouse inventory?

Most handheld laser warehouse scanners and retail POS systems are built for 1D linear barcodes. Code 128 compactly encodes alphanumeric SKUs, bin locations, and serial numbers (like IPHONE-16P-256) with built-in checksum verification.

Why do barcode font tricks like Libre Barcode 128 fail on shared spreadsheets?

Code 128 requires strict start characters, check-digit math, and stop symbols. Simply applying a barcode font to raw SKU text produces unscannable bars unless an encoder calculates the checksum first.

Can I preview a Code 128 barcode before writing formulas across hundreds of rows?

Yes. The sidebar renders a live HTML5 Canvas preview via JsBarcode for the first selected item before batch-writing atomic =IMAGE(...) formulas into the adjacent column.

How many rows can I generate for free?

You can generate and print up to 50 rows per batch completely free with zero watermarks. Pro removes the batch ceiling for $19/year or a $34.99 one-time lifetime license.