Skip to main content
Question

Split comma separated string into individual rows in a googe sheet

  • November 24, 2024
  • 1 reply
  • 9 views

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

Did this topic help you find an answer to your question?

1 reply

JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2312 replies
  • November 25, 2024

Hi ​@Andy515,

 

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.