This article will show you how to set up Google Sheets as a source for Portant Data Merge. Google Sheets is the perfect source if you already have a data set you would like to create documents from.
In this article you’ll learn how to:
After you have selected to connect a Google Sheets source from the 'Home Page' you will need to set it up. Click the Choose File button to open the file picker window. This is where you can search for and select the Google Sheet you would like to connect. After you have found and selected the correct file, click Select.
If you selected a Spreadsheet with multiple sheets, you will need to select the sheet that contains the data from the dropdown list before clicking Continue.
Note - Portant can only source data from one sheet per document.
Top Tip - After you have selected the file, you can click the file name to open it in a new tab. Great for checking if everything is as you expect.
Note - For sheets, Portant requires the column headers to be in the first row of the spreadsheet.
If you do not have a Google Sheets file with data in yet, you can use the 'Create new' button. After you click this button, a new Google Sheets file is created with your filename and connected to your template. This Google Sheets file has some sample data in it that you can use to test with.
Portant can also help you mail merge in Google Docs.
We created Portant in 2021 and the feedback we have received since then has been very helpful and greatly appreciated. If you have any feedback please feel free to send us an email at email@example.com or use our contact form here: https://www.portant.co/support
Blake and James
You can do a lot more than just mail merge with Portant. Portant is a fully-fledged online document automation solution that can optimise many different document flows. You can use our online document automation platform to optimise your repetitive work, so you can get back to doing the work you enjoy.Get started
Transform your work life with responsive, fully customizable, and easy-to-use templates.
Select a Google Doc agreement template, add an eSignature placeholder and put your contract signing on auto-pilot.
Select a Google Sheet of invoice data, add a Google Docs invoice template, and generate 10, 100 or even 1000's of invoices at a time.
Select a Google Form, add tags to a Google Doc template, and generate Docs every time your receive a Google Form response.
Every time a Google Form is submitted an incident report PDF is automatically generated and shared via email.
Select a Google Form, add tags to a Google Doc or Slides template, and generate PDFs from responses.