I am trying to link Shipstation to Google Doc, as show in the image. The options pull through perfectly. However when I look to action them to a google sheet, the names and values get merged together, you can see this in the second Image. I only want to reference option 1 - value, any help would be much appreciated.
Image 1) Test Pull through
The numbered values retrieved from ShipStation are called line-items. Parsing these information is technically a bit challenging. The best way to do that is by using a code step (JS/Python). However, you can parse the items in separate labels using Formatter > Line item to text and then Formatter > Separator (,).
The data is structured as line items (aka arrays) which is why you are seeing it “grouped” together in the Action step.
Check out this help article for working with line items: https://zapier.com/help/doc/how-use-line-items-formatterv2