
Completed
Posted
Paid on delivery
PROJECT DESCRIPTION: I need a [login to view URL] specialist to build the automation layer of my AI outbound lead qualification system. The VAPI agents are already built and tested by me. The Google Sheets structure is already designed. You are building the [login to view URL] scenarios that connect everything together. HOW THE SYSTEM WORKS: I add a lead to a Google Sheet with Status = New. [login to view URL] detects it, fires a VAPI outbound call, processes the outcome, handles retries, and when a meeting is booked it creates a Google Calendar event and sends a Gmail confirmation. I add one row and everything else runs automatically. WHAT YOU ARE BUILDING - THREE [login to view URL] SCENARIOS: Scenario 1 - New Lead Trigger Watch Google Sheet every 15 minutes for rows where Status = New. Fire VAPI outbound call via HTTP POST using my provided API details. Update the row: Status = Attempting, Attempt Count = 1, Last Attempt = current timestamp. Scenario 2 - Step 1 Call Outcome Processor Receive VAPI webhook after call ends. Parse JSON output from call transcript. Route by outcome as follows. - Not Interested: update sheet Status = Dead - Scheduled: update sheet Status = Scheduled, write preferred call time and ISO datetime to specified columns - No Answer or Busy: increment Attempt Count. If count is less than 3, delay 60 minutes and re-fire VAPI call. If count equals 3, set Status = Dead. Scenario 3 - Step 2 Scheduler and Booking Watch Google Sheet every 15 minutes for rows where Status = Scheduled and preferred DateTime column falls within the next 20 minutes. Fire VAPI Step 2 outbound call. Receive Step 2 webhook. Parse JSON. Route by outcome as follows. - Booked: create Google Calendar event with meeting details, send Gmail confirmation to lead, update sheet Status = Booked, write pain points, lead score, meeting datetime, calendar event ID, and email sent = Yes - Busy: flag row for human review - Not Interested: update Status = Dead WHAT I PROVIDE ON DAY ONE: - Google Sheet already built with all columns and dropdowns, you get editor access - VAPI API key and both agent IDs ready to use - Exact JSON output structure from both VAPI agents so you know exactly what fields to parse - Gmail account connected and ready - Google Calendar access ready - Full technical specification document covering every field, every route, and every column reference WHAT IS NOT IN SCOPE - DO NOT PRICE THESE: VAPI setup, SIP trunk, WhatsApp, UAE phone number, reporting dashboard, any CRM beyond Google Sheets PAYMENT TERMS: Single milestone. Single payment. Released only when I personally add one dummy lead to the sheet with Status = New and without touching anything else I see the following happen. VAPI fires the call. Outcome updates the sheet correctly. Step 2 fires at the scheduled time. Google Calendar event appears in my calendar. Gmail confirmation lands in the test inbox. Full cycle confirmed. I approve and release payment. LOOM VIDEO REQUIRED: Walkthrough video of all three scenarios minimum 8 minutes explaining what each scenario does and how to troubleshoot if something stops working. ACCOUNT OWNERSHIP: You build inside my accounts. Not yours. All credentials stay with me throughout and after the project. HOW TO APPLY: Share a screenshot or short Loom of a [login to view URL] scenario you have previously built that includes a webhook receiver and a conditional router. Applications without this will not be reviewed. Full SRD shared immediately on award. TIMELINE: 3 to 5 days from project start
Project ID: 40474952
36 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

100% doable, Using vapi for 2+ years for my clients and here's the proof for [login to view URL] and n8n where we did Outbound calling [login to view URL] And for the rest of the process, let's setup a script in sheets so whenever you input a new lead, instead of wasting 15 mins, make takes it automatically and fires assistant overrides Vapi API with all the dynamic variables. And on the other hand we simply have all the end-call-report anotehr scenario where we parse json and get exactly what we desire. Completely doable, as I said, less than 24 hours job. Let's do it.
$85 USD in 1 day
5.0
5.0

Dubai, United States
Payment method verified
Member since Oct 7, 2019
$8-15 USD / hour
₹100-400 INR / hour
₹1500-12500 INR
₹12500-37500 INR
$10-30 USD
₹1500-3000 INR
₹1500-12500 INR
$15-25 USD / hour
₹1500-12500 INR
₹600-1500 INR
€750-1500 EUR
$25-50 USD / hour
$250-750 AUD
₹12500-37500 INR
₹12500-37500 INR
$2-8 USD / hour
$8-15 USD / hour
$250-750 USD
$10-30 USD
$250-750 AUD
₹12500-37500 INR