Back to catalog

Google Sheets · Productivity

Sheets API / Append cell values

Appends rows after the last row of data in a range (developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append): spreadsheetId and range are path fields, valueInputOption ("RAW" or "USER_ENTERED") is a required query field, values (a 2D array of rows) is the required body field the docs define.

Private Gateway connection

Data below comes from the configured private Gateway. Provider activation remains governed by its evidence and policy gates.

unverifiedRequest shape unavailableUnverified
Published API evidence
Public metadata only. Response bodies, credentials, and internal review notes are never displayed.

No verification date is claimed. No response capture is claimed.

Request parameters

  • values body · required

    2D array of row values to append, e.g. [["a", 1], ["b", 2]].

  • valueInputOption query · required

    "RAW" (store values as-is) or "USER_ENTERED" (parse as if typed in the UI, e.g. formulas).

Provider docs How to run it

Sign in to run this operation, inspect live eligibility, and see governed execution and audit evidence. Sign in.

Sheets API / Append cell values · looot