In this article:

How to Print Envelopes From Google Sheets (Easiest Way in 2025)

January 13, 2025

In this tutorial, we will show you exactly how to print envelopes from Google Sheets in just a few simple steps. Simply follow the steps below.

google sheets print on envelopes

Print Envelopes From Google Sheets

Follow the steps below to print on envelopes from Google Sheets.

1. Install Mail Merge Add-on in Google Docs

On your Google Docs, go to Extensions, hover to Add-ons and choose Get add-ons. This will open the Google Workspace Marketplace.

google sheets print envelopes

Search for the Mail Merge add-on then install it. Click Allow then continue to approve the necessary permissions. This add-on will merge the data from Google Sheets into your Google Docs envelope.

print from google sheets to envelopes

2. Link Google Sheets to Google Docs

Open the Mail Merge add-on from your Google Docs, go to Extensions hover to Mail Merge then choose Start. This will load a new window on the right side of the screen.

Click Open Spreadsheet then choose “your Google Sheet” (in this example 'Logbook_US' was the file name of our spreadsheet) finally, click Select. This will load your spreadsheet in the Mail Merge.

Now, select the Sheet to where your data is located, in our case this is ‘InfoBook’.

Insert the needed placeholders by selecting it from the Merge Field dropdown then click Add. Do this until all the necessary placeholders are added.

Now, select Merge to Letters, hover to Merge and click “Yes” (if you still have the trial version informing you about the remaining merge trials). This will now load a new Google Docs file containing your envelopes. Open it, then review for final retouch if needed.

3. Print your envelopes

On the file generated by the add-on, go to File menu, then Print. Adjust the printer driver settings accordingly to match your envelope size and margins. This will print your envelopes with varying data based on your Google Sheets file.

We hope that you now have a better understanding on how to print on envelopes from a Google Sheets file. If you enjoyed this article, you might also like our articles on exporting CSV with quotes in Google Sheets and calculating IRR in Google Sheets.

Turn PDFs into spreadsheet tables with AI

Use Lido to extract data from contracts, invoices, financials, and more in seconds. Save time, reduce errors.
  • No credit card required
  • 20 free pages