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