u/Ultra04_

So the task I have is about automation and I need to automate email reading and downloading attachments (PDFs etc) which are sent to a particular Outlook mail. And the downloaded PDFs must be uploaded into a particular folder for which I will give the path in the script (for this I wrote python script in VS Code).

​

The main thing is the PDFs we get to the Outlook mail will be purchase orders from vendors and we need to extract data from the PDFs and convert it into Excel file. That's the task and I used Pdfplumber and pandas for the extraction and creating an excel sheet for each particular pdf.

​

The main concern is that is it safe for using this to create and app registration so that I can get the client id for automation of the Outlook mail reading and downloading.

Currently, we receive Purchase Orders (POs) via email. The Indent team manually converting these PDFs into Excel files and then uploading the data into Bizom for a standardized format.

This manual process is time-consuming and increases the risk of indent and data entry errors.

As suggested, there are tools available that can automatically extract data from PDF attachments received via email and convert them into Excel format.

Requesting guidance on suitable automation tools and solutions that can help automate this process, reduce errors, and improve TAT.

Please let me know, are there any such tools that are available regardless of whether it is free or purchased

My_qualifications btech 4th year

Just got a chance to attend a meeting for an internship and looking for basic data engineering projects that can at least make me look like a guy they can consider.

Looking for help from u seniors who are experienced.

Yes I know it's wrong to copy paste but I will learn about it during my time and be proficient at it to be able to answer.

As for my skills I know powerbi and tableau as well as basic sql and excel.