Hello Team I have a workflow which filters emails with specific keywords, running every at HH:10 every hour. Now today it executed correctly at 11:10 but post this due to an issue with authentication the data wasn’t picked up, while I did correct this and at 4:10 PM this ran successful, I am currently missing data between 12:10 - 3:10 PM
Is there anyway I can run the workflow where it can fetch data between 11:11 AM - 3:09 PM for 6th March?
-n8n version: [email protected]
-Database : SQLite (default)
-EXECUTIONS_PROCESS setting: Main
-Running n8n: via desktop app
-Operating system: Windows 10
Hi @Subhayan_Chanda !
This kind of workflow entirely based on a trigger is not really resilient to errors, that is one of the drawbacks of it.
You have thus two solutions:
Retrieve by hands all emails from this specific timeframe in another workflow with a Gmail node and update your Google Sheets
Rebuild your workflow a little bit differently with a Compare Datasets node
The second is according to me the best practice to have error resilient workflow. What I would do is keeping the Gmail trigger, but when triggered, retrieve all emails received the current day. On the other hand, I would retrieve all rows from your Google Sheets for the current day, I would do the diff with the Compare Datasets node, and add every new email to the Google Sheets. It might be slower, but it is much more resilient to errors (as long as you debug any error on the current day it happens as we are just checking the emails for the last 24 hours).
It is always challenging to build a workflow that is both real time efficient, and resilient to error.
Hello Henri, I tried to use get many messages but the load time for emails was on ongoing for 20 minutes with no action. Can you suggest what would be best approach in your opinion to get the data for the specific timeframe on separate sheet?
I will try your second suggestion for sure, sometime next week