# 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="/media/integrations/Allo.png">
    Every call logs to your spreadsheet within seconds after ending.
  </Card>
  <Card title="Automatic columns" icon="/media/integrations-app/google-sheets.svg">
    Allo creates column headers automatically on first sync.
  </Card>
  <Card title="Recording links" icon="/media/integrations/Allo.png">
    Each row includes a clickable link to the call recording.
  </Card>
  <Card title="Export ready" icon="/media/integrations-app/google-sheets.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 workflows

Connect your spreadsheet to other tools:

- Import sheet data into Looker Studio for advanced dashboards
- Trigger Zapier workflows when new rows appear
- Build custom reports with Google Apps Script
- Share read-only views with external clients

## Support

<CardGroup cols={2}>
  <Card title="Allo Support" icon="/media/integrations/Allo.png" href="/help/support/contact">
    Help with setup
  </Card>
</CardGroup>
