https://vapi.ai/ logo
Join Discord
Powered by
How to get Vapi.ai to transfer information to Goog...
# support
j
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?
v
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:
Copy code
json
{
  "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.](https://docs.vapi.ai/tools/google-sheets) Source: - [Google Sheets Integration – Vapi Documentation](https://docs.vapi.ai/tools/google-sheets)
k
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
v
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:
Copy code
json
{
  "toolCallId": "YOUR_TOOL_CALL_ID",
  "result": {
    "success": true
  }
}
For a working example and setup instructions, see the [Vapi example webhook handler on GitHub](https://github.com/VapiAI/example-webhook-handler). Sources: - [Google Sheets Integration – Vapi Documentation](https://docs.vapi.ai/tools/google-sheets) - [VapiAI/example-webhook-handler (GitHub)](https://github.com/VapiAI/example-webhook-handler)
j
@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?
v
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.](https://docs.vapi.ai/tools/google-sheets) Source: - [Google Sheets Integration – Vapi Documentation](https://docs.vapi.ai/tools/google-sheets)
j
I did that It's not working, It's not adding any info on the google sheet
v
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:
Copy code
json
{
  "toolCallId": "YOUR_TOOL_CALL_ID",
  "result": {
    "success": true
  }
}
Check out the [Vapi example webhook handler on GitHub](https://github.com/VapiAI/example-webhook-handler) for a working setup. This response is essential for the integration to work properly. Sources: - [Google Sheets Integration – Vapi Documentation](https://docs.vapi.ai/tools/google-sheets) - [VapiAI/example-webhook-handler (GitHub)](https://github.com/VapiAI/example-webhook-handler)
s
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!
2 Views
PreviousNext
Powered by