Google Sheets Custom icon

Google Sheets Custom

Interact with Google Sheets API with auto-refreshing token

Actions7

Spreadsheet → Create

AI-generated

Summary

Create a new Google Sheets spreadsheet with a specified title and an optional initial sheet title.

Inputs

  • Authentication (required) — Choose the authentication method to use: either refresh token with auto-refresh or a manual bearer token.
  • Custom Refresh Token — Optionally override the refresh token from credentials (only when using refresh token authentication).
  • Title (required) — The title of the new spreadsheet to create.
  • Sheet Title — The title of the first sheet in the new spreadsheet; defaults to 'Sheet1' if not specified.

Output shape

a single record representing the newly created spreadsheet as returned by the Google Sheets API

The output includes all properties returned by the API's spreadsheet creation method, including the spreadsheet ID and properties. Errors are raised as workflow errors unless the node is set to continue on fail, in which case errors are output with error details.

Discussion