Help Please🙏 · Brendan's AI Community

Help Please🙏

Hey everyone, I’ve been working on a voice assistant using VAPI that collects a caller’s name, phone number, and call summary, then sends that data to Make via a webhook to update a Google Sheet. However, I’ve been running into several frustrating issues, even though my lead_capture tool is being triggered successfully (confirmed in the logs):

Timestamp Issue

The timestamp value being sent in the payload is stuck showing an old date from 2023 instead of the current call time. I’ve added instructions in the prompt to generate a dynamic ISO timestamp, but it’s still not updating with each new call.

Data Not Extracted in Analysis Section

Even when the tool is called and I see values like caller_name, caller_number, and call_summary in the logs, the Analysis tab just shows "N/A" under Data. This makes it hard to confirm that the assistant is properly capturing variables.

Google Sheets Not Updating

Although the payload reaches Make (confirmed in the webhook log), the spreadsheet doesn't reflect any new entries. I suspect the field names might have mismatched casing or weren’t properly refreshed in Make, but reinitializing didn’t solve it.

Lead Capture Tool Is Being Called

I’ve confirmed from the logs that the lead_capture tool is being called, and the payload structure looks valid. But somehow, none of the data seems to be making it through to the final spreadsheet.

If anyone has dealt with this kind of issue — especially around dynamic variable capture, timestamp generation, or Make not updating despite receiving a payload — I’d really appreciate any advice or insights. Thanks!

4 comments