Generate Identical Labels

How is this for?

There is no data you need to to pull/merge from a Google Sheet into your labels. All your labels are identical to each other. You just need to generate X amount of the same labels.

How to do it?

Say you need generate 30 labels with the same text. What do you need to do? Just follow these steps:

  1. Create a Google Sheet. You can call it 'Same Label Merge'.
  2. In 'Sheet1' cell A1 enter a column header. You can call it 'Label Count'.
  3. Then enter numbers 1 to 30 in the cell range A2:A31. (See image below.)
  4. From the add-on's sidebar, click 'Select Spreadsheet' and choose the file created in the step 1.
  5. Click 'Choose Avery Template' to select the Avery template you're working on.
  6. Enter your text in the Label Template Box.
  7. Now hit the blue 'Merge' button from the add-on. It will then confirm that it will generate 30 labels. Click 'Yes' to continue.
  8. At the end of the process you will be given a link to a document containing your generated 30 labels.