I usually use Make.com to send these data to a sheet but I wanted to move out of Make.com and have it done entirely on Vapi. Is there a way this is possible ?

Hi there! 👋 I wasn't able to find information about a specific "Google Spreadsheet tool" in VAPI that would directly append call transcripts to Google Sheets. However, I can help with how to access call transcripts and potential ways to integrate VAPI with Google Sheets without using Make.com. ## Accessing Call Transcripts in VAPI You can access call transcripts in VAPI through several methods: 1. **Using the GET /call/:id endpoint**:

json
   {
     "artifact": {
       "transcript": "Full conversation transcript",
       "recordingUrl": "https://storage.url/recording.wav",
       "stereoRecordingUrl": "https://storage.url/stereo-recording.wav",
       "messages": [
         // Array of conversation messages
       ]
     }
   }

This endpoint returns the full transcript within the artifact object [Discord conversation](https://discord.com/channels/1211482211119796234/1211483291191083018/threads/1341440757189578782). 2. **Using server messages for real-time transcripts**: Configure

serverMessages

to include "transcript" for real-time transcriptions and "end-of-call-report" for the final transcript [Discord conversation](https://discord.com/channels/1211482211119796234/1211483291191083018/threads/1341440757189578782). ## Integrating VAPI with Google Sheets (Without Make.com) According to the information I found, there's no direct method to upload a spreadsheet to make calls, but you can integrate VAPI with Google Sheets using the API [Discord conversation](https://discord.com/channels/1211482211119796234/1211483291191083018/threads/1340055555582201917). The most promising alternative to Make.com appears to be using VAPI's API Request task within Workflows: 1. The API Request task enables your workflow to interact with external APIs, including Google Sheets API [VAPI documentation](https://docs.vapi.ai/workflows/tasks/api-request). 2. It supports both GET and POST methods, which you would need for appending data to Google Sheets.

I created the Google sheet as a tool, added it to the assistant, did everything correct as explained here: https://docs.vapi.ai/tools/google-sheets Still the Google sheet is not being appended.

Ensure the spreadsheet ID and range are correct, the tool is added and published in your assistant, your Google account is connected in Vapi’s dashboard, and the data matches the expected schema.