Objective

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

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

Prerequisites

• HuskyVoiceAI account with Webhooks enabled

• Zapier account (or Make.com)

• Google account with edit access to the target Sheet

• A Google Sheet prepared with headers

Step 1 – Prepare 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 Zapier Webhook

1. Log in to Zapier → Create a new Zap.

2. Select Trigger → Webhooks by Zapier → Under trigger event , Catch Hook.
   

3. Pick off a Child Key should be left as it is i.e empty

4. Copy the custom webhook URL generated by Zapier.

5. This URL will be used in HuskyVoiceAI.

Step 3 – Create HuskyVoiceAI Webhook

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

2. Paste the Zapier 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 – Add Google Sheets Action

1. Add Google Sheets → Action Event → Create Spreadsheet Row action

2. Connect your Google account
   
   
   

3. Select the target Sheet and worksheet

4. Test and then publish

Step 5 – Test & Activate

1. Trigger a test call in HuskyVoiceAI

2. Confirm a new row is created in Google Sheets

3. Turn on the Zap to run automatically

Optional Enhancements

• Filter calls: Log only outbound or longer calls using Zapier Filter

• Prevent duplicates: Check event_id before creating a row

• Error handling: Retry failed webhook attempts