Split text to columns in Google sheets

[olimckenna]

Hello,

I am sending data from a 3rd platform (Waalaxy) to google sheets with webhooks

However, the data is sent in this format

John;Maria;Bruce

So I need to split it by ;

This is possible in Zapier: https://prnt.sc/LK0fpedYs0k-

But I don't see a way to automatically split data by ; in Pabbly?

The data is sent this way: https://prnt.sc/pLvgC6yBrweO

Step by step way to do it in Zapier is here (step 4 + 5): https://blog.waalaxy.com/en/synchronize-waalaxy-crms/

I tried to use Line Itemizer but this doesn't really seem to do the job.

Wondering if it's possible to recreate this in Pabbly?

Thanks

 

[PabblyMember4]

Hey @olimckenna

You can use the text formatter by Pabbly and use the action Split text and can split the data in your desired format.

You can check the below video for checking the text formatter.