Google Sheets Custom icon

Google Sheets Custom

Interact with Google Sheets API with auto-refreshing token

Actions7

Sheet → Clear

AI-generated

Summary

Clear the content in a specified range of a Google Sheets spreadsheet.

Inputs

  • Authentication — Choose method to authenticate with Google Sheets API: Refresh Token (auto-refresh) or Bearer Token (manual).
  • 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 to clear.
  • Range (required) — The A1 notation range specifying which cells in the sheet to clear, e.g., 'Sheet1!A1:D10'.

Output shape

A single JSON object containing the API response confirming the clear operation.

The output contains the JSON response from the Google Sheets API's clear method for the specified range. No pagination applies.

Discussion