> For the complete documentation index, see [llms.txt](https://docs.ownchat.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ownchat.app/bot/connections/google-sheet/add-new-row.md).

# Add New Row

### Overview &#x20;

The Add New Row action in Ownchat allows you to automatically capture chatbot responses and store them directly inside a Google Sheet as new spreadsheet rows.

Using this integration, you can:

* Save customer details automatically
* Store chatbot responses inside Google Sheets
* Capture lead information from WhatsApp
* Sync customer data in real-time
* Automate spreadsheet updates without manual entry

This functionality is ideal for lead collection, CRM syncing, customer data storage, order management, and reporting workflows.

{% embed url="<https://app.supademo.com/demo/cmnd5yvk61udyxtgu26u2qdqo?utm_source=link>" %}

## Prerequisites &#x20;

Before configuring the Add New Row action, ensure the following:

* A Google account is available
* Google Sheets access permissions are enabled
* The target spreadsheet already exists
* Required spreadsheet columns are created
* Your chatbot flow is already configured inside Ownchat

## Connecting Google Sheets with Ownchat &#x20;

### Step 1: Open Apps Section &#x20;

To begin:

1. Log in to Ownchat
2. Navigate to the left sidebar
3. Click the Apps icon<br>

{% embed url="<https://app.supademo.com/demo/cmpdxtm2r02f7z90jk9f74ecz?utm_source=link>" %}

This opens the applications and integrations marketplace.

### Step 2: Open CRM Integrations &#x20;

Inside the Apps section:

1. Click the CRM filter<br>

{% embed url="<https://app.supademo.com/demo/cmpdxumm101qhyx0j9insgu5n?utm_source=link>" %}

This displays all available CRM applications and integrations supported by Ownchat.

### Step 3: Select Google Sheet &#x20;

From the CRM integrations list:

1. Locate the Google Sheet app card
2. Click the card to open integration details<br>

{% embed url="<https://app.supademo.com/demo/cmpdxvpki01dt2n0jf9rxmqp2?utm_source=link>" %}

This redirects you to the Google Sheet connections page.

### Step 4: Create a New Connection &#x20;

Inside the Google Sheet integration page:

1. Click Add a New Connection<br>

{% embed url="<https://app.supademo.com/demo/cmpdxxbrz01dz2n0jse0jn6q9?utm_source=link>" %}

This starts the Google Sheets authentication process.

## Authenticating Google Sheets &#x20;

### Step 5: Select Gmail Account &#x20;

To authenticate Google Sheets:

1. Choose the Gmail account where your spreadsheets are stored<br>

{% embed url="<https://app.supademo.com/demo/cmpdxyey503c3vx0jio84cmtj?utm_source=link>" %}

Once connected, Ownchat automatically fetches all available spreadsheets linked to the selected account.

### Step 6: Advanced Authentication &#x20;

If Google displays a verification warning:

1. Click Advanced
2. View additional options

{% embed url="<https://app.supademo.com/demo/cmpdxzpcv03c6vx0jij5botbz?utm_source=link>" %}

This allows you to continue the authentication process.

### Step 7: Continue to Ownchat &#x20;

After opening advanced options:

1. Click:

* Go to Ownchat.app (unsafe)

{% embed url="<https://app.supademo.com/demo/cmpdy0xy201e42n0jbcpzqtqw?utm_source=link>" %}

This proceeds to the Ownchat authorization screen.

### Step 8: Grant Access &#x20;

To complete authentication:

1. Click the Continue button

{% embed url="<https://app.supademo.com/demo/cmpdy2e5801ee2n0j1fxvmygx?utm_source=link>" %}

This grants Ownchat access to your Google Sheets account.

### Step 9: Enter Connection Name &#x20;

Inside the Create Connection dialog:

1. Enter your preferred connection name<br>

{% embed url="<https://app.supademo.com/demo/cmpdy3gvm0206yx0je0d1ii3z?utm_source=link>" %}

Example:

Sample GSheet Uploading

Using descriptive names helps identify integrations easily later.

### Step 10: Create Connection &#x20;

After entering the connection name:

1. Click Create connection

{% embed url="<https://app.supademo.com/demo/cmpdy4e6e0208yx0j1ohe4mg4?utm_source=link>" %}

This finalizes and saves your Google Sheets integration.

## Configuring the Bot Workflow &#x20;

### Step 11: Open Bot Section &#x20;

To configure the chatbot action:

1. Click Bot from the left sidebar

{% embed url="<https://app.supademo.com/demo/cmpdy5frx020gyx0j6ai8w1eq?utm_source=link>" %}

This opens the bot management screen.

### Step 12: Search for Bot &#x20;

Inside the Bots section:

1. Use the search field
2. Search for the required bot by name

{% embed url="<https://app.supademo.com/demo/cmpdy6d7s03cdvx0jnul3xevb?utm_source=link>" %}

This helps quickly locate the target chatbot workflow.

### Step 13: Open Builder &#x20;

To edit the workflow:

1. Click Open Builder

{% embed url="<https://app.supademo.com/demo/cmpdy7rdn01ei2n0jsx4xn67k?utm_source=link>" %}

This opens the chatbot flow builder interface.

### Step 14: Add a New Node &#x20;

Inside the bot builder:

1. Click Add Node

{% embed url="<https://app.supademo.com/demo/cmpdy9jda01ep2n0j1c7snfjt?utm_source=link>" %}

This creates a new workflow node for the Google Sheets action.

## Configuring Google Sheets Add New Row Action &#x20;

### Step 15: Select Google Sheet Integration &#x20;

From the Connections panel:

1. Click Google Sheet

{% embed url="<https://app.supademo.com/demo/cmpdyazfu02qaz90jmzq7qrda?utm_source=link>" %}

This opens available Google Sheets actions.

### Step 16: Select Add New Row &#x20;

Under Google Sheet actions:

1. Click Add New Row<br>

{% embed url="<https://app.supademo.com/demo/cmpdz785z00011a0jhh5uwtew?utm_source=link>" %}

This opens the Add New Row configuration window.

## Add New Row Configuration Fields &#x20;

The configuration window contains the following fields:

| Field                      | Description                 |
| -------------------------- | --------------------------- |
| Action Name                | Name of the workflow action |
| Select Connection          | Google Sheets connection    |
| Spread Sheet               | Target spreadsheet          |
| Sheet                      | Target worksheet tab        |
| Column Name                | Spreadsheet column name     |
| Value                      | Variable or static value    |
| Store Response in Variable | Stores API response data    |

## Step-by-Step Action Configuration &#x20;

### Step 17: Enter Action Name &#x20;

Inside the Action name field:

1. Enter a descriptive action name

{% embed url="<https://app.supademo.com/demo/cmpdzcfqu03eovx0jx4q8kkke?utm_source=link>" %}

Example:

Add Gsheet Row

This helps identify the action inside complex workflows.

### Step 18: Select Connection &#x20;

Under Select Connection:

1. Open the dropdown menu
2. Select:

* Sample GSheet Uploading<br>

{% embed url="<https://app.supademo.com/demo/cmpdzdewc02wtz90jvc59q7e6?utm_source=link>" %}

This connects the action to the configured Google Sheets account.

### Step 19: Select Spreadsheet &#x20;

Under Spread Sheet:

1. Open the dropdown menu
2. Select:

* Sample upload

{% embed url="<https://app.supademo.com/demo/cmpdzf46402j1yx0jl06jrjuz?utm_source=link>" %}

This specifies the spreadsheet where data will be stored.

### Step 20: Select Sheet &#x20;

Under Sheet:

1. Open the dropdown menu
2. Select:

* Sheet1

{% embed url="<https://app.supademo.com/demo/cmpdzggh101sg2n0j3f28ps3n?utm_source=link>" %}

This defines the worksheet tab inside the spreadsheet.

## Mapping Spreadsheet Columns &#x20;

### Step 21: Configure Name Column &#x20;

To map customer names:

1. Select the column:

* name

{% embed url="<https://app.supademo.com/demo/cmpdzhi2u03f2vx0jkhjp7u75?utm_source=link>" %}

2. Click Add variable
3. Select the customer name variable

Example:

{{customer.name}}

This stores the customer name inside the Name column.

### Step 22: Add Another Column &#x20;

To insert additional fields:

1. Click New value

{% embed url="<https://app.supademo.com/demo/cmpdzm7r603fkvx0j1k5hlpk5?utm_source=link>" %}

This creates another column-value pair configuration.

### Step 23: Configure Phone Number Column &#x20;

To map customer phone numbers:

1. Select the column:

* phoneNo<br>

{% embed url="<https://app.supademo.com/demo/cmpdznlic00181a0jiuz15whg?utm_source=link>" %}

2. Click Add variable
3. Select the customer phone variable

{% embed url="<https://app.supademo.com/demo/cmpdzqv13000fzu0jn0avnfe4?utm_source=link>" %}

Example:

{{customer.phone}}

This stores the phone number inside the spreadsheet row.

## Configure Response Variable &#x20;

### Step 24: Store Response Data &#x20;

To store the Google Sheets response:

1. Open the Store response in variable dropdown
2. Click:

* Create new variable

3. Enter a response variable name

{% embed url="<https://app.supademo.com/demo/cmpdzsax000011y0j8ux2q512?utm_source=link>" %}

Example:

addnewrow\_response

This variable stores the API response returned after the row is inserted successfully.

### Step 25: Create the Action &#x20;

After completing all fields:

1. Click the Create button

This saves the Add New Row action inside the workflow.

## Publish the Bot Workflow &#x20;

### Step 26: Publish the Bot &#x20;

To deploy the workflow:

1. Click the Publish button

{% embed url="<https://app.supademo.com/demo/cmpdzu5ls03fuvx0jvc4id0vy?utm_source=link>" %}

This publishes and activates the updated bot workflow.

## Connecting Additional Actions &#x20;

After the Add Gsheet Row action:

* You can connect additional workflow actions
* Customer details will continue flowing through the bot
* Spreadsheet records will remain synchronized automatically

{% embed url="<https://app.supademo.com/demo/cmpdzvm3h01so2n0j25rt3jeo?utm_source=link>" %}

This allows you to build complete lead management or CRM automation workflows.

## Example Configuration &#x20;

| Setting           | Example Value           |
| ----------------- | ----------------------- |
| Action Name       | Add Gsheet Row          |
| Connection        | Sample GSheet Uploading |
| Spreadsheet       | Sample upload           |
| Sheet             | Sheet1                  |
| Column 1          | name                    |
| Value 1           | {{customer.name}}       |
| Column 2          | phoneNo                 |
| Value 2           | {{customer.phone}}      |
| Response Variable | addnewrow\_response     |

## Common Use Cases &#x20;

### Lead Collection &#x20;

Automatically store:

* Customer names
* Phone numbers
* Email addresses
* Inquiry details

### WhatsApp CRM Sync &#x20;

Capture WhatsApp leads directly into spreadsheets for sales tracking.

### Order Management &#x20;

Store:

* Order details
* Delivery information
* Payment status
* Customer records

### Campaign Tracking &#x20;

Track:

* Ad campaign leads
* Form submissions
* Customer responses
* Event registrations

## Best Practices &#x20;

### Use Structured Column Names &#x20;

Use clean spreadsheet column names such as:

* name
* phoneNo
* email
* city
* order\_status

### Use Variables Dynamically &#x20;

Always use variables instead of static values for customer data.

### Store API Responses &#x20;

Save responses for:

* Error handling
* Workflow tracking
* Conditional automation
* Logging activities

### Verify Spreadsheet Access &#x20;

Ensure:

* Spreadsheet permissions are active
* The worksheet exists
* Column names match exactly

## Troubleshooting &#x20;

### Spreadsheet Not Loading &#x20;

Possible causes:

* Incorrect Google authentication
* Spreadsheet access denied
* Expired Google session

#### Solution &#x20;

Reconnect the Google Sheets integration.

### Columns Not Appearing &#x20;

Possible causes:

* Empty spreadsheet header row
* Invalid sheet selection

#### Solution &#x20;

Ensure the first row contains valid column names.

### Row Not Added &#x20;

Possible causes:

* Variable mapping issue
* Invalid spreadsheet permissions
* Missing required values

#### Solution &#x20;

Verify all mapped variables and spreadsheet permissions.

### Authentication Warning &#x20;

Google may display:

* “Google hasn’t verified this app”

#### Solution &#x20;

Click:

1. Advanced
2. Go to Ownchat.app (unsafe)
3. Continue

Only proceed if you trust the application.

## Summary &#x20;

The Add New Row action enables Ownchat bots to automatically insert customer data into Google Sheets in real time.

By configuring this integration, you can:

* Capture chatbot responses automatically
* Sync WhatsApp data into spreadsheets
* Store customer information instantly
* Build CRM and reporting workflows
* Automate lead management processes

This functionality helps businesses centralize customer data efficiently using Google Sheets automation inside Ownchat.
