Skip to main content
Question

Export Shopify orders containing specific product to Google Sheets

  • November 14, 2022
  • 1 reply
  • 115 views

Is it possible to create a zap that exports orders in Shopify that contain a specific product ID into a Google Sheet, containing the customer name, email, order date, order number, order line item?

 

The New Order event doesn’t seem to allow filtering by product and only pulls through every order placed

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • November 14, 2022

Hey there, @Cacao Dan! Thanks for reaching out and welcome to the community!
Hmm, I wonder if a Filter by Zapier step would work for you? You should be able to filter by that specific product and then proceed with your Google Sheets step as needed. So it might look like:

  • New Order - Shopify Trigger
  • Filter - Product
  • Create Spreadsheet Row -- Google Sheets Action (swap this for whichever Google Sheets action you need)

If it helps get you started here’s a Filter Hub with a ton of resources and common workflows as well as some tips on how to properly format your Google spreadsheet to work best with Zapier.

Do you think that could work for you? Let us know! 🤗