Scheduling an email when a sale comes in from Etsy

I am completely new to Make and trying to set up a scenario to email me when an etsy sale is made (as well as adding it to my Google sheet, which does work when I run it).

Anyway, I have Etsy “Watch Transactions” / Array Aggregator into a router that gets divided if there is a sale or not - if no sale, it send me an email stating that the mode ran, but no sales, if a sale, then it goes off the other direction and adds it to a google sheet, checks to see if they are a returning customer or a new customer, and then based off that - it will send me an email that there was a sale and if it was from a repeat customer or a new customer.

It works if I manually make it run - however when I set it to run every 8 hours, it doesn’t go past the 1st module … the 1st module runs, then it stops, if I have sales or not.

I’m not sure what all I need to provide to get help, but I am lost, I even went to ChatGPT with the integration Make.com to get help, and it’s not coming up with a solution to make it work either.

Like I said, it works if I “manually” run it, but it grabs ALLLLLL my sales, and I want it to only grab the sales that are new since the last run (8 hr intervals).

Thanks in advance.

HI! Welcome to the Community!

One important concept on polling triggers (ones that run whether or not there’s new data) is in choosing where to start.

You can set that by right-clicking on the trigger and choosing “Select where to start”. When you run it, it will start from that point.

After the first run, it will then pick up anything from the last run onwards.

Crucially - if there’s no new data, the scenario will stop after the trigger module, as there’s no data to pass on to following modules.

As a result, I don’t believe that the router branch where you’re aiming to send an email if there were no sales will ever run.

If you’re 100% certain there are new sales in your Etsy shop since the last run of the scenario, and it’s not picking them up, then that doesn’t seem right.

Bear in mind that the Watch Transactions module only triggers on transactions for the specific listing that you put in the module config.

2 Likes

David, thanks for your reply, and that makes sense and how I thought it should work. But as I said, I am new, so I am still learning this - I only added the “no sale” branch after I had the original scenario fail. I had 2 sales in an 8 hour window, so it should had ran and sent the emails and according to the history it said it successfully ran, but there was no emails sent.

So I thought I had my connections wrong some how, but when I manually click the Run, it will work as it should and send the emails with the data.

So ultimately my automation works… but ONLY if I hit run… not when it does it automatically.

Any idea? I am sure it’s something stupid / simple I am overlooking.

I think this might need more detailed investigation. I’d recommend you open a support ticket.

Click the orange “?” button near the bottom left of the scenario builder screen, select “Contact Support” and follow the instructions.

While you’re waiting for a response, could you post a screenshot of the parameters for your Etsy Watch Transactions module and also the scenario’s Schedule Setting dialog?

1 Like

I am sorry for the delay in the response, I had tried to change some things to see if it would work and had to wait for another sale - I had gotten 2 issues since, and fixed those, but back at it sending me ALLLLLLLL my orders again, EVEN tho I stated I only wanted it to send from where it last left off and max is 10 - it maxed out at 85 emails

as for the screenshots -


Thanks

There’s a few possibilities there, but to be sure we’d need to see details of the parameters for each of the first six modules (the trigger, up to and including the Iterator).

Could you share screenshots showing the parameters for each?

1 Like

I am working on it and trying… this is what I have (see image)

If I manually run it, It does it exactly as I want… BUT I have to click on #1 and manually select where I want it to start, then depending on how many sales there were, I go into #5 and chnage the Limit to however many sales there were. In this case, I had to, so you see in the screenshot I had 2 go through and ended as it should have with the email to me stating “New Customers”

Thanks again for your time to help me :slight_smile:

The first module is receiving the new transactions. I’m guessing you want to add to your Sheet and email you on EVERY one of those new transactions, and ONLY those new transactions.

But the List Shop Receipts module (whose results you’re then iterating over) returns EVERY receipt in the whole shop, for all time. The only parameter it takes is the Shop ID - it doesn’t know what timeframe you’re interested in.

That’s why you’re getting every receipt.

I think the scenario you need is much simpler.

I’d clone this scenario into a new one. I’d then replace the first six modules with simply the Watch Shop Receipts trigger.

First 6? Can I do the 1st 5?? I am not sure what the Iterator is really for, but I want my google sheet to be checked (Search Rows for an email address #6) and if its there, then the router will send it off to the “Update a Row” (for returning Customers) or the “Add a Row” (for new Customers) and then an email will be sent off to me letting me know which they are and what they purchased.

Ok, I removed the 1st 5 and replaced it with Watch Shop Receipts, it ran, and only ran 1 (as I had 1 sell in the time window I had set) but it did not include all the information I wanted it to include (like the item that they bought). and it did not add it to my google sheet.