I am trying to utilize the generate text feature to send a message to a Google Sheets but my debugger keeps on failing the run and displaying this message: Error: CSV parse error: Unable to auto-detect delimiting character; defaulted to ‘,’. Does anybody have an idea about how to fix this?
Hi @aroberts27,
Thanks for the post!
Could you share screenshots of your Automations canvas and record a Loom of a sample run? Please include the Debugger in the recording so we can take a closer look at what might be causing the issue.
Based on what you’ve described so far, this thread might be helpful too:
(post deleted by author)
Hi @aroberts27,
Thank you for the screenshots!
It looks like you’re passing JSON to the Update Google Sheet block, but it’s expecting comma-separated values instead. You can check the expected format in the Spreadsheet Content field:
Feel free to remix this agent to see how the data should be structured:
https://app.mindstudio.ai/agents/update-google-sheet-d031c9c1/remix
So I managed to convert the data into CSV format, but another issue pops up. When the data is transmitted to the sheet, it includes the format presented in the CSV. Any idea on how to fix this?
