Google Sheets

​

Authentication Setup

1. Click in + Add Google Sheets Account.
2. Then continue with Google and select the account you want to use.
3. Grants access to your Google Sheets.

​

Select an action

​

Get Row

• Row Selection: Extract All, First, Last, or Random matching rows
• Advanced Filtering: Complex filter rules with multiple comparison operators
• Column Extraction: Select specific columns to retrieve
• Variable Mapping: Save extracted data to bot variables for reuse

​

Insert Row

• Column Mapping: Map bot variables to specific spreadsheet columns
• Dynamic Values: Use variables, static text, or expressions
• Header Validation: Ensures columns exist before insertion
• Batch Support: Insert multiple values in a single operation

​

Update Row

• Filter Criteria: Define complex filter rules to identify target rows
• Logical Operators: Combine filters with AND/OR operations
• Selective Updates: Update only specific columns while preserving others
• Batch Updates: Update multiple rows matching filter criteria

​

Data Filtering System

​

Comparison Operators

• Equal to: Exact value matching
• Not equal to: Value exclusion
• Contains: Substring matching (case-insensitive)
• Greater than: Numeric comparison
• Less than: Numeric comparison
• Is set: Check for non-empty values

​

Logical Operations

• AND Logic: All filter conditions must match
• OR Logic: Any filter condition can match
• Mixed Logic: Combine multiple filter rules with different operators

​

Example Filter Configuration

Email [Equal to] {{User_Email}}
AND
Status [Not equal to] "inactive"
OR
Last_Login [Greater than] {{30_Days_Ago}}

​

Output

• Individual column values
• Complete row data
• Calculated results
• Row count information