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.
Best answer by AndrewJDavison_Luhhu
View original
+10
Hi
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.
+9
Hey
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
