Linking New order Amazon to Many Chat sequence

Hi @z-m-a!

We didn’t hear back from the original poster on this one, but I can perhaps offer a way to do this?

To do this, you need to be able see which codes are used by your customers. Do you know if your ecommerce/payment platform gives you that? If it does, then you could store the codes in a Google sheet and when you get a notification that a code is used, mark it as used. So the Sheet would have one column for codes and another column saying whether or not the code has been used

Your Zaps would look a bit like this:

Zap 1

1. Trigger: code is used 
2. Google sheets Lookup Spreadsheet Row - Searches for the coupon code)
3. Google Sheets Update Spreadsheet Row - Add ‘used’ or something similar to the row with the relevant coupon code

Zap 2

1. When many chat sends a coupon, send it to the Google Sheet (You could maybe use the ‘New or Updated Custom field for this, and add the coupon code to that custom field)
2. Delay step - Delay the Zap for the amount of time that you want to wait before sending a reminder
3. Google Sheets Lookup Spreadsheet Row - use the coupon code from the first step to search the sheet
4. Filter step - Look in the ‘used’ column and only continue if the column doesn’t have ‘used’ in it (ie the Zap will stop if ‘used’ is next to the coupon code)
5. Send Email to user to remind them