Overwrite or Append Rows
A 3-step recipe with Google Sheets. We can help you get access.
Recipe · 3 steps
Overwrite or Append Rows
with Google Sheets
Overwrite a range in place when populated, otherwise append the rows.
- Read the target range and branch on whether it already contains data.
- Overwrite the populated range in place with the supplied rows.
- Append the supplied rows to the empty range so they land at the start of the table.
What you'll need to have ready
- accessToken: OAuth 2.0 bearer access token with the spreadsheets scope.
- spreadsheetId: The ID of the spreadsheet to write to.
- range: The A1 notation range to inspect and write (e.g. Sheet1!A1:C10).
- values: A two-dimensional array of cell values to write.
For your developer
Arazzo workflow google-sheets:overwrite-or-append-rows, 3 operations: getValues → updateValues → appendValues. Specs on APIs.io.