Google Sheets Connector

Automatically push call data to Google Sheets for easy reporting and sharing.

Overview

The Google Sheets Connector automatically pushes call data to a Google Sheet whenever a call comes in. This is great for teams that live in spreadsheets or need to share call data with people who don't have CallScaler access.

Setting Up

1. Enable the Google Sheets addon from the Addons page
2. Create a new Google Sheet (or use an existing one)
3. Configure the webhook URL in your Google Sheet (using Apps Script) to receive data from CallScaler
4. In CallScaler, add your Sheet's webhook URL
5. Select which tracking numbers should push data to the sheet

What Gets Pushed

Each call creates a new row in your sheet with:

  • Date and time
  • Caller phone number
  • Tracking number called
  • Call duration
  • Call status (answered, missed, voicemail)
  • UTM source, medium, campaign
  • Landing page URL
  • Recording URL