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

# Google Sheets: Add Multiple Rows

Add multiple rows of data to a Google Sheet in a single operation. Use this for batch imports or when you need to write many rows at once. More efficient than adding rows one by one. Ideal for: batch imports, bulk data exports, report generation.

![Google Sheets: Add Multiple Rows logo](https://ai-icon.b3.fun/logo/google-sheets)
Catalog action Integrations pipedream:google_sheets

Add multiple rows of data to a Google Sheet in a single operation. Use this for batch imports or when you need to write many rows at once. More efficient than adding rows one by one. Ideal for: batch imports, bulk data exports, report generation.


## At a Glance

| Field | Value |
| --- | --- |
| Action ID | `google-sheets-add-multiple-rows` |
| Category | Integrations |
| Connector | `pipedream:google_sheets` |
| Requires gas | No |
| Funds movement | None declared |
| Tags | `pipedream`, `integration`, `oauth`, `google-sheets`, `spreadsheet`, `write`, `batch`, `data`, `bulk`, `import`, `export` |

## Payload Schema

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `url` | `string` | Yes | Paste the full Google Sheets URL, including the worksheet tab. |
| `rows` | `array` | Yes | Array of rows, where each row is an array of cell values |

## Result Schema

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `success` | `boolean` | Yes | Whether the rows were added successfully |
| `data` | `object` | No | Google Sheets API response data |
| `exports` | `object` | No | Exported values from the action |

## Examples

**Workflow node**

```json
{
  "type": "google-sheets-add-multiple-rows",
  "payload": {
    "url": "https://docs.google.com/spreadsheets/d/your-spreadsheet-id/edit#gid=0",
    "rows": [
      []
    ]
  },
  "children": [],
  "connector": {
    "type": "pipedream:google_sheets",
    "id": "conn_pipedream_google_sheets"
  }
}
```
  **Test with API**

```bash
curl -X POST "https://api.b3os.org/v1/actions/google-sheets-add-multiple-rows/test" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "inputs": {
    "url": "https://docs.google.com/spreadsheets/d/your-spreadsheet-id/edit#gid=0",
    "rows": [
      []
    ]
  }
}'
```

**Use expressions for dynamic values**

Payload fields can use workflow expressions such as `{{$trigger.body.amount}}`, `{{$nodes.fetch.result.price}}`, and `{{$props.asset}}` when the value should come from a trigger, prior node, or reusable workflow prop.