Text Parser taking 5 ideas to 1 row

[Lisa_Hersee]

Hi I am getting 5 ideas from Google Gemini at a time and trying to put them into a google sheet one row for one idea - it keeps wanting to stick all the 5 ideas into one row.

I tried using the Text Parser with the Advanced Pattern transformer and found the right regex code but it wasn’t changing the fact they were all in one row.

Can anyone suggest what settings or modules I should be using. The ideas each have a category heading and then a title.

Thanks for your help

[Brainstream]

Hello @Lisa_Hersee

You are currently receiving all five ideas from Google Gemini as a single combined string, which is causing them to be inserted into a single row in Google Sheets.

To resolve this, use the split() function within the Iterator module

[Lisa_Hersee]

Much appreciated @Brainstream - I wasted a good part of my life trying to get this to work the other day - and its fixed!!! Thankyou.