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

# Google Spreadsheet

> Automatically log all calls to a Google Spreadsheet

## What this integration does

The Allo-Google Spreadsheet integration automatically logs every call to a Google Sheet. Perfect for teams that want simple call tracking without a full CRM. All call data exports in real-time to your spreadsheet.

**Key benefits:**

* Automatic call logging to Google Sheets
* Real-time sync after each call
* Customizable spreadsheet layout
* Easy data analysis and reporting

## Setup

<Steps>
  <Step title="Create a Google Sheet">
    On your computer or phone, create a new Google Sheet
  </Step>

  <Step title="Make it public">
    1. Click **Share** button
    2. Under "General access", select **Anyone with the link**
    3. Set permission to **Editor**
    4. Click **Copy link**
  </Step>

  <Step title="Open Allo app">
    Launch Allo on mobile or desktop
  </Step>

  <Step title="Go to Integrations">
    Navigate to **Settings** > **Integrations**
  </Step>

  <Step title="Find Google Spreadsheet">
    Locate **Google Spreadsheet** in the integrations list and tap **Connect**
  </Step>

  <Step title="Paste the URL">
    Paste your Google Sheet URL (the link you copied)
  </Step>

  <Step title="Save and activate">
    Tap **Save** to activate the sync
  </Step>
</Steps>

<Warning>
  The Google Sheet must be set to "Anyone with the link can edit" for the integration to work.
</Warning>

<Info>
  Allo automatically creates column headers on first use. New calls appear as rows in real-time.
</Info>

## How it works

<CardGroup cols={2}>
  <Card title="Real-time logging" icon="https://mintcdn.com/themobilefirstcompany/4JKVqOLduvlaK6pG/media/integrations/Allo.png?fit=max&auto=format&n=4JKVqOLduvlaK6pG&q=85&s=de5eaa45a01e052c9506804098dbb8ce" width="256" height="256" data-path="media/integrations/Allo.png">
    Every call logs to your spreadsheet within seconds after ending.
  </Card>

  <Card title="Automatic columns" icon="https://mintlify.s3.us-west-1.amazonaws.com/themobilefirstcompany/media/integrations/GoogleSheets.svg">
    Allo creates column headers automatically on first sync.
  </Card>

  <Card title="Recording links" icon="https://mintcdn.com/themobilefirstcompany/4JKVqOLduvlaK6pG/media/integrations/Allo.png?fit=max&auto=format&n=4JKVqOLduvlaK6pG&q=85&s=de5eaa45a01e052c9506804098dbb8ce" width="256" height="256" data-path="media/integrations/Allo.png">
    Each row includes a clickable link to the call recording.
  </Card>

  <Card title="Export ready" icon="https://mintlify.s3.us-west-1.amazonaws.com/themobilefirstcompany/media/integrations/GoogleSheets.svg">
    Download as CSV or Excel anytime for external analysis.
  </Card>
</CardGroup>

### Spreadsheet structure

Allo creates two tabs on your Spreadsheet: `Allo Log Calls` and `Allo Sync Contacts`.

In `Allo Log Calls`, the following columns are created automatically:

| Column       | Content                        |
| ------------ | ------------------------------ |
| Date         | Call date and time             |
| Contact Name | Name from Allo contacts        |
| Phone Number | Caller's phone number          |
| Direction    | Inbound or Outbound            |
| Duration     | Call length in minutes:seconds |
| Outcome      | Answered, Voicemail, Missed    |
| Summary      | AI-generated call summary      |
| Recording    | Link to audio file             |
| Transcript   | Link to full transcript        |

In `Allo Sync Contacts`, the following columns are created automatically:

* Identifier
* First Name
* Last Name
* Email
* Phone Numbers
* Company
* Job Title

### Data updates

**Real-time sync:**\
New calls appear in the spreadsheet within 5-10 seconds after the call ends.

**No deletion:**\
Allo never deletes rows from your spreadsheet. All historical data remains.

