Best answer

Split text by comma and add to google sheet

  • 8 December 2020
  • 2 replies
  • 105 views

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.

icon

Best answer by AndrewJDavison_Luhhu 8 December 2020, 13:38

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +10

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.

Userlevel 7
Badge +9

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