Automate processing of emails received which offer jobs. Emails come from 5-6 different sources and are laid out differently. But there are about 8 fields that are common and can be captured by ai builder. (I’ve trained only one source so far, but looking good)
My goal is to extract the necessary fields and present in consolidated excel online or into a sharepoint list. Complication I have is to build flow which extracts data from each email attachment and compares with information already in spreadsheet/list. Then logic to either update what has changed on an entry, delete an entry if needed, or add a new row/item.
Each job coming through in attachments has unique IDs specific to each source.
A few of the sources produce weekly summary tables showing jobs open, and only by a line items absence can you deduce its closure.
Other sources send emails specifically closing previously open positions.
Some sources provide pdf and others excel format. Thus, intend triggering flow from sharepoint file library after manually changing all docs to pdf and saving in library. I’m aware automate desktop RPA might help with pdf’ing so happy to hear ideas.