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

Add a single row of data to a Google Sheet. Use this to log events, track transactions, or append data to spreadsheets. Provide cell values as an array. Ideal for: transaction logs, event tracking, data collection, audit trails.

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

Add a single row of data to a Google Sheet. Use this to log events, track transactions, or append data to spreadsheets. Provide cell values as an array. Ideal for: transaction logs, event tracking, data collection, audit trails.


## At a Glance

| Field | Value |
| --- | --- |
| Action ID | `google-sheets-add-row` |
| Category | Integrations |
| Connector | `pipedream:google_sheets` |
| Requires gas | No |
| Funds movement | None declared |
| Tags | `pipedream`, `integration`, `oauth`, `google-sheets`, `spreadsheet`, `write`, `data`, `logging`, `tracking`, `audit` |

## Payload Schema

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `url` | `string` | Yes | Paste the full Google Sheets URL, including the worksheet tab. |
| `cells` | `array` | Yes | Array of cell values to add as a new row |

## Result Schema

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `success` | `boolean` | Yes | Whether the row was 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-row",
  "payload": {
    "url": "https://docs.google.com/spreadsheets/d/your-spreadsheet-id/edit#gid=0",
    "cells": [
      "example-cells"
    ]
  },
  "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-row/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",
    "cells": [
      "example-cells"
    ]
  }
}'
```

**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.