Hi @Eric Caldwell!

It sounds like you’re off to a good start with the filter step, let’s see if we can help you with the rest of your Zap. There are a few more things that we need to know to start working on this with you:

• What’s the trigger for the Zap (app and event)?
• Please could you share an example of the sample data for the trigger, specifically what the products look like. 
• You mentioned that you want to add it to a Google Sheet, can you confirm exactly how you want that to look? eg each shoe order is added as a new row in the sheet

Thanks!

Hi @Danvers, thanks for the reply.

1. The trigger for the Zap is a new Shopify order.
2. Each shoe ordered is meant to be added as a new row, which I currently have set up correctly.
3. Here is the filtered data from a test trigger:

id

17114

row

17114

COL$A

#100132976

COL$B

Leah Steinberg

COL$C

COL$D

COL$E

December 10, 2022

COL$F

$209.99

COL$G

Saucony Triumph 20 women's - 9 / Night Lite

COL$H

1

rows

1

id

17114

row

17114

COL$A

#100132976

COL$B

Leah Steinberg

COL$C

COL$D

COL$E

December 10, 2022

COL$F

$209.99

COL$G

Saucony Triumph 20 women's - 9 / Night Lite

COL$H

1

2

id

17115

row

17115

COL$A

#100132976

COL$B

Leah Steinberg

COL$C

COL$D

COL$E

December 10, 2022

COL$F

$209.99

Hope this is sufficient. Let me know if you need anything else - thanks so much for the help.

COL$G

Saucony Triumph 20 women's - 9 / Black | White

COL$H

1

rowCount

2

Hi @Eric Caldwell 

Good question.

Try using the Looping app followed by a Filter step to handle each Shopify Order Line Item separately.

https://zapier.com/apps/looping/help

Hi @Eric Caldwell, thanks for sharing that extra context :) 

To expand on Troy’s suggestion, you can use Looping to run through each line item in the order and add an extra filter as part of that so only the shoes get added to the sheet. 

So the Zap would look a bit like this:

1. Shopify trigger
2. Filter - only continue if the order contains the shoe
3. Looping
   1. Filter - only continue if the line item item is the shoe
   2. Google Sheets - add row to spreadsheet

Looping can be a bit tricky to get your head round at first, so I’d recommend checking out the help guide that Troy suggested and of course if you have any questions you can ask them here!

Thanks @Danvers. Unfortunately im stuck on the filter section after Looping.

Here is a screenshot of my looping step (2 loops for the line item and they seem to be successfully separated. 1 shoe, 1 non shoe)

Then I get stuck. For some reason the only 2 line item options contain just the non shoe item, or both items together. Feel like I must have missed a step somewhere. Hoping you can help.

@Eric Caldwell

Looping help article: https://zapier.com/apps/looping/help

• When you test this action, the Zap will only create the first loop. It will not create any other loops during the test.
• Don’t use the preview_loop_values field from the loop test in your Zap. It is for preview purposes only and doesn’t appear in actual Zap runs.

Try turning the Zap ON and testing.

Then check your Zap Runs history details to see the DATA IN/OUT for each Zap step: https://zapier.com/app/history/

Thank you for the response. However, when I send a test to my spread sheet both line items seem to appear. Still unsure as to how I can only import shoe orders into the sheet.

Hoping I can provide some additional info for you to help find an answer.

Thanks as always,

Eric.

@Eric Caldwell

Please provide a screenshot that shows the order/outline of your Zap steps.

Make sure the Filter step comes after the Looping step so it applies to each line item output from the Looping step.

Do this to help you troubleshoot and provide us with screenshots.

Then check your Zap Runs history details to see the DATA IN/OUT for each Zap step: https://zapier.com/app/history/

So essentially it goes:

Only continue if it has email/name

Loop line items

Only continue if line item “meets specific shoe criteria”

And here’s a good example of the zap history that I need to work…

So we have the two line items, Asics GT-2000 and Superfeet run comfort. Both items were put into the sheet, but with my filters i thought only the shoes ( Asics GT-2000), my criteria for filtering shoes is if text contains numbers 5-15, so the Superfeeet run comfort should have been filtered out. I’ve clearly set it up wrong. Hope this is enough info!

@Eric Caldwell

We’d need to see screenshots with how the Zap Step 4 Filter processed in the Zap Runs (DATA IN/OUT).

Also, please provide screenshots with how your Zap Step 5 (GSheet) is configured.

Make sure the values are mapped from the Looping step.

I haven’t received an order since the last edit so I cannot send an updated Zap history screenshot right now. 

But here are the steps configured in google sheets - this step definitely seems incorrect.

@Eric Caldwell 

FYI: You should also pass these values thru the Looping step, then map from the Looping step, since those are arrays as well.

Great. So I have done that, now when I test the action it comes out as one line item, but it’s the wrong one. Could that just because its sample data?

@Eric Caldwell 

Yes, configuring and testing the Zap will use the first line item data output from the Looping step.

Perfect. Ill wait for an order to come in and see if it works. Appreciate you being so patient with me!

It sounds like you have everything set up now, @Eric Caldwell,  it all works smoothly when you get an order. Let us know how you get on!

Looks like it’s working! Thanks for the help and patience @Danvers @Troy Tessalone.

Eric.

Thanks for letting us know @Eric Caldwell! I’m so glad Danvers and Troy were able to help get your Zap up and running here!