Google Sheets: Clear Sheet¶
Plugin ID: eca_google_sheets_clear_sheet
Clear values from specific ranges within Google Sheets while preserving formatting.
Fields¶
Authentication Type— config key:auth_type-
Choose between API Client (OAuth2) or Service Account authentication.
Type:
select· Required: yes · Default:api_clientAllowed values:
api_client,service_account Authentication Source— config key:auth_from-
Choose whether to select authentication directly or use a token for dynamic selection.
Type:
select· Required: yes · Default:directAllowed values:
direct,token API Client— config key:api_client_id-
Search and select an API Client for OAuth2 authentication.
Type:
textfield· Required: no · Default: empty string Service Account— config key:service_account_id-
Search and select a Service Account for server-to-server authentication.
Type:
textfield· Required: no · Default: empty string Client ID from Token— config key:auth_client_from_token-
Token that resolves to a client ID (e.g., [user:field_google_client_id]). The token should contain just the client ID, not the auth type prefix.
This field supports tokens.Type:
textfield· Required: no · Default: empty string Spreadsheet ID— config key:spreadsheet_id-
The Google Spreadsheet ID (from the URL). Supports token replacement.
This field supports tokens.Type:
textfield· Required: yes · Default: empty string Sheet Range— config key:sheet_range-
The sheet name or range (e.g., "Sheet1", "Data!A1:C1"). Supports token replacement.
This field supports tokens.Type:
textfield· Required: yes · Default:Sheet1