https://vapi.ai/ logo
Join Discord
Powered by
Google sheet checking during call
# support
h
Can I do this during call it will check my Google sheet that nextcalldate and meeting date exist or not and when call it already know my number and name
@Vapi
@Vapi Support Bot
v
Currently, Vapi's Google Sheets integration only supports adding new rows, not checking for existing data during a call. If you want to check if "nextcalldate" or "meeting date" exist for a caller, you would need to set up a custom server endpoint that your assistant can call to perform this lookup. Example:
Copy code
js
// Pseudocode for a custom tool
POST /check-dates
{ "phone": "{{customerPhone}}", "name": "{{customerName}}" }
This endpoint would query your Google Sheet and return the relevant info to your assistant. For now, direct read/check from Google Sheets within Vapi is not natively supported ([see docs](https://docs.vapi.ai/tools/google-sheets)). Source: - [Google Sheets Integration](https://docs.vapi.ai/tools/google-sheets)
Currently, Vapi's Google Sheets integration only supports adding new rows, not checking for existing data during a call. If you want to record call details, you can use the following tool configuration to append a row:
Copy code
json
{
  "type": "google.sheets.row.append",
  "spreadsheetId": "YOUR_SPREADSHEET_ID",
  "range": "Sheet1",
  "values": ["{{callerName}}", "{{callerNumber}}", "{{nextcalldate}}", "{{meetingdate}}"]
}
For checking if a date exists, you would need a custom backend API to read from Google Sheets and connect it as a custom tool in Vapi. [See Google Sheets integration details](https://docs.vapi.ai/assistants/tools/google-sheets) Source: - [Google Sheets Integration](https://docs.vapi.ai/assistants/tools/google-sheets)
h
I created cold calling agent in python with vap api which call on those numbers which is in sheet and store the call logs in sheet but during call it should know that what is my name if I give any call or meeting time so it should check that this already booked or not
@Vapi
@Vapi Support Bot
v
To check if a meeting or call time is already booked during a call, create a custom backend API (e.g., in Python) that queries your Google Sheet, then connect it as a custom tool in Vapi. Example tool configuration:
Copy code
json
{
  "type": "apiRequest",
  "name": "checkBooking",
  "url": "https://your-backend.com/check-booking",
  "method": "POST",
  "body": { "phone": "{{callerNumber}}", "date": "{{meetingdate}}" }
}
Your backend should return whether the date is available, and your assistant can use this info in the conversation. [See Google Sheets integration details](https://docs.vapi.ai/assistants/tools/google-sheets) Source: - [Google Sheets Integration](https://docs.vapi.ai/assistants/tools/google-sheets)
h
So how will I use custom tool
@Vapi Support Bot
v
To use a custom tool in Vapi, add an API tool to your assistant's configuration that points to your backend endpoint. For example:
Copy code
json
{
  "type": "apiRequest",
  "name": "checkBooking",
  "url": "https://your-backend.com/check-booking",
  "method": "POST",
  "body": { "phone": "{{callerNumber}}", "date": "{{meetingdate}}" }
}
This lets your assistant call your backend during a conversation to check bookings. Just replace the URL and parameters as needed for your setup. [See more in the docs](https://docs.vapi.ai/assistants/tools/google-sheets) Source: - [Google Sheets Integration](https://docs.vapi.ai/assistants/tools/google-sheets)
h
this is my python code and tool and I also added at assistant tools and this is conversation Assistant Hello. This is Morgan from Growth Partners. We help businesses improve their operational efficiency through custom software solutions. Do you have a few minutes to chat about how we might be able to help your business? User It doesn't mean all the names which is in Google Sheet. Assistant I understand there might be some confusion, Um, could you tell me a bit more about, uh, the issue you're encountering? User I'm saying I'm saying, can you tell me all the names? Which is in Google Sheet? Assistant At the moment, I can't directly read the names from the Google Sheet for you. If you'd like, I can assist. By ensuring data from a specific sheet is accessible or exporting specific rows of● User But● Assistant is accessible or exporting specific rows of information User What are you to find what I defined custom tool where I added the the URL. Assistant It sounds User custom URL. Assistant I understand you're referring to specific Google Sheets. With a custom URL. However, I don't have direct access, uh, to open or read the contents of a URL directly. If there's specific data you need, you could manually retrieve it Or if there's a function needed within a defined tool you want me to use, please let me know how I can help with that. https://cdn.discordapp.com/attachments/1425799018726035517/1425839775763533935/app.py?ex=68e90c45&is=68e7bac5&hm=9e6df02b1eb5c6c78a07661ef897dcde7f16d86aa963c3d3d0f5f951882e19cc& https://cdn.discordapp.com/attachments/1425799018726035517/1425839776249942017/screencapture-dashboard-vapi-ai-tools-2a4b9404-42b0-4280-841c-da5f3b8e55fe-2025-10-09-18_36_15.png?ex=68e90c45&is=68e7bac5&hm=89ba33f9105827803f5e657ee7fd1bc6a528e59d3adf60e367d99705f4e63de4&
why not working @Vapi Support Bot
this error i am getting Your server rejected 
tool-calls
webhook. Error: Request failed with status code 404
@Vapi Support Bot
c
We apologize for the delay in responses lately. We are in process of making some changes to our workflow in how we handle support requests. The good news is that we are starting to get back on track of having a 48 hour response time and we would like to start cleaning up anything old. With that being said, just wanted to check in with you to see if you have made any progress or changes to your project since support has last reached out.
PreviousNext
Powered by