Hi guys! I’m trying to build an automated cold outreach system where perplexity or chatgpt (I currently am paying for perplexity tho) analyzes prospects from my google sheet and generates a personalized cold outreach e-mail. I ran into a problem when trying to parse the results from perplexity so th…

Hello @Esma , Thanks for all the information you provided. I tested with ChatGPT, and it worked [image] And this is how I configured the completion [image] As you can see, I used the System role to tell it to generate a JSON with the fields I want. The last “JSON Object” field is not really u…

Hello! Welcome to the Make Community! Can you please show an example output of the Perplexity Module, as well as the configuration of your parse JSON? Benjamin

Hi @Esma provide the output bundles from each module (Google sheet and Perplexity module). also make sure the cell that has data is correctly mapped to Perplexity module. provide scenario (also both input and output bundles) for more clarification to the query.

Hi! Here are the screenshots: [Screenshot 2024-06-25 at 15.36.52] [Screenshot 2024-06-25 at 15.36.42] [Screenshot 2024-06-25 at 15.36.34] [Screenshot 2024-06-25 at 15.36.22] [Screenshot 2024-06-25 at 15.39.43]

Hi! I added some screenshots above and here are some more from Sheets and iterator: [Screenshot 2024-06-25 at 15.38.15] [Screenshot 2024-06-25 at 15.38.07]

Hello @Esma , Thank you for all these details! Apparently, the Body field Perplexity generates contains “carriage returns / line feeds”, which breaks the Parse Json. You don’t need to create any Data Structure for the JSON Parser. One weird idea I have. I will let @Anshul_Soni tell us if he finds…

Hi! Thank you so much for the feedback! I tried it and unfortunately I got the same error. Only when I removed any formatting, and used your string for the parser, did I get the result from the screenshot, but again with an error that source is not a valid JSON: …

Hello. I can see that I gave you a wrong workaround because when doing so, it also replaced the new lines between subject and body… which breaks the original JSON… Can you try and ask perplexity to « replace any new line in body by || » Or another: « Escape any new line character » The goal is …

Hi! Perplexity sometimes ignores my request to not add intros, outros and recaps, only the pure e-mail template and it breaks the JSON again. It also keeps doubling up the || characters, which is quite weird. I’m using a small model adapted for online searching, maybe I should use a bigger one and t…

Oh darn! I forgot to set the system message! Ok now I see the same output coming out of perplexity but still an error with the JSON parser. I think I didn’t set up the parser correctly. Here are my screenshots now: [Screenshot 2024-06-27 at 18.58.34] [Screenshot 2024-06-27 at 18.58.28] [Screensh…

You don’t need to add any data structure, it will parse automatically if the json is correct. From the picture, it seems ok, but you don’t need to replace the || because we no longer ask it to replace with these characters. It’s like now it just removed any new line, it’s weird.

Can't figure out how to separate text sections with parser

Questions

Michaela-Inactive July 1, 2024, 6:14am 18

Hi @Esma , here’s a guide on sending DMs in the community: 📚 Mastering the Make Community: Send Direct Messages

Topic		Replies	Views
Help with Perplexity output into Google Sheet Questions google-sheets , parse , ai	12	1114	September 24, 2024
Splitting chat GPT response into seperate variables to add to rows in a google sheet Questions filters , functions , mapping , chatgpt	10	1406	July 21, 2024
I'm trying to parse response from chatgpt into json and then into google sheet Beginner Questions json , text-parser , chatgpt	1	54	January 21, 2026
Text parser to Google Sheet - struggling with formatting Questions google-sheets , text-parser	2	85	December 6, 2024
Email parsing automation Questions functions , google-sheets , api , error	1	53	June 23, 2025

Can't figure out how to separate text sections with parser

Related topics