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:
- 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
- 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.