Processing ChatGPT Output Into Aitable

[AiOptBiz]

Hi everyone,

I’m working on a project that processes text files using the Ask an Assistant ChatGPT module. While I’ve successfully got it extracting key ideas and descriptions, I’m stuck on the database integration part.

Current Process:

1. Process text file with ChatGPT module
2. Extract key ideas and descriptions
3. Get output in txt format IDEA:DESCRIPTION
4. Convert text into Json ← not working ERROR: “Unexpected token I in JSON at position 0”
5. Trying to loop through items to add to Aitable

What I’m Trying to Achieve:
I need to take the ChatGPT output and systematically add each idea to my Aitable database.

Could anyone suggest the best way to handle this?

I already tried json output + java script route but couldn’t get it to work

[kishanprmr]

Hello @AiOptBiz ,

You can use a text helper piece to gather all the ideas from text, so you can apply the loop step.

[AiOptBiz]

@kishanprmr Thanks, I did try that however I still can’t get it to work. First I Split on “Idea:” and later on “Description” but the output is not quite right.

[AiOptBiz]

Hacked it with a bit of ChatGpt generated java code