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.
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
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" }}
bashcurl -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" }}'
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.