Hi all,
I have now made a flow that automatically stores all incoming/outgoing emails and it updates the Excel sheet with the newest email. I store Subject, To, From, and Conversation ID in Excel. What I want to do now is another script that runs every 24h, to check if the emails still are in the inbox. If the email is not in the inbox, then I want it to write: "Completed" under status in my Excel sheet. What I am really having a hard time figuring out, is the best way to check the inbox for the specific email and report back with either "not found" or "found". Something like that at least.
Any ideas?