Print labels from Google Sheets with BarcodeMan
Turn spreadsheet rows into label PDFs with the BarcodeMan add-on. Set up a template, choose rows and quantities, review problems, and print at actual size.
On this page
Use the BarcodeMan add-on to turn rows in your Google Sheets spreadsheet into a PDF of labels. Start with a few rows, check the PDF, and print a small sample before using a full sheet of labels. You do not need an online store or an API key.
The steps
- Open BarcodeMan in the Google Sheets side panel, using the Google account that should own your templates and plan.
- Prepare your worksheet: put unique column names in row 1 and one item in each row below it.
- Create a label template on paper that matches your labels, and connect its fields to your column names.
- Choose the rows and label quantities under Print settings.
- Check the data and generate a PDF.
- Open, download, and print the PDF.
Check the data and generate a PDF
- Check the selected template, Rows, Label quantity, and Skip used label positions.
- Choose Print labels. BarcodeMan reads and checks the current data.
- If the small batch has no problems and has labels to print, PDF generation starts immediately.
If Data review appears, read the row and label counts and any problems above the template section. Missing columns or no printable labels must be resolved before a PDF can be generated.
Use Go to row to find a problem in the worksheet. Correct its value or fix a missing header, then check again. Go to row changes your selection, so reselect the intended batch if you use Selected rows.
When some rows are invalid but others can print, the Print N labels button shows how many labels can be made. Choose it only if you want to print the valid labels and skip the problem rows. Invalid quantities and barcodes are not automatically corrected.
If you change data, the selection, the template, or settings after the review, BarcodeMan checks again before creating a PDF. Review the new count and choose Print N labels to confirm it. For larger selections that require several reading steps, follow the sidebar prompts and keep the worksheet, filters, selection, template, and settings unchanged through the final check.
If loading fails, follow the error’s recovery controls and check the saved settings shown before continuing. Refresh reloads the sidebar. Do not assume a choice clicked while an earlier operation was still processing was saved.
Open, download, and print the PDF
- While the job is waiting or processing, choose Check PDF status to see whether it is ready. Do not start a second print for the same batch while the first is pending.
- On Your PDF is ready, check the label count, page count, paper size, and any skipped worksheet rows.
- Choose Open PDF. The PDF opens in a new browser tab.
- Use the PDF viewer’s download control to save a copy, or its print control to open your computer’s print dialog.
- Choose paper matching the PDF page size. Set the scale to 100% or Actual size. Avoid Fit to page. Use None for margins where your printer and viewer support it.
- Print a small sample and check alignment. If the labels contain barcodes, scan the sample before printing the rest.
A full sheet of stickers needs the full sheet’s paper size, not the dimensions of one sticker. See Printer setup for roll, multi-column, and sheet-label guidance.
Generating a PDF does not send it directly to your printer. PDF links are temporary; download a copy you need to keep. Anyone with the link can access the PDF without a Google login, so share it only with people who should see its contents.
Choose Back to print settings to prepare another batch. Your settings are retained, but the previous Data review is cleared.
Usage and plans
Free accounts see this month’s used/limit count beside Upgrade. Only labels in successfully generated PDFs count. See Google Sheets usage and plans for limits, the monthly reset, and how to upgrade or cancel.
For more help, choose Help Center in the card menu. Help Center links open the Gookit website in another tab.
Questions about this article? Email our team.
Send feedback