Create Invoice in Google Sheets for Shipping Effortlessly

Create invoice in google sheets for Shipping

hi everybody today we're going to work on creating printable shipping labels using Google sheets now normally this can be quite a time-consuming task so I've set up a spreadsheet here where I've included all of the important information for creating address labels and I'm going to show you a much shorter way to create printable labels so after you've got your address data you need to open a Google Doc we're actually going to use a Google Docs add-on to complete the task which will end up pulling data from our spreadsheet so click into add-ons and then select get add-ons now search for avery label merge and click the plus icon to add it you'll also have to accept some permissions in order to activate it next go up to your add-ons menu and select the Avery label merge choose new merge and then from the menu that pops up choose address labels we've only got about ten addresses in our sheet that I made so just select the first option here now from this menu we need to select the spreadsheet where we created our list of addresses over here on the right hand side are the headers from the spreadsheet populated into this menu if we go back over you'll see that my custom headers have become these labels here now if I click on one of the headers it appears in the label so I can determine the order in which information appears so I'll choose name street name town state and zip we can also manually put a comma in between the town name and the state now let's just verify that the rows were pulling from are correct so we need these numbers here to match up with our sheet which they do next click on merge and then click on open to view the new document that includes all the printable shipping labels we print this sheet out cut them out and we've got all of our address labels quickly and easily this takes a fraction of the time that making address labels manually one by one could take and becomes even more helpful when you start dealing with large-scale mailings much bigger than our example here today thanks so much for watching this video I hope you found it helpful and if you have any questions please just leave them in the comments section below have a great day