Mail merge in Google Docs

Yes, you can create a mail merge with Google Docs and Google Sheet data in a few easy steps.

1. The first step is to login or sign up to Portant workflow (the link is here: app.portant.co, or you can use our Mail merge add-on), which makes it simple to mail merge images, gifs, dates, numbers and text. In our opinion Portant is the best mail merge add-on/app 😜
2. Then open the app, create a workflow and connect a Google Sheet,
3. Then insert merge fields to your document template in Google Docs.
4. You can also add an email block to send the merged documents to multiple email addresses.
5. After that, just click automate.

And voila!, you’ve just mail merged! View our complete guide here.
‍
Portant also enables you to create Docs from Google Forms too

Yes, you can create a mail merge with Google Docs in a few easy steps.

1. The first step is to login or sign up to Portant workflow (the link is here: app.portant.co, or you can use our Mail merge add-on), which makes it simple to mail merge images, gifs, dates, numbers and text.  In our opinion Portant is one of the best mail merge add-ons/app 😜
2. Then open the app, create a workflow and connect a Google Sheet.
3. Then add merge fields to your document template in Google Docs.
4. You can also add an email block to send the merged documents to multiple email addresses.
5. After that, just click 'Start automation'.

And voila!, you’ve just completed your first mail merge! View our complete guide here.

You can create a mail merge using Google Docs in a few easy steps. It is simple to merge data like images, gifs, dates, numbers and text in multiple languages.

1. The first step is to login or sign up to Portant workflow (the link is here: app.portant.co, or you can use our Mail merge add-on), which makes it simple to mail merge images, gifs, dates, numbers and text. In our opinion Portant is one of the best mail merge add-ons/app 😜
2. Then open the app, create a workflow, connect a spreadsheet, insert merge fields to your template document (Google Doc).
3. You can also add an email block to send each merged document to multiple email addresses.
4. After that, just click automate.

And voila!, you’ve just completed a mail merge! You can view our complete guide here.

You can mail merge using Google Sheets in a few easy steps, but you also need a document template to format how you'd like your data to look (or you can mail merge directly to email).
It is simple to merge images, gifs, dates, numbers and text in multiple languages.

1. The first step is to login or sign up to Portant workflow (the link is here: app.portant.co, or you can use our Mail merge add-on), which makes it simple to mail merge images, gifs, dates, numbers and text.
2. Then open the app, create a workflow, connect a spreadsheet, add merge fields to your template document.
3. You can also add an email block to send the merged documents to multiple email addresses.
4. After that, just click automate.

‍
And voila!, you’ve just completed a mail merge!
View our complete guide here.

You can create a mail merge using lots of different Google Apps in Google Workspace (G Suite). The most common is to mail merge from Google Sheets to an email (or GMail) template. However you can mail merge documents, presentations, PDFs or a combination of them. You can also mail merge data from Google Form responses, so each time you receive a response an email/document/presentation/pdf is created.

You can do this all in Portant (or you can use our Mail merge add-on) and it's super simple to set up or you can start from one of our pre built templates.  In our opinion Portant is one of the best mail merge add-ons/app 😜

Yes, it is easy to make letters, envelopes or shipping address labels in Google Docs. You can add a table to the google doc and then add the address details with the formatting you require. However if you need to create multiple labels and have the data in a Google Sheet you can make them using a mail merge and data grouping. You can use this template to get started here.

Yes, you can mail merge in Google Slides from Google Sheets or from other Google Apps like Google Forms using Portant. The first thing to do is select your Google Sheet, then select your Google Slides template. After that you can customise your template using merge fields to insert text, numbers or even images. You can optionally share the created documents via email to multiple email addresses. Then the final step is to click Start Automation to start your first mail merge. You can learn how to make certificates using Google Sheets, Google Slides and Portant.

You can create all kinds of personalised documents or iterations of documents using mail merge. From personalised letters and contracts, to custom pitch decks and invoices. You can even make certificates, letters, envelopes or shipping address labels using mail merge. You can even share the created documents via personalized emails to multiple email addresses. The only limit is your imagination!

Adding images is easy. All you need to do is mark the source row as an image, then when you click 'insert merge field', a placeholder images is inserted into the document. You can move and resize this placeholder image merge field to your liking and click the 'start automation' button when you're ready to start your mail merge! Lean more here

It only takes one click to mail merge documents as a pdf. Before you click 'Create documents' make sure you have checked the 'save copy as pdf' check box within the document block. Then when you next perform a mail merge your documents will be exported as a Google Doc and a PDF saved in a sub folder.
Check out our guide on how to mail merge to PDF

Yes, you don't have to select all rows from the spreadsheet in a mail merge. In the automation panel you can select which is the first and last row from a custom selection of rows. Or you can select only one if that is better suited to your use case. Then when you've made your selection, just click 'Start automation' to start your mail merge.

Yes, you can select any folder to save the merged document in (as long as it's a Google Drive location accessible by the google account you are using Portant with). To change the output folder open the 'options' tab and click the pencil icon in the top right corner to select a new Google Drive folder for the mail merge outputs to be stored in.

Yes, you can share the documents with any email via personalized emails to multiple email addresses, all sent from your own email address. To do this add an email block to your workflow, add the merge filed that contains all the email addresses to the 'To' field and customise the rest of the inputs to suit your needs. Then when you start your automation, personalized emails with the customised documents will be sent to all the email addresses in your workflow.

You can convert Google Form responses to Docs in a few easy steps. We have written a guide about it here: Google Forms to Docs.
‍You can mail merge data from Forms to Docs (or other Google Apps) using Portant (or you can use our Mail merge add-on). In our opinion Portant is one of the best mail merge add-ons/app 😜