Extract data from excel to vapi
How can I make my Vapi bot read data from an Excel file to answer client questions? Any docs or examples for that?
VVapi does not support direct reading from Excel files, but you can use your Excel data by converting it to a supported format and uploading it as a Knowledge Base.
Here's how:
See the Knowledge Base setup guide for details.
Source:
Here's how:
- Convert your Excel file to CSV or TXT format.
- Upload the file in the Vapi dashboard under
Build > Files. - Associate the uploaded file with your assistant in the Knowledge Base section.
See the Knowledge Base setup guide for details.
Source:
⤵️ Mention @Vapi Support Bot for follow-ups 🐥
SIs there a way to do it with make or another tools. Because the excel with the informations will take too many tokens and it will cost a lot @Vapi Team @Duckie @Shubham Bajaj
VYes, you can use Make (Integromat) to connect your Excel data to Vapi and avoid uploading large files as a knowledge base.
Here's a high-level approach:
Source:
Here's a high-level approach:
- Set up a Make scenario to process your Excel file and expose the data via a webhook or API endpoint.
- Configure a Vapi custom tool or webhook to call this endpoint when a user asks a relevant question.
- Vapi will fetch only the needed data on demand, minimizing token usage and cost.
Source:
EUpload the file via the dashboard or API to the assistant’s knowledge base, or use tools like the query tool.
https://docs.vapi.ai/knowledge-base
https://docs.vapi.ai/knowledge-base
