Google Sheets Custom icon

Google Sheets Custom

Interact with Google Sheets API with auto-refreshing token

Actions7

Sheet → Append

AI-generated

Summary

Append rows of data to a specified range in a Google Sheets spreadsheet, using either auto-refreshing OAuth refresh token or a manual bearer token for authentication.

Inputs

  • Authentication (required) — Choose between 'Refresh Token (Auto-Refresh)' or 'Bearer Token (Manual)' for authenticating with Google Sheets API.
  • Custom Refresh Token — Optionally override the refresh token from credentials when using the Refresh Token authentication method.
  • Spreadsheet ID (required) — The ID of the Google Sheets spreadsheet to append data to.
  • Range (required) — A1 notation range in the sheet to append data to (e.g., 'Sheet1!A:Z').
  • Data (required) — Data to append as a JSON-formatted array of arrays, e.g. [["Value1", "Value2"], ["Value3", "Value4"]].
  • Options.valueInputOption — Determines how the input data should be interpreted: 'RAW' to insert values as-is, or 'USER_ENTERED' to parse values as if typed into the UI. Defaults to 'USER_ENTERED'.

Output shape

a single JSON object

The operation returns the API response JSON from Google Sheets append method, including information about the updates made (e.g., spreadsheet range, updated cells). Errors will be thrown unless 'Continue On Fail' is enabled, in which case errors are returned per input item.

Discussion