Quick overview
This workflow triggers an outbound AI voice call via Vapi and then logs the completed call’s status and key details to Google Sheets when Vapi posts the call result back to an n8n webhook.
How it works
- Starts manually to initiate a call run and provide input data.
- Sets the customer phone number from the incoming data or a fallback test value.
- Sends a POST request to the Vapi API to place an outbound call using your Vapi assistant ID and Vapi phone number ID.
- Receives the finished call result from Vapi via a webhook callback.
- Appends the call metadata (timestamp, customer number, assistant name, industry, status, end reason, cost, last message, and Vapi call ID) to a Google Sheets “Call Log” sheet.
Setup
- Create a Vapi account, then copy your Vapi API key, assistant ID, and phone number ID into the HTTP request node (Authorization header and JSON body).
- Configure the Vapi assistant/server webhook to send call results to this workflow’s production webhook URL.
- Connect Google Sheets OAuth2 credentials and replace YOUR_GOOGLE_SHEET_ID, the target spreadsheet, and the “Call Log” sheet/tab as needed.
- Provide the customer phone number input (or replace the fallback YOUR_TEST_PHONE_NUMBER) and adjust the country code formatting in the Vapi call request if required.