---
title: "Add Row"
url: "https://help.flows.world/en/article/add-row"
language: "en"
last_updated: "2025-01-28T08:55:54.035Z"
---

# Add Row

### How to connect your Google sheet to add rows using Flows.

**Step 1: Set Up a Google Sheets Connection in Flows**

1.  Open **Flows** and navigate to the **Google Sheets** app.
2.  Ensure you use a connection that has **editor access** to the target Google Sheet.
3.  If the sheet is **personal**, add your own Google account in the app settings.
4.  If the sheet is **shared within your organization**, use a **shared Google account** with editor access to the sheet, to prevent disruptions if an individual leaves the company.
5.  Each connection is tied to a single Google account, so ensure the correct one is used.

* * *

**Step 2: Configure the "Add Row" Action**

1.  In Flows, select **Google Sheets** > **Add Row**.
2.  Choose the **Google Sheets connection** that has access.
3.  Enter the **Spreadsheet ID** (found in the URL of the Google Sheet).
4.  Define the **range** where the data will be inserted (the range of columns to add values to):
    -   If targeting a specific tab, use for example: `TabName!A1:F1`
    -   If sending to the first tab, use only for example: `A1:F1`
5.  Input the **values** in a comma-separated format, ensuring:
    -   **Non-numerical values** are enclosed in `""`.
    -   Example: "Value 1","Value 2"
    -   This places:
        -   `Value 1` in Column A
        -   `Value 2` in Column B
        -   And so on...

* * *

**Important Notes:**

-   The "Add Row" action **only ever adds a new row**; it will **never overwrite existing data**.

* * *

**Example Setup:**  
  
**![](https://cdn-assets.productfruits.com/ccb8bb7a-a0db-4ef8-9782-11df2b3b36ee)**

-   **Spreadsheet ID:** `1FY9WGL5gxIgNHz8xvcDUDF-t5izIkD1FroxdS-qy708`
-   **Range:** `Track!A1:F1`
-   **Values:**

This setup ensures that each new entry is added as a row in the **Track** tab in the columns A to F on the first available row (if for example 100 rows are already populated with data, the app will add to row 101), with values mapped to the corresponding columns.

```plaintext
"{{accountId}}","{{state}}","{{previous}}","{{current}}","{{timestamp}}","{{user}}"
```