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

thoughtless-moccasin · 2025-05-25T09:47:28.716Z

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

Vapi Support BotAPP•5/25/25, 9:49 AM

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."
}

{
  "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

spreadsheetId

spreadsheetId

spreadsheetId and

range

range

range

range (like

"Sheet1"

"Sheet1"

"Sheet1"

"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 🐥

E

extreme-purple•5/25/25, 9:52 AM

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.

V

Vapi Support BotAPP•5/25/25, 9:54 AM

To ensure your Vapi agent transfers data to Google Sheets, your webhook must respond in the required JSON format with the correct
toolCallId
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
  }
}

{
  "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:

T

thoughtless-moccasinOP•5/25/25, 9:58 AM

@Kings_big

I'll pay you to teach me on how I can apply this?

Lltd-scarlet To transfer information from your Vapi.ai agent to Google Sheets, use the built-...

T

thoughtless-moccasinOP•5/25/25, 1:15 PM

When you say my assistant's configuration where do i place that info specfficly?

V

Vapi Support BotAPP•5/25/25, 1:17 PM

To add the Google Sheets tool to your assistant's configuration:

Go to the Vapi Dashboard and open the Assistants page.
Select your assistant, then navigate to the Tools tab.
In the dropdown, choose the Google Sheets tool and configure it as needed.
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

T

thoughtless-moccasinOP•5/25/25, 1:19 PM

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

V

Vapi Support BotAPP•5/25/25, 1:20 PM

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
  }
}

{
  "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:

V

VapiAPP•5/26/25, 5:36 AM

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?

Similar Threads

Similar Threads

Similar Threads