Google Sheets NexviahubInstall

Summary

Clears all or part of a selected sheet in a Google Sheets document. Choose the document and sheet, then select whether to clear the whole sheet, specific rows, specific columns, or a range.

Inputs

• Client ID, Client Secret, Refresh Token, Access Token, Authentication (required) — Google OAuth credentials and authentication method. The UI marks all four credential fields as required.
• Document (required) — Select a spreadsheet from the list, provide its URL, or enter its ID.
• Sheet (required) — Select a sheet from the list, provide a sheet URL or ID, or enter its name.
• Clear — Choose Whole Sheet (default), Specific Rows, Specific Columns, or Specific Range.
• Keep First Row — For Whole Sheet, preserve the first row when enabled; defaults to false.
• Start Row Number — For Specific Rows, the row number to start clearing from; defaults to 1.
• Number of Rows to Delete — For Specific Rows, the number of rows to clear; defaults to 1.
• Start Column — For Specific Columns, the starting column; defaults to A.
• Number of Columns to Delete — For Specific Columns, the number of columns to clear; defaults to 1.
• Range — For Specific Range, the required range to clear, such as A:F or MySheet!A:F.

Output shape

A list of n8n items

The operation clears sheet data; the provided source pack only exposes the execute signature, so it does not establish the returned item contents.

Links

• n8n community nodes installation guide