Google Sheets: Append to Sheet¶
Plugin ID: eca_google_sheets_append_sheet
Available since: 1.0.0
Appends a single row to a Google Sheet.
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 Row Data— config key:row_data-
Data to append as a single row. Enter one cell value per line. Example:
John Doe
john@example.com
Manager
Supports token replacement.
This field supports tokens.Type:
textarea· Required: yes · Default: empty string Value Input Option— config key:value_input_option-
How the input data should be interpreted.
Type:
select· Required: yes · Default:USER_ENTEREDAllowed values:
USER_ENTERED,RAW