I am trying to split a comma separated field into individual rows in a google sheet. I used the split text transform function and when I run a test it looks like the string gets split. But when I connect to my google sheet and pick from the transform it does not fill in the google sheet correctly. I get the entire string.
Ex. String ‘A,B,C,D’
the result of the transform is:
1
1 A
2 B
3 C
4 D
When I look at the google sheet after the insert I get ‘A,B,C,D’ again
Thank you
Hi
Welcome to the Community.
Zapier handles arrays as single strings when sending data to Google Sheets, causing formatting issues. To fix this, use the 'Split Text' action to create an array and then a 'Line-item to Text' action to convert the array into a string with each item on a new line. Map this output to a Google Sheets column, creating a single cell with items listed line by line. Use Zapier's 'Looping' action, for each item in a separate row.
Let us know if you have further questions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.