> ## Documentation Index
> Fetch the complete documentation index at: https://docs.quick.bot/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

export const YoutubeVideo = ({id}) => <div style={{
  position: 'relative',
  paddingBottom: '64.63195691202873%',
  height: 0
}}>
    <iframe src={`https://www.youtube.com/embed/${id}`} allowFullScreen style={{
  position: 'absolute',
  top: 0,
  left: 0,
  width: '100%',
  height: '100%',
  borderRadius: '8px'
}}></iframe>
  </div>;

The Google Sheets integration block enables data management with Google Spreadsheets, supporting
create, read, update operations with advanced filtering, data mapping, and OAuth authentication.

## 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

Select from three primary operations:

### Get Row

Retrieve and filter spreadsheet data with flexible options:

* **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

Add new records to your spreadsheet with full variable support:

* **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

Modify existing spreadsheet data with advanced filtering:

* **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

The Google Sheets integration provides a sophisticated filtering system for precise data operations:

### 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

Extract data from spreadsheet responses:

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