AI-Powered Cold Calling Automation with Vapi.ai, GPT-4o & Google Sheets

🎯 Use Cases

Sales & Business Development

Recruitment & HR

Customer Success

Market Research

⚙️ How it Works

Process 1: Call Initiation (Manual/On-Demand)

Process 2: Result Collection (Every 10 Minutes)

📋 Setup Instructions

Prerequisites

Step 1: Prepare Your Lead Database

Customer_id | Name | Phone Number | Email | Status | Recording URL | Transcript | Summary | Interest | Call Duration | Retry count | Last attempt | Call ID

Step 2: Configure Vapi AI Assistant

Step 3: Import & Configure Workflow

Step 4: Test & Deploy

🔄 Workflow Logic Explained

Status Flow Diagram

[New Lead: Pending] → [Call Initiated] → [Completed/Failed]
                                      ↓
                            [Retry Scheduled] ← (if failed & retry < 5)

Key Decision Points

📊 Node Reference Guide

Core Processing Nodes

Status Management Nodes

Control Flow Nodes

🛠️ Customization Guide

1. Modify Retry Strategy

// Add to Code node for progressive delays
const retryCount = $json["Retry count"];
const delays = {
  1: 30,    // 30 minutes
  2: 120,   // 2 hours
  3: 1440,  // Next day
  4: 2880,  // 2 days
  5: 10080  // 1 week
};
return { waitMinutes: delays[retryCount] || 60 };

2. Add Business Hours Check

// Add before HTTP Request node
const now = new Date();
const hour = now.getHours();
const day = now.getDay();

const isWeekday = day >= 1 && day <= 5;
const isBusinessHours = hour >= 9 && hour <= 17;

if (!isWeekday || !isBusinessHours) {
  throw new Error('Outside calling hours');
}

3. Enhance Lead Context

{
  "assistantId": "your-assistant-id",
  "phoneNumberId": "your-phone-id",
  "customer": {
    "number": "+{{ $json['Phone Number'] }}",
    "name": "{{ $json.Name }}",
    "customData": {
      "company": "{{ $json.Company }}",
      "lastPurchase": "{{ $json['Last Purchase Date'] }}",
      "accountValue": "{{ $json['Account Value'] }}",
      "preferredProduct": "{{ $json['Product Interest'] }}"
    }
  }
}

💡 Sticky Notes Configuration

Note 1: Status Progression

📊 LEAD STATUS FLOW:
Pending → Call Initiated → Done/Retry Scheduled
Retry Scheduled → Call Initiated → Done/Failed

⚠️ Max retries: 5 attempts
❌ Failed = No answer after 5 tries
✅ Done = Call completed with results

Note 2: Phone Format Requirements

📱 PHONE NUMBER FORMAT:
✅ Correct: +14155551234
❌ Wrong: (415) 555-1234
❌ Wrong: 415-555-1234

Must include:
- Plus sign (+)
- Country code
- No spaces or symbols

Note 3: Vapi Setup Checklist

🔧 VAPI CONFIGURATION:
□ Assistant ID copied from Vapi
□ Phone Number ID from Vapi
□ API Key in credentials
□ Credits available
□ Assistant tested in playground

Note 4: Performance Guidelines

⚡ OPTIMIZATION TIPS:
• Batch size: 10-20 leads
• Call hours: 9 AM - 5 PM local
• Delay between calls: 5 seconds
• Monthly archive old records
• Monitor Vapi credit usage

Common Issues & Solutions

📁 Required Files & Resources

🏷️ Tags & Categories

Primary Category

Workflow Tags

Use Case Tags

Integration Tags

🚀 Future Enhancements

Planned Features

Community Roadmap

📞 Support & Resources