Vapi AI & Google Sheets Cold Call Automation - Automate Cold Calls with Vapi, Google Sheets, and Make.com Integration

Job ID: 38928463

Budget: $30 – $250 USD

I'm looking for an experienced automation expert to help me set up a workflow using Make.com, Google Sheets, and Vapi.ai.

I want to build a system similar to the one shown in this video:
https://www.youtube.com/watch?v=WS4QJF9Bn7U

Goal:
Create a system where:
- A bot pulls contact data (name, phone number, address) from Google Sheets.
- Vapi's AI makes automated cold calls dynamically using the data.
- The bot updates Google Sheets with call results, notes, and lead status (interested, not interested, follow-up needed).

Key Features I Need:
- Integration between Google Sheets and Vapi via Make.com.
- Vapi bot dynamically references fields (like firstName, address, city, property type, market value, etc) during calls.
- Call notes and responses are logged back to the appropriate row in Google Sheets after each call.
- Automatic call scheduling based on lead lists.
- Status columns in Google Sheets that update automatically based on call outcomes.

Skills Required:
- Make.com (formerly Integromat)
- Google Sheets Automation
- API Integrations (Vapi.ai)
- Python or JavaScript (Optional, for custom scripts)
- Experience with CRM or lead management automations is a plus

Project Deliverables:
- Fully functional Make.com workflow automating the Vapi and Google Sheets integration.
- Documentation or a walkthrough on how to modify/update the automation.
- Testing to ensure calls are logged correctly, and notes are updated in Sheets.
- A simple dashboard in Google Sheets to track call results and lead progress.