Create a google sheet file add the content line by line and column by column

[IOA_Brett]

Hello Rejoo,

I created a simple string “one-two-three” in a parse JSON module for demonstration.

Then, I set a variable named “Array” to the value {{split(20.data; “-”)}}.

This takes the string “one-two-three”, and returns an the array [“one”,“two”,“three”].

You can use this array to fill out your google sheet rows without needing to make any manual adjustments.

Hope this helps!