Question

Export Shopify orders containing specific product to Google Sheets

  • 14 November 2022
  • 1 reply
  • 98 views

Userlevel 1

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


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

Userlevel 7
Badge +9

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