I let Chatgpt generate 5 posts from my article. and I want to seperate 5 posts to 5 line to google sheet

[Celine_Xu]

Dear guider,
need your help and suggestion

I let Chatgpt generate 5 posts from my article. and I want to separate each post to 1 line and send to my google sheet
I. asked chatGPT (reformat the post ) put the post in to table formate which i can copy and paste, but it does not work
any suggestion?

[LevinO]

Hi,

You could try and use the ‘Transform Text to Structured Data’ module. In there you can say what structure your outcome has to be.

Regards,
Levin

[Celine_Xu]

Hi Levin,
I tried seems not working.
This part of my flow is: use OpenAI generate 5 twetter posts, then use another OpenAI to seperate them into 5 lines for google sheet (and love to know where to find instruction how to fill in the parameter), then choose the '‘add bulk google sheet’ function for adding (here also would love to know how to put in the parameter–what I put in are all guessing )

here is the screenshot of the ‘Transform Text to Structured Data’ module.’ --Love to know how to put in the info --(seems, I have 5 posts from first OpenAI scussfully, but after the Transform Text to Structured Data’ module., only one left)

I also download the input and output Jeson for this module
blueprint_datasample.json (2.6 KB)
blueprint_webhook.json (22.0 KB)

The next step, I would also love to know how to put in infomation for the ‘Bulk add rows’ google sheet module

Thank you!