I’m trying to set up an automation where once a NEW customer COMPLETES a payment on Stripe, it will send them an email from Gmail.
How do I set that up?
Sincerely,
Techologically Challenged
How do I create a filter for Stripe to send an email ONLY to new customers?
Userlevel 1
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 24174 replies
-
12 May 2023
Hi
Good question.
One approach is to log all payments in a GSheet.
Then in the Zap you can use this to check if a customer already exists.
If they do exist, then you would add a Filter step in the Zap to prevent the Zap from proceeding.
Userlevel 1
Thank you!
So I’ve created a Stripe → Google Sheets connection; so far I’ve managed to create it so that any new customer payment that comes in triggers a new column: CUSTOMER NAME & CUSTOMER EMAIL.
I’m hoping to then create another Zap that takes is triggered by the new email address & send them an email.
Now how might I go about creating a filter so that I ONLY send intro emails to NEW emails and not existing ones?
Userlevel 7
+14
- Certified Zapier Expert
- 24174 replies
-
13 May 2023
Use the GSheet Lookup Row Zap action.
As part of the Zap action configuration there is the option to create a new row if a matching row is not found.
Thus the logic becomes Find a Row, else create a Row, so you avoid duplicates.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.