How can I retrieve call data from Vapi and route it to Google Sheets?

How To
1

When an AI agent initiates a call, there are four possible outcomes:

  1. Call transferred (This is straightforward and can be handled directly within Vapi)
  2. Voicemail
  3. No answer
  4. Lead response – e.g., Not Interested or Interested

I can use Make (Integromat) to update specific cells in Google Sheets based on route logic. However, my question is:

How do I fetch the call outcome data from Vapi in real-time or post-call to trigger the correct route in Make?

Are there any recommended or efficient solutions for this workflow?

2

Welcome to the Make community!

To do this, you can try using the Vapi “Watch End of Call Report” module —

Listens to end of call report from Vapi call via this webhook.

For more information about the Watch End of Call Report module and Vapi app, see the corresponding Integrations page and the Help Centre documentation.

Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

— @samliew