How to run zap only once for a new unique Stripe user?

Question

Hi Zapier Community!Whenever a new user signs up on our website and picks a number of seats in the subscription, it triggers Stripe to create a payment for that number of seats. Not all payments are completed, therefore I want to set an automatic email-reminder to the user that didn’t complete the payment in 24 hours (or when the created payment is set to “Expired” by Stripe).Is there a script or anything that would use user’s email as a unique identifier and run Zap only once?Previously I tried running Zap only once based on the Invoice Prefix ending number. Filter would look for “-0001” at the end of the invoice number and the actions would run only once. However, the “Updated Subscription in Stripe” Trigger doesn’t have that line.Any other ideas would be helpful! :)

SamB · Accepted Answer

Hey @Ilya Lukach!👋You could potentially use a spreadsheet app,like Google Sheets for example, to hold a list of the users that have been sent an email reminder. Then you would add a Lookup Spreadsheet Row(Google Sheets) action to the Zap to search the list. That action has the ability to create a new row if no match is found. So it could search for the user’s email address to see if they’ve already been sent the email reminder, and if it doesn’t find them, then add them to the spreadsheet.The Filter action would check that the_zap_search_was_found_statusfield from theLookup Spreadsheet Row action is False - as that would indicate that it’s the first time the Zap is sending the email reminder. And then send out the email reminder.Do you think that approach could work for you?

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded