Labels from Google Sheets
No add-on, no download, no permission grant. Copy the cells and paste them in.
Copy and paste is the whole workflow
Copying a block of cells in Google Sheets puts tab-separated text on the clipboard — one line per row, tabs between the columns. That is a complete, structured export, and the tool below reads it directly. Select your range including the header row, copy, click into the paste box, and paste.
This is usually faster than the alternatives. Downloading as .xlsx or .csv also works and the tool accepts both, but it leaves a file in your downloads folder for a job that takes one keystroke otherwise.
Why not an add-on
The Google Workspace Marketplace has several label add-ons, and they do work. The cost is access: an add-on installs into your account and typically asks for permission to read and modify your spreadsheets, sometimes across all files rather than the one you are working in. For a list of names and home addresses, that is a meaningful thing to hand over for a one-off print job.
Pasting into a page grants nothing. There is no OAuth prompt, no installed extension, and no account linkage, because this site has no server and no account system. What you paste stays in the browser tab.
Setting the sheet up
Keep one row per label and one column per line of text, with a clear header row. If your addresses currently live in a single cell with line breaks, split them into separate columns first — SPLIT combined with a delimiter, or Data then Split text to columns, both do the job — because a cell containing line breaks pastes as quoted text rather than as separate columns.
If you want some rows printed more than once, add a copies column with a number in it and map that column in the tool. Rows where every mapped column is empty are skipped, so trailing blank rows at the bottom of the sheet do not become blank labels.
Printing
Download the PDF and print it at 100% scale with "fit to page" turned off, on the Avery stock the format expects. Do not print from the Google Sheets print dialog — that prints the spreadsheet grid, not the labels. The PDF is the artefact that carries the label geometry.
Print labels from Google Sheets
1 Your spreadsheet
.xlsx, .xls or .csv. The file is read inside this tab and never uploaded.
2 What goes on each label
Drawn as a Code 128 symbol in vector, not as an image.
Assign a column to each line. Lines you leave unused are skipped, so the remaining lines close up rather than leaving a gap.
Pick a column holding a count to repeat each row that many times.
3 Label sheet
Skip labels you have already peeled off a part-used sheet.
4 Preview and print
Single label
First page
Print at actual size. Never use “Fit to page” or “Shrink to fit” — either one moves every label out of alignment with the sheet.