Splitting ChatGPT conversation output doesn't work with parentheses

@DaanisAan 

Otherwise, I recommend defining a JSON template for ChatGPT to output that can then be reliably parsed using a Code step.

EXAMPLE for email parsing...

• [GUIDE] How to use ChatGPT as an Email Parser

Action: ChatGPT - Conversation

Prompt ChatGPT to parse the email and returned the data as structured JSON to then be used in the following JavaScript Code step.

• You only need to configure the field: User Message
• Adjust the prompt instructions. (first line)
• Define your JSON template. (fields you want returned from the parsed data)
• Map the variable that contains the data to be parsed. (e.g. Email Body)
• Other fields can be left with their default values.

CONFIG

PROMPT

Parse the contact details from the lead.

Return as fully structured JSON object like this:
{
"NameFirst": "",
"NameLast": "",
"Email": "",
"PhoneNumber": "",
"Company": "",
"Website": "",
"Comments": ""
}

Content: {{CONTENT}}

RESULTS

Action: Code - Run JavaScript

This Zap step will take the returned JSON from ChatGPT, and convert the JSON into individual data point variables that can be mapped to following Zap steps.

Map the Assistant Response Message variable from the ChatGPT step.

REFERENCE

https://community.zapier.com/featured-articles-65/parse-raw-json-with-javascript-code-step-16116

• Parse Raw JSON with JavaScript Code Step

CONFIG

CODE

let Lead = inputData.Lead;

Lead = JSON.parse(Lead);

output = [{Lead}];

RESULTS

###