Currently I am developing BOT to read the mails from specific folder and using subject to know the request ID and status to update the status in the excel. I have different scenarios and formats of mails in every level of approvals.
I am planning to create a template of all email scenarios subject/Body format and check whether new mail is falling under any one of this template array. If it is from template, split and get required data
Template file will have like :
Request id: <>has been created for the customer: <>;
The Request <> for the customer<> has been rejected.
Mail subject will have : Request id: 123 has been created for the customer: ABC;
Now BOT will check this subject line with the all the templates
Please suggest me whether I am in a right direction or making it complex. And also request you all to provide your ideas and thoughts and any other simple way if u feel.