Ugh! I’m stumped!
I’m looking up a GSheet Row (example below)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/3ae15d69-d829-418e-b055-0e10d59fb5e8.png)
...and it’s returning the following when looking up “Sweep” in Column A.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/cbf8920f-9b93-4612-af58-d5c5718fc11e.png)
My Problem: Google doesn’t return a comma separated list, it separates each value. This means the “Loop by Zapier” step can’t grab all of them at once (see below). I’ve tried using the Formatter > Line Item to Text, but because the number of columns returned is variable (for instance, “Mow” will only return 2 columns) I can’t get it to work correctly.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/e512a34d-ce13-4256-987a-6898b952a779.png)