Objective

Automatically log every completed HuskyVoiceAI call into a Google Sheet for tracking, analytics, and reporting.

Workflow:
HuskyVoiceAI → (call.completed webhook) → Make.com → Google Sheets

Prerequisites

• HuskyVoiceAI account with Webhooks enabled

• Make.com account (Cloud or self-hosted)

• Google account with edit access to the target Sheet

• A Google Sheet prepared with headers

Step 1 – Create Google Sheet

1. Create a new Google Sheet named: HuskyVoice Call Log

2. Add headers in row 1:

event_id, event_type, created_at, call_id, status, direction, call_to, duration_seconds, agent_name, sentiment, interest_level, summary, next_steps, recording_url, call_transcript, triggered_at, completed_at

Step 2 – Create Make.com Scenario

1. Log in to Make.com → Create a new Scenario

2. Add Webhook → Custom Webhook module

3. Click Add → Custom Webhook → Create new webhook

4. Copy the generated webhook URL

5. Enable JSON parsing

Step 3 – Create HuskyVoiceAI Webhook

1. Log in to HuskyVoiceAI → Integrations → Webhooks → Add Webhook

2. Paste the Make.com webhook URL from Step 2

3. Select event: call.completed

4. Save the webhook

5. Trigger a test call to ensure HuskyVoiceAI sends data

Step 4 – Map and Transform Data in Make.com

1. Add a Set/Map module after the webhook

2. Map incoming JSON fields to Google Sheet columns:

• event_id → event_id

• event_type → event_type

• created_at → created_at

• call_id → data.call_id

• status → data.status

• direction → data.call_direction

• call_to → data.call_to

• duration_seconds → Number(data.call_duration_seconds)

• agent_name → data.agent_name

• sentiment → data.call_analytics.sentiment

• interest_level → data.call_analytics.interest_level

• summary → data.call_analytics.summary

• next_steps → data.call_analytics.next_steps

• recording_url → data.call_recording

• call_transcript → flatten data.call_transcript to text

• triggered_at → data.call_triggered_at

• completed_at → data.completed_at

Step 5 – Add Google Sheets Module

1. Add Google Sheets → Append Row module

2. Connect your Google account

3. Select the target Sheet and worksheet

4. Map the fields from Step 4 to the corresponding Sheet columns

5. Test by sending a sample row to the Sheet

Step 6 – Test & Activate

1. Trigger a test call in HuskyVoiceAI

2. Confirm a new row appears in Google Sheets

3. Publish the scenario to run automatically

Optional Enhancements

• Filter calls: Add an IF module to log only outbound or longer calls

• Prevent duplicates: Check event_id before appending a row

• Error handling: Use Make.com error handlers for retries