Agent not updating in Gsheets in the format i want :(

Support
1

Hey all!
i’ve been working on this agent which helps me scrape an X feed and then sue AI to summarize the content piece in a certain format that can be then appended into a g sheet. post the instructions, the agent keeps stalling at the updating to sheet part, throwing this error
”CSV parse error: Unable to auto-detect delimiting character; defaulted to ‘,’ “

Update: getting the result but on the sheet is appended row wise instead of column wise unlike a normal database despite specific instructions.

Would love some help with how to get this fixed!
heres the agent for your ref: https://app.mindstudio.ai/agents/x-scrape-for-content-database-bfecaae9/remix

2

Hi @vedantmenon,

Thanks for the post and the remix link!

There are two main issues with your current Generate Text block prompt:

  1. The prompt asks the model to output a JSON array
  2. The output example is plain text, not CSV-formatted text

The model is following your instructions and returning JSON, but the Update Google Sheet block expects CSV-formatted output.

How to fix it:

  1. Remove any mentions of JSON from the prompt and delete the output example
  2. Set the block’s output schema to CSV and include an example that uses commas to separate columns and new lines to separate rows
    image
    image750×535 34.2 KB