Assistant was able to fetch data from Google sheet...
# support
a
My assistant was picking data price from the sheet but now it is just going blank from last 3 hrs . Without any changes to the tool or assistant . I tried troubleshooting but it’s not fixing it
It was working fine from last 2 weeks
v
Important: The current Vapi Google Sheets integration only supports adding new rows—it does not support reading or fetching data from existing rows. If you need to fetch data, you'll need to implement a custom integration or use another tool that supports reading from Google Sheets. Reference: "The Google Sheets integration currently only supports adding new rows to spreadsheets. It does not support reading from or modifying existing data in the spreadsheet." For more help, consider joining the [Vapi Discord community](https://discord.gg/pUFNcf2WmH). Source: - [Vapi Docs: Google Sheets Integration](https://docs.vapi.ai/assistants/tools/google-sheets)
a
What do you mean by custom integration or other tool ? How was it even working fine from last 2 weeks then ?
a
It was likely working before because something outside of Vapi’s native Sheets tool—like an external workflow or API—was actually fetching the data. The built-in Vapi Google Sheets integration can only add new rows, not read existing ones. If that external process stopped or hit an error, that would explain why it’s showing blank now. I can help check your setup and pinpoint exactly what broke. @abhiking6
a
I had no external setup , just the vapi and my Google Sheets . Earlier when I used to call it was still adding data to Google Sheets but returning info based on my sample file of product and price . But from past 4 hours it just stopped , it was just telling fetching data price and pause then I changed the success message to not prompt data but still no change. Would be need assistant version or call logs of what worked and didn’t ?
I deleted the appended rows in my sheet to see if it would work like earlier but it still says I found the product but don’t have the price
So just confused what changed
a
That makes sense and explains why you’re confused. What likely changed isn’t something you actively did, but rather the state of the sheet or the assistant itself. Vapi’s Google Sheets tool can only add rows, so when it seemed to return prices before, it was probably relying on a cached reference from your sample data or the assistant remembering values in session. Now that rows were deleted or the assistant session refreshed, it no longer has anything to reference, so it can find the product but has no price to return. Yes having the assistant version and call logs from when it worked versus now would help pinpoint exactly what behavior changed and confirm why it’s failing. I can guide you through analyzing those to restore the previous functionality. @abhiking6
a
No what I meant is earlier I had 10 products and pricing and when I used to call for a price of one product , it would still add the product name to the sheet but on the call with would come back with the price now it just goes sllilent and it if I say are you there .. it tells I found the prod out but I don’t have the price
u
Did you check the call log and saw it fetch the data from google sheet in the log?
It might be a problem with your llm (just a guess), we might never know unless we take a look at it together… can you walk me through your testing process so we can troubleshoot it?
a
Ah, I see exactly what you mean now. What’s happening is that previously, your assistant was likely retrieving the price from the same session memory or sample data, not actually from the sheet, because Vapi’s Google Sheets tool cannot read existing rows. That’s why it could “return a price” even while still adding the product to the sheet. Now, something changed possibly the assistant session reset or the cached data expired so it no longer has that product-price info in memory. That’s why it can find the product but has no price to return, and it goes silent when asked. We can fix this by either feeding the assistant a fresh dataset for reference or by setting up a small workflow that actually fetches prices before responding.
a
Thank you heritage I was able to delete my tool and create the logic in make.com and integrate with vapi but now my issue is if I ask the price for something it is getting the data from make.com but now giving that info back till I ask a follow up question like “ hello are you there “ or something . I don’t see any where where I can turn off async
The custom tool gave me async option but there the issue is vapi is just jumping from message start to message fail in 1 sec
I am stuck because in both options some challenge is there . If you can help that would be great . In api request tool option I don’t see async off option or a way to do that … in custom tool option it is not even waiting for a second
a
you’re basically dealing with a response timing issue. Vapi is calling your Make.com flow, but it’s not waiting for the reply, so the price comes back after the assistant has already moved on. That’s why it only shows up when you send another message. The fix is to make sure your Make webhook returns the final answer immediately in the same request (not after any delay or extra processing). Once the response is returned instantly, Vapi will speak it in the same turn instead of waiting for a follow-up. @abhiking6
s
Hi, thanks for reaching out.
To investigate this further, could you please provide us with some of the affected call IDs?