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

https://mintcdn.com/themobilefirstcompany/4JKVqOLduvlaK6pG/media/integrations/Allo.png?fit=max&auto=format&n=4JKVqOLduvlaK6pG&q=85&s=de5eaa45a01e052c9506804098dbb8ce

Real-time logging

Every call logs to your spreadsheet within seconds after ending.
https://mintlify.s3.us-west-1.amazonaws.com/themobilefirstcompany/media/integrations/GoogleSheets.svg

Automatic columns

Allo creates column headers automatically on first sync.
https://mintcdn.com/themobilefirstcompany/4JKVqOLduvlaK6pG/media/integrations/Allo.png?fit=max&auto=format&n=4JKVqOLduvlaK6pG&q=85&s=de5eaa45a01e052c9506804098dbb8ce

Recording links

Each row includes a clickable link to the call recording.
https://mintlify.s3.us-west-1.amazonaws.com/themobilefirstcompany/media/integrations/GoogleSheets.svg

Export ready

Download as CSV or Excel anytime for external analysis.

​
Spreadsheet structure

Allo creates these columns automatically:
ColumnContent
DateCall date and time
Contact NameName from Allo contacts
Phone NumberCaller’s phone number
DirectionInbound or Outbound
DurationCall length in minutes:seconds
OutcomeAnswered, Voicemail, Missed
SummaryAI-generated call summary
RecordingLink to audio file
TranscriptLink to full transcript

​
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

  • Allo to Google Sheets
  • Google Sheets to Allo
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 wor