Guide
How to print labels from Google Sheets
For private product, order or contact data, download a CSV or spreadsheet file and import it locally. Link import is available only for sheets already intended for anyone-with-link access. Choosing a tab does not make other tabs in a shared spreadsheet private.
- 1
Choose a private import
Download and import a file, or paste the needed cells. Do not make a private sheet accessible to anyone with the link. Use link import only for data already intended for that sharing setting.
- 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
- Use file upload or paste for private sheets. Link import is only for sheets already intended for anyone-with-link access; do not widen sharing on a private order or customer sheet.
- 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 a code for its value. Test representative printed samples.
More guides
Ready to print?
Design locally without an account. Replace sample content, preview and test your printed output.