I’ve built a personal assistant that’s supposed to log described events into Google Sheets and also generate 5 pieces of advice based on the event, which are then sent to me via Telegram.
However, the issue is that the data isn’t being generated in JSON format, which prevents it from being properly recorded in Google Sheets.
Could you help me identify what I might have done wrong and how to fix it?
You can use an Output parser to parse the model output to json.
You can try using the Structured Output Parser that returns in JSON format.
I have the same issue and stumbled on this thread, solved it and returned to help.
Instead of adding Google Sheet as a Tool, add another node after the AI Agent, which is the Google Sheet, then you add the Telegram node after that. Hope that helps.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.