Hi all
I’m using a Google Sheet integration to pull a number of results from Google sheets (Get Many Spreadsheet Rows (Advanced, With Line Item Support)
I’m currently testing with 2 results, which are: 4157069551,4157190930
I’d like to get each result as it’s own text field.
To do this, I’m using Utilities > Line-item-to-text
I’m using the ‘Rows’ result from Google sheets in the input which looks like this:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/30768e1d-ad8b-49ca-a9f3-78fbd63d2398.png)
I’ve put a comma in the separator box.
Here is the output:
output
item_1: 4157069551,4157190930
item_2: 4157069551,4157190930
item_last: 4157069551,4157190930
text: 4157069551,4157190930,4157069551,4157190930
I’m not sure why both results are showing as a one. Any suggestions to get this to split as item 1 and item 2?
thanks
Adam