> ## 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: Update Cell

Update a single cell value in a Google Sheet. Use this to modify specific cells, update statuses, change balances, or correct data. Provide the cell reference in A1 notation (e.g., 'B2'). Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Ideal for: status updates, balance tracking, dashboard values, single-field corrections.

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

Update a single cell value in a Google Sheet. Use this to modify specific cells, update statuses, change balances, or correct data. Provide the cell reference in A1 notation (e.g., 'B2'). Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Ideal for: status updates, balance tracking, dashboard values, single-field corrections.


## At a Glance

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

## Payload Schema

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `url` | `string` | Yes | Paste the full Google Sheets URL, including the worksheet tab. |
| `cell` | `string` | Yes | The cell reference in A1 notation \(e.g., 'A1', 'B5', 'C10'\) |
| `value` | `string \| number \| boolean \| null` | Yes | The new value to set in the cell |

## Result Schema

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

## Examples

**Workflow node**

```json
{
  "type": "google-sheets-update-cell",
  "payload": {
    "url": "https://docs.google.com/spreadsheets/d/your-spreadsheet-id/edit#gid=0",
    "cell": "example-cell",
    "value": "1000000"
  },
  "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-update-cell/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",
    "cell": "example-cell",
    "value": "1000000"
  }
}'
```

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