About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Fullfilment of Shopify Orders

  • 6 August 2021
  • 4 replies
  • 103 views
S

Hey there,

right now I’m looking for an solution for this problem:

the current flow is this:

  1. we catch the hook (Zapier Webhook) from shopify “Fullfilment of Shopify Orders”
  2. we filter (Zapier Filter) the order “Line Item SKU” - “does exactly matches” - “DAILY-LIVE-SUPPORT”
  3. we send an Email (Gmail) to the customer with the exclusive Telegram Group

 

so right now I’m looking for an easy solution that this trigger only fires on the first order of this product, because this product is a subscription on a montly basis. that means the customer would receive the email every month when the subscription gets fullfiled. I like to manage it, that the customer only gets the email on the first time of purchase for this specific SKU/Product.

 

may you know an easy workaround or filter or something else to get it work like that.

 

thanks

 

 

icon

Best answer by support-noitamation 10 August 2021, 12:00

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

SamB
Rank
Userlevel 7
Badge +11

Welcome to the Community, @support-noitamation! :)

It sounds like you’ll want to get the Zap to keep a record of the customer subscriptions that have been sent an email in a spreadsheet or database app. That way the Zap can check the spreadsheet/database app to see if the customer subscription has already been emailed and if not, send out the email and record them.

There’s an article that talks about how to prevent your Zap from running for duplicate triggers, by keeping a record of ones that have already been processed, which you may find helpful on setting this up: 


Hope that helps get you pointed in the right direction! 

S

thanks - I’ll check it out

S

ok - I think I found the solution with “Lookup Google Sheets”

 

we set this steps:

  1. catch hook
  2. filter: only continue if “text matches exactly”
  3. Lookup Spreadsheet Row in Google Sheets - if data in colume not found continue
  4. Delay for 1 minute
  5. Send Email in Gmail
  6. Delay for 1 minute
  7. Lookup Spreadsheet Row in Google Sheets - if data in colume not found continue
  8. Create Spreadsheet Row in Google Sheets - add data to colume

 

so when data “ID” is already in the Spreadsheet this flow should stop on step 3 - so customer who already are in the spreadsheet don’t get the email a second, third time and so on.

 

I think this works right now.

SamB
Rank
Userlevel 7
Badge +11

That’s great news, @support-noitamation!

Thanks so much for sharing your solution here. We really appreciate it! :)

Terms & Conditions