Skip to main content

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

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! 🤗