Append Data
AI-generatedSummary
Append data to a rows table in a Rows spreadsheet.
Inputs
- main (required) — Input items processed sequentially; each triggers an API call to append data.
Output shape
main
Returns an array of items, each containing the API response JSON and a pairedItem index referencing the source item.
Examples
Example 1: Append a header and one row to a table
Set spreadsheetId to a valid Rows spreadsheet, tableId to a table within it, leave range at default A1:B or specify A1:B1000, and set data to '[[Name, Email], [John Doe, john@example.com]]'.