How to Generate Bulk QR Codes in Google Sheets & Print Avery Labels
Deprecated Google Chart APIs breaking your sheet formulas? Learn how to generate 1,000+ vector QR codes and barcodes in Google Sheets and print Avery labels.
Whether you manage an e-commerce warehouse, organize event badge credentials, track asset equipment, or label physical retail inventory, Google Sheets is often the central source of truth for your product data.
Your spreadsheet contains hundreds or thousands of rows: Product SKUs, serial numbers, inventory locations, and landing page URLs.
To make those items scannable in the real world, you need two things:
- High-resolution, error-free QR codes or barcodes placed directly in your spreadsheet.
- A fast way to format that tabular data into standard Avery peel-and-stick labels without manually copying text into Microsoft Word or external template builders.
For years, spreadsheet power users relied on a popular workaround: using =IMAGE("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & A2) to pull QR images from Google's servers.
However, in 2026, the Google Chart Infographics API is deprecated and unreliable. Formulas fail with broken image boxes, rate limits trigger during bulk operations, and there is no way to format those codes into printable Avery sheets.
Below is an engineering guide to generating bulk QR codes and linear barcodes natively inside Google Sheets, and printing perfect Avery label sheets in under two minutes.
Why the Old Google Chart =IMAGE(...) Hack is Dead
If you have spreadsheets that previously used the Google Chart API URL, you have likely run into several severe limitations:
1. Deprecated Endpoint & Broken Image Boxes
Google officially deprecated the Infographics Chart API. While simple calls may intermittently resolve, spreadsheets with more than fifty rows frequently fail. The =IMAGE() formula renders empty cells or grey broken-image icons because Google's backend throttles repeated automated requests.
2. Zero Barcode (Code 128 / UPC) Support
The legacy Google Chart API was designed strictly for basic QR matrices and chart plots. It cannot generate standard linear barcodes like Code 128, EAN-13, or UPC-A, which are mandatory for retail point-of-sale (POS) systems and warehouse hand scanners.
3. The Label Printing Formatting Nightmare
Even if you manage to render 100 QR codes in Column C, printing them onto standard Avery label sticker paper is notoriously difficult. Google Sheets was designed for tabular accounting calculations, not print page layouts. Margin drift and cell padding cause labels on rows 5 through 10 to drift out of alignment with the physical adhesive stickers.
[Legacy Spreadsheet Hack]
Spreadsheet Row ➔ External chart.googleapis.com API ➔ Rate Limit Error (Broken Box) ➔ Manual Word Copy-Paste
[Modern Client-Side Add-on (QR Code & Label Generator)]
Spreadsheet Row ➔ Local HTML5 Canvas (< 2ms) ➔ Direct Vector Insertion ➔ 1-Click Avery 5160 Print Preview
Technical Comparison: Formula Hacks vs. Dedicated Add-on
| Capability | Google Chart =IMAGE() |
External QR SaaS (Websites) | QR Code & Label Generator for Google Sheets |
|---|---|---|---|
| API Status | Deprecated / Throttled | Third-Party SaaS | Native Google Workspace Add-on |
| Speed (500+ Items) | 30s to 60s (Laggy) | Manual CSV Export/Import | < 2 Seconds (HTML5 Canvas) |
| Linear Barcodes (Code 128) | No | Paid Tier Only | Yes (Built-in QR & Code 128) |
| Printable Avery Labels | No (Severe drift) | Paid Software Required | 1-Click Avery 5160 & 5163 Templates |
| Data Privacy | Sent to Public Cloud | Third-Party Server Storage | 100% Client-Side (CASA Exempt) |
| Google Document Security | Broad Access | Full Account Access | spreadsheets.currentonly (Minimal Scope) |
| Pricing | Free (Broken) | $15 to $40 / month | 50 Codes/mo Free / $34.99 Lifetime |
3 Core Capabilities of the Modern Workspace Engine
QR Code & Label Generator for Google Sheets™ was built from the ground up as a native Google Workspace Add-on to replace legacy formula hacks.
1. Ultra-Fast Client-Side Generation (< 2ms per Code)
Instead of pinging remote servers over HTTP, the add-on runs a compiled HTML5 Canvas rendering engine directly within the Google Sheets sidebar sandbox.
- Generates 1,000+ vector QR codes or Code 128 barcodes in less than two seconds.
- Zero network latency, zero rate-limiting headers, and zero API quota caps.
2. 1-Click Direct Spreadsheet Insertion
You can choose how you want codes added back to your sheet:
- Formula Mode: Inserts clean
=IMAGE("data:image/png;base64,...")formulas directly into adjacent columns. - Floating Over-Cell Images: Places high-resolution vector images directly over cell coordinates for custom dashboards.
3. Ready-to-Print Avery 5160 & 5163 Label Layouts
Never fight with margin rulers again. The add-on includes calibrated print stylesheets designed to match standard commercial sticker sheets:
- Avery 5160 / 8160 (30 Labels per Sheet): 1" x 2-5/8" standard address and inventory labels (3 columns x 10 rows).
- Avery 5163 / 8163 (10 Labels per Sheet): 2" x 4" shipping, bin location, and asset tags (2 columns x 5 rows).
- Automatic text wrapping: Pairs the QR code with the product title, SKU string, and price in a clean, legible card layout.
Step-by-Step: Generate 100 QR Codes & Print Labels in 60 Seconds
Follow these four steps to convert any spreadsheet into scannable labels:
Step 1: Install the Add-on from Google Workspace Marketplace
Open your browser and install the verified add-on:
Because it utilizes minimal non-sensitive OAuth scopes (spreadsheets.currentonly), installation completes in two clicks with zero administrative security blockers.
Step 2: Open Your Google Spreadsheet & Launch Sidebar
- Open any existing spreadsheet (or create a fresh one at
sheets.new). - Ensure your sheet has columns for your data (e.g., Column A:
Product Title, Column B:SKU / URL). - In the top Google Sheets menu bar, click:
Extensions→QR Code & Label Generator for Google Sheets™→Open Sidebar.
Step 3: Configure Your Code Type & Range
- In the sidebar, select your target data column.
- Choose your code format:
- QR Code: Ideal for website URLs, customer feedback forms, Wi-Fi logins, and digital menus.
- Code 128 Barcode: Ideal for alphanumeric warehouse SKUs, serial numbers, and asset tracking tags.
- Click "Insert Codes to Sheet" to watch the adjacent column populate with sharp, scan-ready codes in real time.
Step 4: Preview & Print Avery Labels
- Click "Print Avery Label Sheet" in the sidebar.
- Choose your layout (Avery 5160 or Avery 5163).
- The add-on opens a print-calibrated browser window displaying your labels formatted to exact millimeter dimensions.
- Press
Cmd + P(Windows:Ctrl + P), set Margins to "None" (or 0), select your paper size (Letter / A4), and send directly to your label printer.
Enterprise Privacy & Security Guarantee
In corporate supply chain and logistics operations, spreadsheet rows frequently contain unreleased product codes, internal asset serial numbers, and private server links.
QR Code & Label Generator was engineered under strict zero-trust standards:
- 100% Client-Side Execution: All code generation happens locally inside the user's browser runtime.
- Zero Third-Party Data Transmission: Spreadsheet cells, SKUs, and generated codes are never transmitted to external databases or analytics brokers.
- Minimal OAuth Permissions: The add-on requests access strictly to the active open document (
spreadsheets.currentonly). It has zero access to your Google Drive files, emails, or personal contacts.
Conclusion: Upgrade Your Spreadsheet Workflow Today
Stop relying on deprecated =IMAGE() hacks that render broken image boxes. Stop manually exporting CSV files to third-party label software just to print a handful of stickers.
With native client-side barcode generation and calibrated Avery templates, you can turn any Google Spreadsheet into an automated labeling engine in seconds.
Install QR Code & Label Generator on Google Workspace Marketplace →
Frequently Asked Questions
Why does the old =IMAGE("https://chart.googleapis.com/chart?...") formula fail in Google Sheets?
Google deprecated and turned down the legacy Google Chart Infographics API. Complex formula calls to chart.googleapis.com frequently trigger rate-limiting HTTP 429 errors or render as broken placeholder boxes.
Can I generate linear Code 128 barcodes as well as 2D QR codes in Google Sheets?
Yes. QR Code & Label Generator for Google Sheets supports both 2D QR matrices (for URLs, contact cards, and text) and linear Code 128 barcodes (for inventory SKUs and warehouse logistics).
Does generating QR codes require sending spreadsheet data to an external server?
No. The add-on processes all QR and barcode generation 100% client-side inside your browser sandbox using HTML5 Canvas. Your confidential spreadsheet data never leaves Google Workspace.
What Avery label formats are supported for direct printing?
The add-on includes native formatting for standard peel-and-stick templates including Avery 5160 (30 labels per sheet, 1 x 2-5/8 inches) and Avery 5163 (10 shipping labels per sheet, 2 x 4 inches).
Amazon Sourcing & Analytics
Algorithmic BSR estimation, bulk ASIN extraction, competitor scraping, and 250-byte backend optimization.