Google Sheets Integration

Connecting Google Sheets

1. Go to Settings > Integrations.
2. Find Google Sheets and click Connect.
3. Sign in with your Google account and grant permission.
4. AIVO will create a new spreadsheet called "AIVO Call Log" in your Google Drive, or you can select an existing spreadsheet.
5. Click Save.

What Data Gets Logged

Calls Sheet

Every completed call adds a row with these columns:

Contacts Sheet

New contacts are logged with:

Setting Up Your Spreadsheet

Using the Auto-Created Spreadsheet

AIVO creates a properly formatted spreadsheet with the correct headers. No setup needed. Just connect and data starts flowing.

Using an Existing Spreadsheet

1. Your spreadsheet must have two sheets named "Calls" and "Contacts".
2. The first row of each sheet must contain the exact column headers listed above.
3. AIVO appends new rows below existing data. It never modifies existing rows.

Customizing Columns

On Professional and Enterprise plans, you can add custom columns:

1. Go to Settings > Integrations > Google Sheets > Configure.
2. Click Add Column.
3. Choose from available data fields or create a custom field.
4. Click Save.

Troubleshooting

Data Not Appearing

1. Check the integration status in Settings > Integrations.
2. If disconnected, reconnect and reauthorize.
3. Verify the spreadsheet still exists in your Google Drive.
4. Check that the sheet names ("Calls" and "Contacts") have not been renamed.

Missing Rows

• Data syncs every 60 seconds in batch. Short delays are normal.
• If rows are consistently missing, check your Google Drive storage quota. A full Drive prevents new writes.

Permission Errors

Disconnect, clear AIVO's access at myaccount.google.com/permissions, and reconnect.

Spreadsheet is Too Large

Google Sheets has a limit of 10 million cells. If your call volume is high:

• Archive older data to a separate spreadsheet monthly.
• Or use the AIVO API to pull data programmatically instead.