Hi Friends,
I’m still fairly new to Zapier, so just bare with me, I have looked and couldn’t find a related topic to answer my question. I’m trying to create a zap that adds details of passengers from a Rezdy order onto a google sheet - where there are multiple passengers on the same order, with a separate row for each passenger.
The lead passenger’s details are easy as they’re all separate fields, but for subsequent passengers it bundles all of their details (name, phone number, email address etc) into one field in the Zap:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/435d5a92-3636-42d0-bc3f-6ff8568b39d2.png)
I’ve tried using formatter and split text:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/38369be9-267a-43db-b166-c42e368a3bd1.png)
But when I test it’s still comes out on one line:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/c4947729-d1df-4706-b94a-d00ce9be204f.png)
I’ve tried using Utilities to format text to line-item and line-item to text and I can’t seem to find the right option for what I need. Ultimately I want each passenger to be separated onto a row of their own on the google sheet, such as:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/6b0907d8-c764-46c2-9095-582c23c2b517.png)
Please help! :-)