VAPI + Google Sheets Integration for Outbound Calling System

PROJECT DESCRIPTION:
I'm looking for an experienced VAPI integration specialist to connect my AI calling system with Google Sheets and other essential tools for a property investment outreach project.
IMPORTANT: I already have a VAPI account set up and the AI assistant configured. I can make calls. What I need is help with the integrations and data flow.
REQUIRED INTEGRATIONS:
Google Sheets Integration (Bidirectional):
Pull data FROM Google Sheets for each outbound call: company name, director name, phone number, property addresses, previous transactions, financial data, investment focus
Write data BACK TO Google Sheets after each call: call summary (max 60 words), conversation outcome (positive/negative/neutral), willingness to sell rating (high/medium/low/none), property-specific information, next steps
Real-time sync - Google Sheets acts as the central database
Calendar Integration:
When a prospect agrees to a meeting during a call, the AI should be able to create a calendar appointment automatically
Integration with Google Calendar (or similar)
Capture date, time, and contact details
Inbound Call Recognition:
When someone calls back, the system should recognize their phone number
Match the number to the correct contact/row in Google Sheets
Pull up their information so the AI knows who they are and what was discussed previously
Continue the conversation with full context
SMS Capability (Two-Way Texting):
Send text messages to contacts when requested during calls
Receive and log text message responses
Associate all SMS communication with the correct contact in Google Sheets
Call Recording, Transcription & Summary:
Configure call recording (if not already set up)
Automatic transcription of all calls
Generate call summaries using a custom format and write them back to Google Sheets
DATA FLOW SUMMARY:
Google Sheets → VAPI (pulls lead data) → AI makes call → Call outcome, summary, SMS, calendar booking → All data writes back to Google Sheets in real-time
WHAT'S ALREADY DONE:
✅ VAPI account set up
✅ AI assistant configured and can make calls
✅ Custom prompts and knowledge base documents prepared
WHAT I NEED:
❌ Google Sheets integration (read and write)
❌ Calendar integration
❌ Inbound call recognition and contact matching
❌ SMS two-way texting
❌ Call recording/transcription/summary configuration (if not already active)
PROJECT REQUIREMENTS:
Must have proven experience with VAPI integrations - please provide examples of past projects
Experience with Google Sheets API and bidirectional data sync
Experience with calendar APIs (Google Calendar or similar)
Experience with SMS integration (Twilio or similar)
Ability to work quickly and efficiently
Clear communication and ability to explain technical setup
TIMELINE:
I'm looking to complete this project as quickly as possible. Please provide your realistic timeline in your proposal.
TO APPLY:
Please include in your proposal:
Examples of past VAPI integration projects you've completed (links, screenshots, or case studies)
Your estimated timeline to complete all integrations
Your total cost (fixed price preferred)
Any questions you have about the project requirements
I will only accept proposals from freelancers with a proven track record of VAPI or similar AI calling system integrations. Please do not apply if you do not have relevant experience.
BUDGET:
Open to proposals - please provide your best quote based on the scope outlined above.