# How to set-up a Google Sheets source

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:**

1. Select an existing Google Sheets file
2. Create a new Google Sheets file

#### Connect to an existing Google Sheets file

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.

<figure><img src="https://uploads-ssl.webflow.com/5f3b57b5405f8bd0f98b5e14/607a165acfedc76a2e1dca09_ixwyPFy5vNk12tdTpwTeawGrtmvIddguAW1pYzsji-gfvE0_7KIFQFi8e2ABe8vgRLul2j2QaiWRXNhk-qqcxQ97EakpF7BXCTQjJMVRwzsnHG5pVWy6mQNLm8rLxRz349-DNG7z.gif" alt=""><figcaption></figcaption></figure>

<br>

> **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.

<figure><img src="https://uploads-ssl.webflow.com/5f3b57b5405f8bd0f98b5e14/607a16573c1e009dfc99f212_GU_bnBHMsSAU2DKAknHONu709EWLuJRBIxALAFxk3JOAAA4jo7eDYNB-SuGCWHZ_E5p8BP6kkmv13ipCtMbs0kWpOHUKc0sypiFlaf56UErnA4GxPfYrz0kN18ph4RpsbVV9CaXV.gif" alt=""><figcaption></figcaption></figure>

<br>

> **Note** - For sheets, Portant requires the column headers to be in the first row of the spreadsheet.

#### Create a new Google Sheets file

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.

#### Additional resources

Portant can also help you [mail merge in Google Docs.](https://www.portant.co/mail-merge-google-docs)

#### Feedback and feature suggestions

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 <contact@portant.co><br>

Thanks,<br>

Blake and James


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.portant.co/portant-docs/portant-add-ons/data-merge/how-to-set-up-a-google-sheets-source.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.