Problem with saving text in google sheets

[Mikolaj_Waz]

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?

Workflow

Promp

Test

[Mutasem]

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.

[Mikolaj_Waz]

I did as you advised but the data is still not saved in Google Sheet

Screen shot

[amirfahd]

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.