How to Print Barcode Labels from Google Sheets with LPSNG

Need to know how to print barcode labels from Google Sheets without exporting CSVs, building a separate label template, or copying values into another tool? This guide walks through the managed LPSNG workflow: keep your data in Google Sheets, open the LPSNG add-on, bind barcode and text fields to columns, preview, and print.

LPSNG is the Next Generation Label Printing System by RSJ Software GmbH. The Google Sheets add-on gives you a direct path from spreadsheet rows to professional barcode labels, with no manual data export in between. By the end, you will be able to design and print labels directly from your sheet, using the data you already maintain.

Prerequisites

Before you start, gather the following:

• A Google account with access to Google Sheets.
• The LPSNG Google Sheets Add-on installed from the Google Workspace Marketplace. See the official Google Sheets guide for the current installation steps.
• A label printer configured for your system, or use LPSNG PDF generation for preview and testing.
• Basic familiarity with Google Sheets: entering data, selecting ranges, and using column headers.

You do not need to export the sheet or build additional label files. The add-on reads the sheet data as part of the label workflow.

Step-by-Step: Printing Barcode Labels from Google Sheets

Step 1: Prepare your data in Google Sheets

Organize your spreadsheet so each row represents one label. Use clear column headers for label fields such as product name, SKU, and barcode value. The barcode column must contain the exact data you want encoded in the barcode.

For example:

ProductName,SKU,BarcodeValue
Organic Honey,SKU-1001,4012345678901
Almond Butter,SKU-1002,4012345678902
Dark Chocolate,SKU-1003,4012345678903

If your barcode value is assembled from multiple columns, create a helper column first. For example:

=CONCATENATE(A2, "-", B2)

LPSNG reads the final value from the mapped column, so make sure the helper column contains the complete barcode string before you start designing.

Step 2: Open the LPSNG Add-on

From Google Sheets, open the LPSNG add-on from the Google Sheets menu. Create a new label layout or open an existing one. The add-on is the workspace where you connect your sheet data to label elements.

The managed workflow keeps label design, data mapping, preview, and print output inside the same interface. You work with labels and sheets, not with file exports or print queues in a separate application.

Step 3: Design the label

Use the LPSNG label studio to design the label. Add the elements you need:

• Text elements for product names or static information.
• Image or logo elements if your label requires graphics.
• Barcode elements for 1D or 2D barcodes.

Bind the barcode element to the appropriate column from your sheet. The barcode element should point to the column that contains the exact data to encode, such as BarcodeValue in the example above.

Step 4: Map data fields

Map each label element to a spreadsheet column. For example:

Check that column headers match exactly. If a mapping points to a missing or renamed header, the label may print blank for that field. Use the official Google Sheets integration guide if you need the current mapping steps for your LPSNG version.

Step 5: Preview and adjust

Use the preview function to see how labels look with sample data from the sheet. This is the stage to catch alignment issues, truncated text, or barcode values that do not fit the label area.

Preview against a few rows, not just the first row. That helps you spot cases where longer product names or different barcode lengths break the layout.

Step 6: Print

Select the rows you want to print. Choose your connected label printer, or choose PDF output if you want to inspect the labels before committing to physical media.

For label printers, make sure the printer is online and the correct media size is selected. For PDF output, open the generated file and check the layout before sending a large batch to print.

Step 7: Optional automation with triggers

For recurring or programmatic printing, LPSNG offers a web service API that accepts print jobs from external applications. In Google Sheets, you can use Apps Script to call that API on a schedule.

A minimal Apps Script trigger looks like this:

function createHourlyTrigger() {
  ScriptApp.newTrigger('sendLpsngPrintJob')
    .timeBased()
    .everyHours(1)
    .create();
}

function sendLpsngPrintJob() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet();
  const range = sheet.getRange('A2:C10');
  const rows = range.getValues();
  // Build an authorized request using the LPSNG web service documentation:
  // https://lpsng.rsj.de/en/webservice.md
}

Replace sendLpsngPrintJob with the function that reads your sheet and calls the LPSNG web service. Use the web service documentation for the exact request format and OAuth2 authentication requirements.

Verification: Ensuring Your Labels Print Correctly

After printing or generating a PDF, verify the output against your spreadsheet data:

• Check that barcode values match the values in the mapped column exactly.
• Confirm that text fields show the correct product name, SKU, or other mapped data.
• Inspect alignment, font size, and label margins for visual defects.
• Use a barcode scanner to scan printed barcodes and confirm they decode to the intended values.
• For batch jobs, spot-check a few labels from the beginning, middle, and end of the batch.

If you are printing from PDF output, open the PDF at 100% zoom and visually inspect for data truncation or barcode distortion.

Troubleshooting Common Issues

Barcode not scanning

Make sure the barcode type you selected is supported. LPSNG supports a wide range of 1D and 2D barcode formats. Check the barcode formats documentation before designing labels.

Also verify that the data does not contain invalid characters for the selected barcode type. Some 1D barcode symbologies reject lowercase letters or special symbols.

Labels print blank or missing data

Check the field mapping in the LPSNG label layout. Ensure each label element points to the correct column and that the column headers match exactly. A renamed header can break the binding without causing an obvious error.

Printer not recognized

Verify that the printer drivers are installed and the printer is online. If the printer is still not recognized, use PDF output as a fallback to confirm that the label layout and data are correct. Then investigate the printer connection separately.

Add-on not loading

Refresh the Google Sheets page and check the add-on permissions. Ensure the LPSNG add-on is installed correctly and that your Google account has access to the add-on. If the issue persists, consult the official Google Sheets guide.

Performance with large datasets

If the add-on slows down with a large spreadsheet, break the print job into smaller batches. Print a few hundred rows at a time rather than sending the entire sheet in one job.

FAQ

Can I use LPSNG with Google Sheets for free?

LPSNG offers a Google Sheets Add-on that allows you to design and print labels directly from your spreadsheet. The add-on is available from the Google Workspace Marketplace. For detailed pricing and edition features, refer to the official LPSNG documentation or contact RSJ Software GmbH.

Does LPSNG support all barcode types?

LPSNG supports a wide range of 1D and 2D barcode formats. For a complete list, see the barcode formats documentation at https://lpsng.rsj.de/en/barcode.md. Ensure your barcode type is listed before designing labels.

Can I print labels from Google Sheets without installing software?

Yes. With the LPSNG Google Sheets Add-on, you can design and print labels entirely within Google Sheets. The add-on runs in the cloud, so no local software installation is required beyond adding it to your Google account. You can output to a connected printer or generate PDF files.

How do I automate label printing from Google Sheets?

LPSNG provides a web service API and supports integrations that can be triggered programmatically. For Google Sheets, you can use Apps Script to call the LPSNG API or set up time-driven triggers to automate printing tasks. Refer to the LPSNG web service documentation for API details.

Conclusion

Printing barcode labels from Google Sheets becomes a controlled, repeatable process when you use the LPSNG add-on. There is no manual export, no separate label template to keep in sync, and no copy-paste step between your data and the printer. The spreadsheet stays the source of truth, and the label layout reads from it directly.

The Next Generation Label Printing System handles the design, mapping, preview, and print orchestration while your data stays in Google Sheets. From there, you can move to other LPSNG integrations such as the Excel interface or the web service API for more advanced, programmatic use cases.

Install the LPSNG Google Sheets Add-on and start printing barcode labels directly from your spreadsheet today.

Related posts

• Best Label Design Software for Thermal Printers in 2024
• How to Create QR Code Labels in Bulk Efficiently
• Label Printing for Small Business Owners: A Complete Guide