Extract order line items from flows to google sheet

Shopify Plus
,
1

I am trying to extract dropship line items into a google spreadsheet.

I am having is that I am able to get all the items for an order that including the stock on hand + dropship item but is there a way to get just the dropship line items filtered via SKU, tag or vendor to be extracted from the order into the google sheet. Is there anyway to do this?

The current flow set up is

Order created > check if tags is equal to dropship > add row to spreadsheet > row content =“{{order.name}}, {{order.createdAt}},{{order.customer.phone}}, {{order.email}}, {{order.customer.firstName}} {{order.customer.lastName}}, {{order.shippingAddress.address1}}, {{order.shippingAddress.address2}},{{order.shippingAddress.city}},{{order.shippingAddress.province}},{{order.shippingAddress.zip}}”

2

Yes you can get that info. But since there are 1 or more line items, you need to figure out how you want to add it to that spreadsheet. For example, do you want each row to be a lineItem?

If you want all lineItems in the same row, you would use a loop like:

{% for li in order.lineItems %}
{% if li.sku == "XYZ" %}
{{ li.sku }}-{{li.quantity }}
{% endif %}
{% endfor %}

I’m not sure how you detect which items are drop-shippable…how do you define that?