> ## Documentation Index
> Fetch the complete documentation index at: https://docs.browseract.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to Importing Data to Google Sheets

> This tutorial shows how to automatically import data extracted by BrowserAct to Google Sheets via Make.com.

### Prerequisites

**1.Ensure Data Format is JSON**  In BrowserAct workflow's Output Data node, ensure format is set to JSON.

**2.Prepare Google Sheets**

* Create new Google Sheets
* Set column headers (matching extracted data fields)
* Note Sheet name and ID

### [Make.com](http://Make.com) Integration Steps

#### **Step 1: Create Make Scenario**

Log in to [Make.com](http://Make.com) and Click "Create a new scenario"

<img src="https://mintcdn.com/browseract/1wSaeCpRk4hxiYKf/images/image(6).png?fit=max&auto=format&n=1wSaeCpRk4hxiYKf&q=85&s=a63a952c3b30e5e6578035a1fc21c2aa" alt="image (6).png" width="1823" height="730" data-path="images/image(6).png" />

#### **Step 2: Add BrowserAct Module**

**2.1 Add Module**

1. Click + to add module
2. Search "BrowserAct"
3. Select "Run a workflow"

**2.2 Configure BrowserAct Connection**

1. Click "Add" to create a new connection
2. Enter your BrowserAct API Key
3. Click "Save"

**2.3 Select Workflow**

1. Select your workflow from the dropdown
2. Configure required input parameters (if any)
3. Click "OK"

⚠️ Important: Ensure your BrowserAct workflow output format is JSON

<img src="https://mintcdn.com/browseract/1wSaeCpRk4hxiYKf/images/image(7).png?fit=max&auto=format&n=1wSaeCpRk4hxiYKf&q=85&s=299b0b29370b7aa6a5dedb076d1b2afb" alt="image (7).png" width="1553" height="824" data-path="images/image(7).png" />

#### **Step 3: Set Up JSON Processing**

**3.1 Add JSON Module**

1. Click + to add new module
2. Search "JSON"
3. Select "Parse JSON"

**3.2 Configure JSON Parser**

Generate data structure:

1. Open BrowserAct，go to workflow execution history (Activity log)，find successful execution record
2. Copy complete JSON output data
3. Return to [Make.com](http://Make.com)，In JSON Parse module, click "Generate"
4. Paste copied JSON data into "Sample data" field, click "Save"

<img src="https://mintcdn.com/browseract/1wSaeCpRk4hxiYKf/images/image(8).png?fit=max&auto=format&n=1wSaeCpRk4hxiYKf&q=85&s=8e99197c15526946a5ac4ece647786b0" alt="image (8).png" width="1846" height="605" data-path="images/image(8).png" />

**Configure JSON string field:**

1. In "JSON string" field
2. Click to select BrowserAct module output
3. Select field containing data (usually output.string)

<img src="https://mintcdn.com/browseract/1wSaeCpRk4hxiYKf/images/image(9).png?fit=max&auto=format&n=1wSaeCpRk4hxiYKf&q=85&s=da1ca66ccbbee0b0a5d2a7b8a083b7d7" alt="image (9).png" width="895" height="784" data-path="images/image(9).png" />

#### **Step 4: Connect Google Sheets**

**4.1 Add Google Sheets Module**

1. Click + to add a new module. Search "Google Sheets"- "Add a Row"
2. **Configure Google Sheets Connection**

* Click "Add" to create a new connection
* Authorize [Make.com](http://Make.com) to access your Google account
* Select target Google Sheets
* Select target Sheet (worksheet)

<img src="https://mintcdn.com/browseract/1wSaeCpRk4hxiYKf/images/image(10).png?fit=max&auto=format&n=1wSaeCpRk4hxiYKf&q=85&s=9d013a9f7b3f5b5ed81aa07f3c8aa614" alt="image (10).png" width="818" height="693" data-path="images/image(10).png" />

**4.2 Map Data Fields**

Important concepts:

* **Columns:** Define Google Sheets column order
* **Values:** Map data to corresponding columns

<img src="https://mintcdn.com/browseract/1wSaeCpRk4hxiYKf/images/image(11).png?fit=max&auto=format&n=1wSaeCpRk4hxiYKf&q=85&s=278ccd04dcac846e2ca5d843f8d99efa" alt="image (11).png" width="841" height="774" data-path="images/image(11).png" />

#### **Step 5: Test Run**

**5.1 Run Test**

1. Click "Run once" at bottom
2. Observe execution process
3. Check output of each module

<img src="https://mintcdn.com/browseract/1wSaeCpRk4hxiYKf/images/image(12).png?fit=max&auto=format&n=1wSaeCpRk4hxiYKf&q=85&s=d410c50d7d064d21fff48dd72ff3daea" alt="image (12).png" width="1433" height="774" data-path="images/image(12).png" />

**5.2 Verify Results**

1. Open your Google Sheets
2. Confirm data added correctly
3. Check data format and content

**5.3 Handle Multiple Records**

**<u>If your BrowserAct workflow returns multiple records (array),you need to additerators :</u>**

**Configure iterator:**

1. Add Iterator module between JSON Parse and Google Sheets
2. Select array field from JSON Parse output
3. Each iteration automatically adds rows to Google Sheets

### Common Troubleshooting

**Issue 1: JSON Parse Failed**  Error: Invalid JSON

Solutions:

1. Confirm BrowserAct output format is JSON
2. Check JSON data is complete

**Issue 2: Field Mapping Error**  Error: Field not found

Solutions:

1. Re-generate JSON data structure
2. Confirm field names match exactly
3. Check case sensitivity

**Issue 3: Data Not Added to Sheets**  Possible causes:

* Google Sheets connection expired
* Sheet name changed
* Insufficient permissions

Solutions:

1. Re-authorize Google Sheets connection
2. Confirm Sheet name and ID correct
3. Check Google account permissions

Expected results:

* ✅ Data automatically transfers from BrowserAct to Google Sheets
* ✅ New row added each run
* ✅ Data format correct, fields correspond