Google Sheets Custom icon

Google Sheets Custom

Interact with Google Sheets API with auto-refreshing token

Actions7

Sheet → Delete

AI-generated

Summary

Delete rows from a specific sheet within a Google Spreadsheet by specifying the spreadsheet ID.

Inputs

  • Authentication (required) — Choose the authentication method: either auto-refreshing using a refresh token or manual bearer token.
  • Custom Refresh Token — Optionally override the refresh token from credentials when using Refresh Token authentication.
  • Spreadsheet ID (required) — The ID of the spreadsheet containing the sheet from which rows will be deleted.

Output shape

a list of JSON objects representing the results of the delete operation for each item processed by the node

Outputs an array with one item per input, each indicating success or failure. Errors can be handled by the workflow if 'Continue On Fail' is enabled.

Examples

Example 1: Deleting rows from a sheet

Provide 'Spreadsheet ID' to identify the spreadsheet. Use the 'Delete' operation under 'Sheet' resource and configure authentication as needed. Upon execution, the specified rows in the sheet are deleted, and the response is returned as output.

Discussion