How to take bundles given by chatgpt and populate it a table in sheets

[Sudhansh_Perkari]

Chat gpt has given me the following:

0/Las Cimas II/Suite 115/Available Now/1,579|

0/Las Cimas II/Suite 200/Available Now/11,866|

0/Las Cimas II/Suite 245/Available Now/1,738|

i need each section(seperated by /) to be in different cells and each row needs to be in a seperate rows in sheets. Please help

[Jennifer_AI]

I need something similar, so I’m watching any responses here. I’d like to put 20 rows of data at the bottom of a google sheet. If I find the answer, I’ll come back and post here.

[Msquare_Automation]

Hi @Jennifer_AI , @Sudhansh_Perkari

You can split the text using split function.
Here is a sample workflow we created:

Sample text you shared:

Iterate through each row:

iterator output:

Adding each value to sheet this way:

Output:

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation

[Jennifer_AI]

Thank you!! That’s awesome.