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.
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
json{ "type": "google-sheets-add-row", "payload": { "url": "https://docs.google.com/spreadsheets/d/your-spreadsheet-id/edit#gid=0", "cells": [] }, "children": [], "connector": { "type": "pipedream:google_sheets", "id": "conn_pipedream_google_sheets" }}
bashcurl -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": [] }}'
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.