my chat agent only search data from google sheet by asking directly, also in prompts is told to do it before answer question.
Hello,
So this is a common issue, and I find using a system prompt can help more, rather than with the user message, have you tried this? Also, I know people use rag / vector store which is easier for AI agent to access, so one flow I done, it downloaded from google drive, and stored into superbase vector store, everytime the agent ran, it would remove old vector data and replace with new, and gather answer for the ai agent.
Btw, this can be effected by which llm model ure using, I stick with openai as I see most stable results with them.
Best regards,
Samuel
hi, i am using open ai as ai core with 4o mini, the problem is when i ask with chat from agent tell me sth about company data, if i said check about us google sheet is going to check and answer but if i do not say that is not checking it, but i have another sheet for my product and sales condistion all the time is ok and agent respond very well
Sure, if you want feel free to share the workflow,
@shayanshojaei
Can take further look please tag me, though.
I’d like to see the system prompts etc, and test here if you’d like.
Best regards,
Samuel
Can you try your workflow with a model like GPT 4.1 to see if that resolves the issue?