I want my scenario to process the Excel file attached to an email I receive daily at 00:00. The scenario is scheduled to run at 00:10, but it always fetches the previous day’s email instead of the latest one. I’ve also tried scheduling it at 00:30 and even 01:15, but it still picks the wrong email.
Steps taken so far
I receive a new email with an Excel file every day at 00:00.
I set up a Make scenario that triggers once a day.
I initially scheduled the scenario at 00:10.
The scenario runs successfully but processes the email from the previous day.
I tried changing the schedule to 00:30 and 01:15, but the issue persists—it keeps processing yesterday’s email.
Hi thms, I think the issue is that Make retrieves the first email instead of the latest, which is why you’re getting the email from yesterday. You can work around this by adjusting some options:
Change the Filter Type to Gmail Filter.
In Query, refine the search using parameters like: subject:Yoy AND has:attachment AND is:unread
Set Mark email message(s) as read when fetched to Yes.
In Choose where to start, select All emails.
You can test it by marking the mail you want as unread
Polling Triggers: Epoch Panel & Selecting Older (or only new) Data
Go to the Epoch Panel, by right-clicking on the trigger module (polling triggers only), and select “Choose where to start” from the list of options in the context menu.
You can also select other old data to re-run your scenario with next using the “Choose manually” option. This will then show you a list of previous historical items you can select to process the next time the scenario is triggered.
Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
