---
title: "How to automatically print shipping labels"
description: "Creating address labels has come a long way since learning how to do a mail merge. Use Zapier to add contacts to a spreadsheet for easy printing with online tools."
image: "https://images.ctfassets.net/lzny33ho1g45/print-shipping-labels-p-img/7ca83338b5f03f1d636bf06031ed1f6b/file.png"
---

# How to automatically print shipping labels

Creating address labels has come a long way since learning how to do a mail merge. Use Zapier to add contacts to a spreadsheet for easy printing with online tools.

In computer class, the first advanced thing we learned how to do was create address labels in a Microsoft Word document from a spreadsheet. It was tedious, but it felt like magic for people first learning about computers and using common work software. 

Luckily, the process has evolved since then. You can now automate your shipping label creation process and make things even easier. 

There are two methods we recommend to automate shipping labels (and if you use them both it makes the process even easier):

1. [Make shipping labels with Google Sheets and Avery](#avery)
2. [Automatically add addresses to a spreadsheet using Zapier](#spreadsheet)

## Make shipping labels with Google Sheets and Avery

Let's start with the simplest option: Making shipping labels using Google Sheets and Avery's free [Design & Print software](https://www.avery.com/software/design-and-print/). If you have a spreadsheet with addresses, it can turn them into ready-to-print labels quickly.

Go to [Avery Design & Print](https://www.avery.com/software/design-and-print/) and click **Start designing.** You'll be prompted to sign in to your Avery account or create one if you don't have one already. 

Once you're logged in, you can choose from a variety of Avery labels to get started. Once you've selected a label, you can also select a label template or design your own. 

After you've selected a template, click on** Import Data Mail Merge **located at the left-side menu. Then, click **Start Import/Merge.**

You can upload a file from your desktop but for this tutorial, we want to use a Google Sheet. Click on the Google Drive tab, then click **Login with Google** and choose the Google account you'd like to use. 

Once you've connected your account, you'll see the latest Google Sheets files in your Drive account. Select the one you'd like to use. 

### Set up your labels

Now you can select which rows and columns you'd like to use. This is helpful if you use the same spreadsheet to print all of your labels. By default, everything is selected. If you've labeled your spreadsheet columns, make sure you deselect your column labels. Once you've made your selections, click **Next. **

Next, you'll need to select the order in which you want your fields to appear on your label by either double-clicking or dragging and dropping your fields into the placeholder label. After you've completed your merge, this will be the order in which your address information will appear on each label. When you're done, click **Next. **

If everything looks good, click **Finish** to complete your mail merge. 

If you'd like to change the appearance, you can play with the formatting options in the menu on the left side or you can adjust the text box within the label to preview.

When you're happy with how your labels look, click the **Preview & Print button **in the bottom-right corner of the screen. 

You'll see a preview image of how your labels will appear on each sheet. Depending on the template you use, you can choose to print the labels yourself or send them to Avery to ship to you for a fee. 

## Automatically add addresses to a spreadsheet

Collecting addresses in a spreadsheet is no one's idea of fun. You can automate this thankless task with Zapier. Anytime you get a new order in your eCommerce shop, save a new contact in your Customer Relationship Manager (CRM), or anything else where you need to ship or mail something, Zapier can automatically add the address to your spreadsheet. 

### **Before you begin**

If you don't already have a spreadsheet with addresses, create one in Google Sheets. Make sure your columns are labeled so the Zap will work correctly. 

### **Option 1: Get started quickly with a Zap template**

Click the button below—or near any of the Zap templates at the end of this article—and you'll be ready to create your Zap. 

Here's how it works: 

1. Click on the button to get started.
2. Connect your Google Contacts and Google Sheets accounts.
3. Select the spreadsheet you'd like to use.
4. Select the spreadsheet columns you'd like to use.
5. Select the Google Contact information you want to include in your selected spreadsheet columns.
6. Test your workflow and turn it on.

### **Option 2: Create your own Zap**

If you'd like more control over information in your Zap or would like to add additional actions such as filters, you can click here to create a new Zap from scratch. We'll be using Google Contacts and Google Sheets for this tutorial, but this walk-through will be similar to most apps.

Here's how to set it up: 

1. Log in to Zapier and click on **Make a Zap **to start from scratch. (If you don't have a Zapier account, it's free to start.)
2. Connect the app you'd like to pull your addresses from to tell Zapier where to look for a new address.
3. Connect and customize your spreadsheet so Zapier knows where to store the new addresses.
4. Test your Zap, then turn it on!

### **Connect the app that stores your addresses**

Log in to Zapier and click on **Make a Zap **to be directed to Zapier's editor, where you can create automated workflows. Choose your Google account from the dropdown menu. If you've never connected it to Zapier, click **+ Connect a new account **to give Zapier permission to access your Google account.  

When you're done, click **Continue. **

Now we need to test our trigger. Zapier will look for a recent contact in your Google Contacts to make sure that the right account is connected. Click on **Test trigger**.

You'll see this success message if Zapier finds a contact, along with test information. We'll use this information to customize our Zap further. Click **Continue**.

### Connect and customize your spreadsheet app

The action is the event a Zap performs after it is triggered. In this example, we want our Zap to create a new row in our Google Sheet. Click **Continue**. Choose **Google Sheets** as your _App_ and **Create Spreadsheet Row **as your _Action Event. _

Next, select your Google Sheets account from the dropdown menu. If you've never connected Google Sheets to Zapier before, click on **+ Connect a new account **and follow the prompts to give Zapier access. 

When you're done, click **Continue. **

Now, you need to tell Zapier which spreadsheet you want your addresses added to. Select the specific _Drive_, _Spreadsheet_, and specific _Worksheet_ from the dropdown menus. 

Once you've made your selections, the editor will automatically expand to include your named spreadsheet columns as fields. 

Next, you need to tell Zapier which information from Google Contacts you want and where you'd like it to go in your spreadsheet. We call this process field mapping. 

Click on an empty field indicated by _Enter text or insert data._ A dropdown menu will appear with information from Google Contacts.** **Then, select the corresponding information from Google Contacts you want to add to each field. 

Think of this as multiple choice. You can choose one, multiple, or no data options from Google Contacts—unless a field is labeled "required." For example, we added the _Name Last _input field from Google Contacts so we'd have both first and last names in our spreadsheet. 

Once you've finished mapping how Zapier should add your Google Contact information to your spreadsheet, click **Continue. **

### Test your Zap and turn it on

Now it's time to test our Zap. Zapier will create a new row in Google Sheets with the information we mapped in the previous step. You can skip this test if you'd like by clicking on **Skip Test** in the top right corner, but we recommend testing this step in case something looks wrong in your spreadsheet. Click any of the testing buttons to continue. 

If your test was successful, you'll see a success message like this: 

Check your spreadsheet to make sure everything looks correct. 

If something looks off, you can go back to the previous steps to change how your Google Contact fields are mapped, and then re-test. 

Once you're happy with it, don't forget to turn on your Zap.  Every time a new contact is added to Google Contacts (or any other app you use as a trigger), Zapier will automatically copy it to a spreadsheet. 

When you're ready to print shipping labels, run through Avery Share & Print like before. 

After you've made your labels, don't forget to delete your old addresses from your spreadsheet so you're not reprinting old information each time. 

After you've deleted old rows in your spreadsheet, Zapier will start over and add a new order or contact as the first address in your spreadsheet.

Ready to automate your own labels? Here are some Zaps—what we call our automatic workflows—to help you get started adding addresses to your spreadsheet automatically. 

The shipping process doesn't need to be a hassle. Automation can help you with administrative tasks like creating shipping labels so you can focus on getting your products out to your customers. 

_This article was originally published in March 2018 by Matthew Guay and updated in March and August 2021 by Krystina Martinez._