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

# Google Sheets

> Import contact lists from spreadsheets for outbound campaigns

## Overview

Connect Google Sheets to import contact lists for your outbound calling
campaigns. Each row becomes a call with personalized variables.

## What You Can Do

| Feature               | Description                                      |
| --------------------- | ------------------------------------------------ |
| **Import Contacts**   | Pull phone numbers and data from any spreadsheet |
| **Dynamic Variables** | Use column values as context in your workflow    |
| **Auto-Sync**         | Data is fetched when campaign starts             |

## Setup

<Steps>
  <Step title="Connect Google Sheets">
    Go to **Integrations** → Click **Create Integration** → Select **Google Sheets**
  </Step>

  <Step title="Authorize Access">
    Sign in with your Google account and grant spreadsheet permissions
  </Step>

  <Step title="Use in Campaign">
    When creating a campaign, select **Google Sheets** as your data source
  </Step>
</Steps>

## Spreadsheet Format

Your spreadsheet must have a header row. Column names become variable names.

### Required Columns

| Column         | Required | Description                                     |
| -------------- | -------- | ----------------------------------------------- |
| `phone_number` | **Yes**  | Phone number to call (E.164 format recommended) |

### Recommended Columns

| Column       | Description                |
| ------------ | -------------------------- |
| `first_name` | For personalized greetings |
| `last_name`  | Full name reference        |
| `company`    | Business context           |
| `email`      | Follow-up communications   |

### Example Spreadsheet

| phone\_number | first\_name | last\_name | company   | notes                  |
| ------------- | ----------- | ---------- | --------- | ---------------------- |
| +33612345678  | Jean        | Dupont     | Acme Corp | Interested in premium  |
| +33698765432  | Marie       | Martin     | Tech SA   | Follow-up from website |

## Using Variables in Workflows

Column values are available as context variables in your workflow:

```
"Bonjour {{ first_name }}, je vous appelle de la part de {{ company }}..."
```

## Technical Details

| Setting       | Value                                                   |
| ------------- | ------------------------------------------------------- |
| OAuth Scope   | `https://www.googleapis.com/auth/spreadsheets.readonly` |
| Max Columns   | A-Z (26 columns)                                        |
| Sync Timing   | On campaign start                                       |
| Row Filtering | Skips rows without `phone_number`                       |

## Troubleshooting

<AccordionGroup>
  <Accordion title="Spreadsheet not appearing in picker">
    * Ensure you're signed into the correct Google account
    * The sheet must be accessible (owned or shared with you)
    * Try refreshing the page and reconnecting
  </Accordion>

  <Accordion title="Missing contacts after sync">
    * Check that `phone_number` column exists (exact spelling)
    * Rows without phone numbers are automatically skipped
    * Verify there's data below the header row
  </Accordion>
</AccordionGroup>

## Next Steps

<CardGroup cols={2}>
  <Card title="Campaigns" icon="rocket" href="/features/campaigns">
    Learn how to launch outbound calls
  </Card>

  <Card title="Context Variables" icon="code" href="/workflows/context-variables">
    Advanced variable usage
  </Card>
</CardGroup>