Skip to main content

​
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

1

Create a Google Sheet

On your computer or phone, create a new Google Sheet
2

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
3

Open Allo app

Launch Allo on mobile or desktop
4

Go to Integrations

Navigate to Settings > Integrations
5

Find Google Spreadsheet

Locate Google Spreadsheet in the integrations list and tap Connect
6

Paste the URL

Paste your Google Sheet URL (the link you copied)
7

Save and activate

Tap Save to activate the sync
The Google Sheet must be set to “Anyone with the link can edit” for the integration to work.
Allo automatically creates column headers on first use. New calls appear as rows in real-time.

​
How it works

Real-time logging

Every call logs to your spreadsheet within seconds after ending.

Automatic columns

Allo creates column headers automatically on first sync.

Recording links

Each row includes a clickable link to the call recording.

Export ready

Download as CSV or Excel anytime for external analysis.

​
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: 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

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)

​
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

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
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.
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.
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
To reconnect the integration:
  1. Go to Settings > Integrations > Google Spreadsheet
  2. Tap Disconnect
  3. Follow the connection steps again

​
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
Disconnecting stops new calls from logging. Existing data in the spreadsheet remains unchanged.

​
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

Allo Support

Help with setup