How can I use Google Sheets for a knowledge bot?
How can I use Google Sheets for a knowledge bot? Is there anyway to do this? using to fill an IA with knowledge/RAG?
4 Replies
Hey Pedro, you can't use Google Sheets using RAG because it lacks vector/embeddings functionality.
You'll need to use a third-party service like ChatNode (which is integrated with Typebot as a block) or OpenAI Assistants that's integrated into the Typebot OpenAI block for a knowledge bot using RAG. You can technically use Google Sheets as a knowledge bot, but I think it's a terrible idea for the following reasons: 1. Not-user friendly - You'll have to parse the data using something like Google Sheets API 2. REALLY Expensive - The bigger the knowledge, the more tokens/expensive it becomes because you'll have to send the entire knowledge base as a prompt to inform your LLM. 3. Memory limits - You'll face context window constraints. Once you exceed it, your LLM will "forget" or lose memory of your knowledge base. Hope this helps.
You'll need to use a third-party service like ChatNode (which is integrated with Typebot as a block) or OpenAI Assistants that's integrated into the Typebot OpenAI block for a knowledge bot using RAG. You can technically use Google Sheets as a knowledge bot, but I think it's a terrible idea for the following reasons: 1. Not-user friendly - You'll have to parse the data using something like Google Sheets API 2. REALLY Expensive - The bigger the knowledge, the more tokens/expensive it becomes because you'll have to send the entire knowledge base as a prompt to inform your LLM. 3. Memory limits - You'll face context window constraints. Once you exceed it, your LLM will "forget" or lose memory of your knowledge base. Hope this helps.
Thank you, @nefer_l for the answer. You are a good person!
Unfortunately OpenAI Assistants are deprecated and set to be removed in mid 2026... So I don't recommend relying on it atm
I know it's a gap missing on Typebot currently.
Solutions I suggest:
- Use Dify.AI block
- Use ChatNode
- If your knowledge can be summed up in a few paragraphs, you can directly add it to a system prompt
i will try to add on prompt. tks!