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 ($10/mo).
2. Create a new Google Sheet (or use an existing one) and add a CallScaler-supplied Apps Script that exposes a webhook URL.
3. Deploy the script as a Web App and copy its /exec URL.
4. In CallScaler, open Addons → Google Sheets and expand the Setup Guide for step-by-step Apps Script code.
5. Click + Add Sheet, give the connection a name, paste the webhook URL, and optionally name the destination tab.
6. Use the flask icon next to a connected sheet to push a test row and confirm everything is wired up.
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
On this page