Skip to main content

The data looks like following:

Name: Leo, Dylan

Age: 20, 21

Country: Canada, France

 

I would like to split them by comma and add two rows into google sheet:

Leo 20 Canada

Dylan 21 France

It should also work when I have n set data separated by comma and add n rows to google sheet.

 

How should I make it happen? Thanks.

Hi @leoqiu 

Good news! This can be done using a “Formatter->Utilities->Line Itemizer” step (guide here). That will give you back the rows constructed in the way you want.

Then, for Google Sheets, you’ll notice there is a “Create Spreadsheet Row” action step and also a “Create Spreadsheet Row(s)” step - you’ll want to use the later.

The result = multiple rows on your sheet.


Hey @leoqiu - Just checking in. Did this solve your issue? Let us know!