Google Sheets: Update Sheet¶
Plugin ID: eca_google_sheets_update_sheet
Update data in Google Sheets by row number with support for entire row or specific column updates.
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 Number— config key:row_number-
The row number to update (typically from QuerySheet results like [query_data:Row1:_ROW]).
This field supports tokens.Type:
textfield· Required: yes · Default: empty string Update Mode— config key:update_mode-
Choose whether to update the entire row or specific columns only.
Type:
select· Required: yes · Default:entire_rowAllowed values:
entire_row,specific_columns Row Data Token— config key:row_data-
Token containing the complete row data array (for entire row mode). Example: [query_data:Row1]. Any _ROW key will be automatically removed.
This field supports tokens.Type:
textfield· Required: no · Default: empty string Headers Token— config key:headers_token-
Token containing the header row array. Required for header-keyed data in entire row mode, or when using header names in specific columns mode. Example: [query_data_headers]. Alternatively, use the base token name like "query_data" to extract headers from the first row.
This field supports tokens.Type:
textfield· Required: no · Default: empty string Column Updates— config key:column_updates-
Column updates, one per line. Format: "column:value". Use 1-based column numbers (1, 2, 3...) matching Google Sheets Col1, Col2, Col3 or header names. Example:
1:John Smith
3:completed
Name:Jane Doe
This field supports tokens.Type:
textarea· Required: no · Default: empty string