## What syncs

<Tabs>
  <Tab title="Allo to Google Sheets">
    **From Allo to Google Sheets:**

    * Call date and timestamp
    * Contact name
    * Phone number
    * Call direction (inbound/outbound)
    * Call duration
    * Call outcome (answered, voicemail, missed)
    * AI summary
    * Recording link
    * Transcript link
    * Contact tags (if any)
  </Tab>

  <Tab title="Google Sheets to Allo">
    **From Google Sheets to Allo:**

    All contacts that you enter on the `Allo Sync Contacts` table will be created in Allo automatically.
    Important note: each contact must have an Identifier on it in order to be synced to Allo. It can just be
    the row number.
  </Tab>
</Tabs>

## Customizing your spreadsheet

### Safe customizations

You can freely customize:

* Add new columns for your own data
* Add formulas and calculations
* Create charts and pivot tables
* Apply formatting and colors
* Add filters and sorting
* Create additional sheets in the workbook

### What to avoid

Don't delete or rename these columns:

* Date
* Contact Name
* Phone Number
* Direction
* Duration
* Outcome
* Summary
* Recording
* Transcript

Deleting these columns may break the integration.

## Troubleshooting

<AccordionGroup>
  <Accordion title="Connection failed">
    **Common causes:**

    * Google Sheet not set to public
    * URL copied incorrectly
    * Sheet permissions set to "View only"

    **Solutions:**

    * Make sure sheet is set to "Anyone with the link can edit"
    * Copy the full URL from the browser address bar
    * Check sharing settings in Google Sheets
  </Accordion>

  <Accordion title="Calls not appearing in spreadsheet">
    **Check these items:**

    * Integration shows as "Connected" in Allo Settings
    * Google Sheet still exists (not deleted)
    * Sheet permissions haven't changed
    * You have internet connection during calls

    **Solution:** Disconnect and reconnect with a fresh URL.
  </Accordion>

  <Accordion title="Missing columns or data">
    **If columns are missing:** Delete the integration and reconnect. Allo will recreate column headers.

    **If specific calls are missing:** Check that those calls were made through Allo app, not your phone's native dialer.
  </Accordion>

  <Accordion title="Recording links not working">
    **Common causes:**

    * Recording still processing (wait 1-2 minutes)
    * Call was too short to record
    * Recording disabled for your account

    **Check recording status:** Open the call in Allo app to verify recording exists.
  </Accordion>

  <Accordion title="How to change spreadsheet">
    To connect a different Google Sheet:

    1. Create a new Google Sheet and make it public
    2. Go to **Settings** > **Integrations** > **Google Spreadsheet**
    3. Tap **Disconnect**
    4. Follow setup steps with the new sheet URL
  </Accordion>

  <Accordion title="Need to reconnect">
    To reconnect the integration:

    1. Go to **Settings** > **Integrations** > **Google Spreadsheet**
    2. Tap **Disconnect**
    3. Follow the connection steps again
  </Accordion>
</AccordionGroup>

## Manage your integration

### Disconnect Google Spreadsheet

To disconnect the integration:

1. Open Allo app
2. Go to **Settings** > **Integrations**
3. Select **Google Spreadsheet**
4. Tap **Disconnect**

<Warning>
  Disconnecting stops new calls from logging. Existing data in the spreadsheet remains unchanged.
</Warning>

### Share with team

To give team members access:

1. Open your Google Sheet
2. Click **Share**
3. Add team member email addresses
4. Set permission level (Viewer or Editor)

Team members can view and analyze call data without accessing your Allo account.

## Use cases

### Simple call tracking

Track all calls without setting up a full CRM. Perfect for solo entrepreneurs and small teams.

### Call volume analysis

Use Google Sheets charts to visualize call volume trends. Identify busy periods and staffing needs.

### Performance reporting

Create monthly reports by filtering calls by date range. Share with stakeholders easily.

### Custom wor