# Google Sheets

Google Sheets is a great source for a workflow if you already have data for the documents you want to create. This can already be in Google Sheets, or you can export the data from another platform in a csv and upload it to Google Sheets. In this guide we will show you how to:

1. How to set up your Google Sheet
2. Process Rows Manually
3. Turn on Auto-create  (✨ *Pro feature*)
4. Data Grouping

### How to set up your Google Sheet

When you set up your Google sheet, the first row ow your spreadsheet should contain your headers and then the data should be organised in rows underneath, like this:

<figure><img src="/files/08pCXkVKiLOcxp7dlwY7" alt=""><figcaption></figcaption></figure>

Each row in your spreadsheet will create one document, unless you use our [Data Grouping ](/portant-docs/sources/google-sheets/data-grouping.md)feature

### How to process rows manually

There are two options to process data using a Google Sheet, you can set up Portant to process rows automatically or manually process them.

To process rows manually, click the 'Automate' button in the top right of the screen, here:

<figure><img src="/files/daL2USrsQjWvdNsHLYsZ" alt=""><figcaption></figcaption></figure>

When you click the button a menu will open with options of how to automate the data. You can process all the data in the spreadsheet by clicking the start button here:

<figure><img src="/files/LbLFxkaEh75gZBFxfZyn" alt=""><figcaption></figcaption></figure>

Or you can process a selection of the rows by changing the dropdown option 'Custom range' then entering a selection of rows, like this:

<figure><img src="/files/vo49DKQrAN6hUJXbGUdf" alt=""><figcaption></figcaption></figure>

In this example we have selected to run rows 3 through to 5 and row 11. You can enter a dash (-) between two numbers if you want to select a range and you can enter multiple numbers separated by commas if you want each row processed.

### How to turn on Auto-create (✨ *Pro feature*)

You can turn on Auto create by clicking the Automate button in the top right of the screen, here:

<figure><img src="/files/daL2USrsQjWvdNsHLYsZ" alt=""><figcaption></figcaption></figure>

This means that every time new data is entered into your spreadsheet it will be processed. You can learn more about Auto-create in t[his article](/portant-docs/sources/google-sheets/google-sheets-auto-create.md). When it is switched on a status appears here:

<figure><img src="https://assets-global.website-files.com/5f3b57b5405f8bd0f98b5e14/6492905c24f87f95922c6771_Auto-create%20Sheets%20%E2%80%93%201.png" alt=""><figcaption><p>If you can't see this status, Auto-create is not on.</p></figcaption></figure>

### How to use Data Grouping

Data grouping is a great feature if you need to place multiple rows from the same spreadsheet into the same document. For example if you have 5 rows with line item data for an invoice. You could use the invoice number to group the information and enter it into the same documents. You can learn more about Data Grouping in [this article](/portant-docs/sources/google-sheets/data-grouping.md).

#### 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>

‍


---

# 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/sources/google-sheets.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.