How to print labels from Google Sheets
Keep your product or order list in Google Sheets and print labels from it without exporting CSVs: paste the sheet's share link and BarcodeStack fetches the rows — including a specific tab if your URL has a gid.
- 1
Share the sheet
In Google Sheets: Share → “Anyone with the link” (Viewer is enough).
- 2
Paste the link
Import data → Google Sheets → paste the URL → Fetch. A #gid=… in the URL targets that tab.
- 3
Map and merge
Headers become {{placeholders}}; drop them into text and barcodes.
- 4
Export
One PDF with a label per row — rerun the import any time the sheet changes.
Good to know
- If fetching fails, the sheet is still private — the share setting must be “Anyone with the link”.
- Print one label and test-scan any barcode before running a full batch.
Sizes used in this guide
Frequently asked questions
- Does it update live?
- Imports are a snapshot — re-fetch after editing the sheet to pull the latest rows.
- Can barcodes use a sheet column?
- Yes — put {{SKU}} (or any column) as a barcode's value and every row renders its own scannable code.