I want to record the call transcription to google sheet in real-time. How can I do this?

To record call transcriptions to Google Sheets in real-time with Vapi, configure your assistant to receive real-time transcripts via webhooks:

json
{
  "serverMessages": [
    "transcript",
    "end-of-call-report"
  ]
}

Then create a server endpoint that receives these transcripts and uses the Google Sheets API to append each transcript to your sheet. Your server will receive messages in this format:

json
{
  "message": {
    "type": "transcript",
    "transcript": "User's speech text",
    "role": "user",
    "transcriptType": "final"
  }
}

Source: - [Real-time Transcriptions via Server Messages](https://discord.com/channels/1211482211119796234/1341440757189578782)

Message marked as helpful by @! AetherMind! 🎉

checking if this is resolved/solved for you?

almost

To record call transcriptions to Google Sheets in real-time, either use Vapi’s built-in Google Sheets integration by setting up the Google Sheets tool or automate it via Make.com to send data to a sheet during calls.

Of course. I am using vapi's built-in google sheet tools. But unfortunately, that's not working prfectly, some conversation is not recorded.

Send your call id

Thanks @Kings_big💫 , Thi is My call id: ba0437e2-c0ac-4e26-976a-6d87bacc7771

Looking into it

Thanks

Use End-of-Call report to fill in the transcripts at the end of the call instead, directly into their Google Sheets. For reference, take a look at the community video

HOW TO USE VAPI TOOL FOR THIS. I HAVE CEATED GOOGLE SHEET TOOL. NOW WHAT TO DO?

To set this up, connect the tool to an assistant, grab the sheet ID from the Google URL, and choose the range where you want the data to go, as mentioned in the text box. In the assistant prompt, make sure to call the tool by name (for example, 'google_sheet_tool') and specify what data to input into the sheet. If you need any help with this, just let us know.

if you have not clear point to use Google sheet, feel free to ask

Hey Tyler, mind providing some more data like where exactly you are facing the issue with setting up? Also, a loom video will be helpful.

Hi there, I have my google sheet API integration connected with my vapi. The tool is selected and being called. I have in my sheet just two columns (Customer Phone Number and Ended Reason). After each call ends, it's not keeping any record of this. This is what I have in my system prompt: "When the call has ended, call the google_sheets_tool to do the following. Populate the data into the following columns using end-of-call-report. Customer Phone Number Ended Reason" And its the same for the tool's description. What is it that im missing? I will appreciate your help.

Could you please provide a call id? We have a suspicion that the tool is not executing before the call ends.