This guide shows you how to create professional labels that combine both text and images—perfect for branded address labels, product labels with logos, or any label that needs visual elements alongside your data.
Step 1: Open Label Maker
- Open an empty Google Docs document
- Click Extensions → Label Maker → Create Labels
Step 2: Select Your Label Template
Use the search bar in the Label Maker sidebar to find your desired label template. Search by brand name (e.g., "Avery 5160") or dimensions.
Step 3: Connect Your Spreadsheet
Select the Google Sheet from which you want to pull your data. This will be used for mail merge fields in your label design.
Step 4: Design Your Label with Text and Images
Follow these steps to create a clean layout with both an image and text:
1. Set Initial Font Size
Change the font size to 1. This helps maximize the image size while staying within the cell boundaries.
2. Insert a Table for Layout
Click Insert → Table → 2×1. This adds a two-column table inside the label cell, making it much easier to position your image and text side by side.
3. Add Your Image
- Click the image icon to insert an image into one column of the table
- The uploaded image may increase the size of the cell
- Important: Resize the image until the cell returns to its original size. The document will not format correctly if the cell size is too large or too small.
4. Adjust Column Widths
Drag the column border to adjust the width of the image column to your desired size. This controls how much space the image takes versus the text.
5. Center Your Text Vertically (Optional)
To vertically center your text next to the image:
- Right-click on the table column that contains the text (not the image)
- Select Table properties
- Go to Cell → Cell vertical alignment → Middle
6. Restore Your Font Size
Change the font size back to your desired size (typically 10-12pt for address labels).
7. Add Merge Fields
- In the Label Maker sidebar, use the Sheet dropdown to select your data source
- Use the Column dropdown to insert merge fields from your spreadsheet columns
- Position merge fields like
<<Name>>and<<Address>>in the text column
8. Style Your Text
Format your text as desired—adjust fonts, sizes, colors, and alignment to match your branding.
9. Remove Table Borders
- Highlight both the text and image (select the entire table)
- Click the table borders icon in the toolbar
- Select 0pt to remove the visible border around the table
This makes the table invisible so your label looks clean and professional.
10. Generate Your Labels
Click Create Labels in the sidebar. Label Maker will generate a new document with all your personalized labels, each containing your image and merged text.
Step 5: Print Your Labels
- Click File → Print
- Set Margins to None
- Set Scale to 100%
- Print to your desired printer
Troubleshooting: If your labels overflow onto the next page or lose alignment, your first label likely contains too much content. This throws off the entire document. To fix this: reduce empty space, decrease font size, or remove content until everything fits within a single label.
Pro Tips
- Image size matters: Keep images small enough that they don't push content outside the label boundaries
- Test first: Always print a test page on regular paper before using label sheets
- Use PNG for logos: PNG images with transparent backgrounds work best for professional-looking labels
- Keep it simple: Less content per label means fewer alignment issues