Generate Libre Barcodes

Start Avery Label Merge add-on by clicking on Extensions > Avery Label Merge > Start to display the Avery Label Template Box and the Avery Label Merge sidebar.

From the Avery Label Merge sidebar, click on Select Spreadsheet to select the Google Sheets file that contains the barcode source data.

Once selected, the name of the spreadsheet (e.g, Company Products) appears in the File field.

From the Sheet drop-down menu, select the tab in the Google Sheets file that contains the barcode source data.

Make sure the first row in the Google sheet contains column names (e.g, Product Name, Barcode, Barcode Label). These column names are going to be used as *|merge fields|* in the Google Docs label template.

To be able to merge, there needs to be at least one row of data under the column names.

The Barcode column should contain the barcode source data. 

The Barcode Label column contains a formula that adds an * before and after the barcode value. This formula format is required to create barcodes that can be scanned by barcode readers.

Click on the Label / Envelope field to display the list of available Avery label templates and select for example, the Avery 05161 Avery label template, and then click on Apply.

Once an Avery label template is selected, the Avery Label Template Box changes to the size of the selected template.

Insert *|merge fields|* into the Google Docs label template by clicking in the desired location within the Label Template Box, selecting a merge field from the Merge Field drop-down menu, then clicking on Add. Repeat these steps for all the required *|merge fields|*.  

Format the *|merge fields|* as required.

*|Merge fields|* are the column names found in the first row of data in the selected Google Sheets file.

Download Libre Barcode 39 Text font if it is not available by clicking on More fonts from the Font drop-down menu.

Type libre barcode, select the font you want to use, and then click on OK. Here, we are using Libre Barcode 39 Text font. 

Highlight the *|Barcode Label|* merge field, and then select Libre Barcode 39 Text font to convert the *|Barcode Label|* merge field into a barcode.

Click on Merge Labels to begin the label merge process to generate libre barcodes in Avery labels.

After a message appears that confirms the number of generated Avery labels (the number of rows merged), choose either to display the merged labels in a Google Doc and/or a PDF, and then check if the labels appear correct.

The files that contain the created labels are now automatically saved on Google Drive.

In the newly created Google Doc, click on the Print icon to print the generated Avery labels containing the libre barcodes.

NOTE: Read this article about how to print labels using Google Docs, and how to avoid labels becoming misaligned.