How to print labels from Google Sheets

AzureLabel can print labels using data from Google Sheets. Each row in the spreadsheet can become a separate label, and each column can be used for product names, prices, barcodes, SKUs, images, and other label data.

This tutorial shows how to create a label template, connect Google Sheets, import data from the spreadsheet, and print labels using that data.

The same workflow can be used to create product labels, barcode labels, price tags, inventory labels, and many other types of labels from Google Sheets data.

In this tutorial, we will create the following product label:

The label contains the following elements:

1. Product name
2. Price
3. Batch number
4. UPC barcode
5. Product image
6. QR Code linking to a website

Most of these elements are populated from Google Sheets data and display different values for each row in the spreadsheet. In this example, the QR code uses a fixed website address and remains the same on every label. However, like the UPC barcode, it can also be populated from a Google Sheets field and display different values for each row.

Create the label

1. Click New label.

   

2. Select New blank label.

   

3. Enter a name for the label, for example Example.

   

4. Set the label size to 4 x 2 inches and the corner rounding to 0.4 inch.

   

   

Connect Google Sheets

Before AzureLabel can use data from Google Sheets, you need to create import settings that describe how the spreadsheet should be read.

1. Click the Import settings button.

   

2. If a dialog appears, select Add new settings.

   

3. Go to the Connection tab, and select Google Sheets as the connection type.

   

4. Paste the sharing link to your Google Sheet into the Google Sheet link field. AzureLabel supports only Google Sheets shared with Anyone with the link and Viewer access. Private spreadsheets cannot be accessed.

   

   If your Google Sheet is not already shared with Anyone with the link:

   1. Open the spreadsheet in Google Sheets.
   2. Click Share in the upper-right corner.
   3. Under General access, select Anyone with the link.
   4. Set the permission to Viewer.
   5. Copy the sharing link.

5. On the Reading tab, specify the row number that contains the column names. In this example, it is row 1.

   If your table does not contain column names, set this value to 0.

   

6. Go to the Data fields tab and click Read data fields from source.

   

   The column names appear in the list.

   

   Remove any columns you do not want to import.

   

7. Click Test import to verify the data.

   

8. Click OK.

Import the spreadsheet data

1. Click the Import button.

   

   After importing the data, you can see the names of your columns (data fields) in the Data fields list:

   

Add elements to the label

Add the product name

1. To display the product name, drag the Name field to the empty space of the label.

   

2. Select the Text type.

   

3. Set the desired position and size of the area to display the product name.

   

4. Set the Auto font size to Fit to the element.

   

Add the price

1. To display the price, drag the Price field to the empty space of the label.
2. Select the Text type.
3. Open Element properties

   

4. Go to the Text formatting tab, type the Prefix $ and click OK.

   

   You can also use Mixed text on the Data source tab if you need more complex text formatting. This is covered later in the guide.

5. Set the desired position and size of the area to display the product price.

   

6. Set the Auto font size to Fit to the element.

Add the batch number

1. To display the batch number, drag the SKU field to the empty space of the label.
2. Select the Text type.
3. Open Element properties
4. Go to the Text formatting tab, type the Prefix Batch and click OK.

   

5. Set the desired position and size of the batch number.

   

6. Set the Auto font size to Fit to the element.

Add the barcode

1. To display the barcode, drag the Barcode field to the empty space of the label.
2. Select the Barcode type.

   

3. Select the UPC-A or EAN-13 barcode type in the list and click OK.

   

4. Set the desired position and size of the barcode.

   

Add the product image

1. To display the product image, drag the Image field to the empty space of the label.
2. Select the Image type.

   

   Image fields can contain the image itself (for example, binary or SVG data), or a reference to an image, such as a local file path or a URL.

3. Set the desired position and size of the image.

   

Add the QR code

1. To display the QR code with a link to our website, select the 2D Barcode tool.

   

2. Click an empty area of the label.
3. Select the QR Code barcode type in the list.

   

4. Go to the Data source tab, type the barcode data https://azurelabel.com and click OK.

   

5. Set the desired position and size of the QR code.

   

Save the label

Click Save to save the label template.

Preview or print

Click Preview to generate labels from the imported Google Sheets data.

AzureLabel generates one label for each row in the spreadsheet. You can review the generated labels before printing and adjust print settings if needed.

To print multiple copies of a label, change the value in the Print quantity column of the Label print data table.

You can also import print quantities from your Google Sheet. In the Import settings, select the field that contains the quantity values and enable Use this field to set the print quantity.

Next steps

How to print barcode labels