CSV output from Generate Text Block

Agents
1

I have a Generate Text Block with a detailed prompt that I have been using successfully outside of MindStudio to create a CSV formatted list of resources. When I use it inside the Generate Text Block, the output looks like the example below instead of a tabular CSV layout. I have the formatting instructions clearly stated in the prompt and the output of the block set to CSV. What am I missing?

Mora Valley Community Health Services

  • Services: Integrated Behavioral Health Individual Counseling Family Counseling Substance Use Counseling Telehealth
  • Cost: Sliding Scale Medicaid Medicare
  • Eligibility: Open to all; proof of income may be required for sliding fee
  • Description: Primary care clinic with integrated behavioral health services including counseling and support for mental health and substance use needs.
  • Website: https://pmsnm.org/locations/mora-valley-community-health-services
2

Hi @ResearchRunner,

Thanks for the post!

Could you share the Debugger logs for the run? To do that, open the Debugger, select the run, click Share, and reply with the URL:

image
image777Ă—616 78.9 KB

Please make sure there’s no sensitive information in that run, as the shared log will be public.

3

Alex,

Thanks for looking at this so quickly. Here’s a link to the debugger log.

https://app.mindstudio.ai/share/debugger/682ea43d-1a63-4d2e-9a16-e699480ec1d0/3237b7fe-8855-4568-895b-8a9377618b35

4

Hi @ResearchRunner,

Thanks for sharing the link.

From what I can see, the first two Generate Text blocks output data in CSV, followed by a Merge Text block that uses AI to merge the data from the variables. Since the Notes field is empty, the model isn’t instructed to preserve CSV formatting, which is why the output loses its structure.

How to fix:

  1. You can specify that AI has to preserve csv formatting in the Notes section of the Merge Text block, for example:
  • Preserve the original formatting and don’t change the data
  • The output must be valid CSV
  1. Or skip merging and reference both Generate Text output variables directly in the Spreadsheet Content field of the Create Google Sheet block

Also, please note that only the Perplexity models can search the web. Other models rely on their training data, which may be outdated, so they might not return the most recent information.

5

Thank you. This advice helped a lot.

1 Like