I am trying to build a chat messenger (trigger) that consults the information contained in a vector database (pinecode) and until then there is no problem, the issue is that when I try to save the questions and answers in a Google Sheets, the response that appears in the chat is the JSON structure of the data that is going to be stored in the Google Sheets, how can I avoid that? Or failing that, what is the best way to save the information in a Google Sheets.
I already tried the option of formatting the output in AI agent and also giving it the instruction at the prompt to save a certain structure.