I have generated content with the OPEN generate text action, and i want added those AI generated content back to the Spreadsheet / database.
Referring to attached screenshot, which item is the AI generated content? It tried it one by one, but seems still can’t locate it.
Also, referring to the attached screenshot, how to set this field to tell the system to add the record to a specific column? thx
Hi Keith, if I understand correctly, you operate in the loop. So after choosing the database, Record field would actually determine the record that will be updated here. So you press / then choose Current item (Loop) > ID
This will make you update the line which is currently operated in the Loop.
Okay, now you need to put the text in the Content field of the line. This is harder cause I never did this OpenAI stuff. What you can do is to go to your OpenAI - Generate text Node, then press Run test or Preview last run. It should show you the data generated so you can easily spot where in this structure and under what name is your generated text.
Hope that helps!
Yes. i am running it in a loop.
But toally dunno the correct setting for Record and Field. Still empty output. Can’t find any guide on this.
For Record you can set it up like this:
This way it will update the line which is currently processed with the Loop.
WIth the OpenAI, I don’t have ChatGPT API, so I went ahead and made a Deepseek through OpenRoster that should be OpenAI API compatible. So it should work for you too.
So I could make it work this way:
first make sure that your field in DB is multi-line text!
Hope it’s self explanatory, /OpenAI > body > choices > #1 > message > content
1 Like