> ## Documentation Index
> Fetch the complete documentation index at: https://docs.uservox.ai/llms.txt
> Use this file to discover all available pages before exploring further.
# How to add a Google Sheet for the Realtime Lead Update
## Step 1: Connect Your Google Sheet
### UI Reference
***
### Steps:
1. Open your Google Sheet
2. Click **“Share”**
3. Add:
```text theme={null}
uservox@uservox.iam.gserviceaccount.com
```
4. Give **Editor access**
5. Click **Send**\\
***
### In UserVox:
* Enter **Integration Name**
* Paste **Google Sheet URL / ID**
* Select **Sheet Name**
* Click **Test Access**\\
✅ You should see: **“Sheet access verified!”**
***
## Step 2: Choose Integration Mode
### 1. Standard Mode (Bidirectional Sync)
**Best for:** CRM / Active workflows
**Features:**
* Read leads from sheet
* Update status back
* Add comments & disposition
* Push call recordings\\
### 2. Write-Only Mode (One-Way Sync)
**Best for:** Reporting / Analytics
**Features:**
* Writes only final outcomes
* Does not touch source sheet
* Creates separate reporting sheet\\
***
### Configuration:
* Sheet Name Template:
```text theme={null}
Concluded Leads {date}
```
* Enable **Auto-create daily sheets** if needed
***
## Step 3: Column Mapping
* Shows mapping of sheet columns → UserVox variables\\
***
### Example Mapping:
| Google Sheet Column | UserVox Variable |
| :--------------------------------- | :--------------------------------- |
| user\_reason\_for\_not\_interested | user\_reason\_for\_not\_interested |
| Complaint | Complaint |
| listingCity | listingCity |
| summaryPoints | summaryPoints |
***
### Notes:
* Names should match exactly
* Custom variables are allowed
Keep naming consistent\\
***
## Step 4: Process Selection
Select where integration applies:
* Calling Campaigns
* Sales Flows
* Verification Calls
* Collections\\
* \\