plain-purple•5mo ago

How to get Vapi.ai to transfer information to Google Sheet?

So I'm building a cs agent for my client and I can't get the vapi agent to transfer the correct data on to the webhook. Anyone that can help me out?

8 Replies

Vapi•5mo ago

To transfer information from your Vapi.ai agent to Google Sheets, use the built-in Google Sheets Add Row Tool. In your assistant's configuration, add the following tool:

{
  "type": "google.sheets.row.append",
  "name": "addFeedback",
  "description": "Use this tool to add customer feedback to the feedback spreadsheet. Collect all required information (rating, comments, suggestions) before adding the row."
}

{
  "type": "google.sheets.row.append",
  "name": "addFeedback",
  "description": "Use this tool to add customer feedback to the feedback spreadsheet. Collect all required information (rating, comments, suggestions) before adding the row."
}

Make sure to set the correct spreadsheetId and range (like "Sheet1"). This will let your agent append data directly to your Google Sheet during calls.
See full setup steps in the documentation. Source: - Google Sheets Integration – Vapi Documentation

⤵️ Mention @Vapi Support Bot for follow-ups 🐥

xenial-black•5mo ago

Make sure your webhook responds in Vapi’s required JSON format with the correct toolCallId and result, responds quickly to avoid timeouts, aggregates data if possible.. https://github.com/VapiAI/example-webhook-handler

GitHub

GitHub - VapiAI/example-webhook-handler

Contribute to VapiAI/example-webhook-handler development by creating an account on GitHub.

Vapi•5mo ago

To ensure your Vapi agent transfers data to Google Sheets, your webhook must respond in the required JSON format with the correct toolCallId and result. Here’s a concrete example of a minimal response:

{
  "toolCallId": "YOUR_TOOL_CALL_ID",
  "result": {
    "success": true
  }
}

{
  "toolCallId": "YOUR_TOOL_CALL_ID",
  "result": {
    "success": true
  }
}

For a working example and setup instructions, see the Vapi example webhook handler on GitHub. Sources: - Google Sheets Integration – Vapi Documentation - VapiAI/example-webhook-handler (GitHub)

plain-purpleOP•5mo ago

@Kings_big💫 I'll pay you to teach me on how I can apply this? When you say my assistant's configuration where do i place that info specfficly?

Vapi•5mo ago

To add the Google Sheets tool to your assistant's configuration: 1. Go to the Vapi Dashboard and open the Assistants page. 2. Select your assistant, then navigate to the Tools tab. 3. In the dropdown, choose the Google Sheets tool and configure it as needed. 4. Click Publish to save. This is where you place the tool info so your assistant can use it during calls.
See full setup steps in the documentation. Source: - Google Sheets Integration – Vapi Documentation

plain-purpleOP•5mo ago

I did that It's not working, It's not adding any info on the google sheet

Vapi•5mo ago

If your Vapi assistant isn't adding info to your Google Sheet, make sure your webhook responds in the required format. Here’s the minimal response your webhook should send:

{
  "toolCallId": "YOUR_TOOL_CALL_ID",
  "result": {
    "success": true
  }
}

{
  "toolCallId": "YOUR_TOOL_CALL_ID",
  "result": {
    "success": true
  }
}

Check out the Vapi example webhook handler on GitHub for a working setup. This response is essential for the integration to work properly. Sources: - Google Sheets Integration – Vapi Documentation - VapiAI/example-webhook-handler (GitHub)

Shubham Bajaj•5mo ago

Hey! To help track down this issue, could you share: - The call ID - When exactly this happened (the timestamp) - What response you expected to get - What response you actually got instead
This would really help us figure out what went wrong!

How to get Vapi.ai to transfer information to Google Sheet?

Did you find this page helpful?