Hlabels.com has developed a Google Docs™ and Sheets™ extension (add-on) called "Label Sheets - Create, Mail Merge & Print Labels".
You can find it in the Google Workspace Marketplace,
by typing its name into the "Search apps" box.
This add-on lets you create label content individually or automatically using data from a spreadsheet (mail merge), then generate a PDF printout that you can send to any roll printer.
To create labels in Google Docs™ and print them on label rolls of any brand or size, click the button above and follow the steps below.
If your label data is contained in the rows of a Google Sheet and the layout requires only basic text formatting, it is simpler to use the Hlabels add-on directly within Google Sheets™, rather than importing the data into a Google document. Follow the steps below:
That's it!
The Hlabels add-on will automatically generate a print-ready PDF file containing all your label content.
You can either send it directly to your roll printer or download the file for later use.
Make sure to either measure — or read from the label specifications — and then correctly enter the label width and height, carrier width, and gap in the Hlabels Google Docs™ and Sheets™ extension dialog.
If your label background isn't white and a thin white edge appears along one or more sides, select a bleed area between 1% and 5% to slightly enlarge your label design and eliminate the white edges.
We will soon add Roll Label printing to our Canva, Microsoft Word, and Adobe integrations. Until then, you can save your label designs as JPG or PNG files and upload them to our site for perfect roll label printing on any brand and size.
We respect your privacy and want you to have control over your data. Please choose your preferences: