Power automate - take attachments from email/whatssapp/telegram and summarisation report in an excel / google sheet

Job ID: 36968835

Budget: ₹600 – ₹1,500 INR

Project – Fetch Report Summary
Objective of the project is to Create summary of the pdf reports stored in a folder fetched from outlook email / other messaging tools / sources.
Action points
- Fetch pdf report attachment from email, Whatsapp, telegram channel

o Pdf reports can be an attachment
o Pdf report can be from links
o Fetched for a day and gradually to be fetched on a daily basis or on arrival of report

- Save the fetched report in a folder to be named ( as YYYYMMDD-CONAME-BROKER NAME) and save in folder \attachment\YYYYMMDD\ on a onedrive/local drive on a daily basis
- Once the reports are saved an excel or google sheet to be prepared with the following columns
o Date fetched
o Date of report
o Company name
o Company NSE code /BSE Code / Bloomberg code
o CMP
o Target price
o Upside (target price / CMP)
o Rating
o Broker Name
o Analyst Name
o Analyst Email
o Analyst Contact number
o Investment Argument
o Number of Page
o Link/path of the document stored

- Every row to be inserted above the previous one
Any other valuable suggestions
Related categories: Data Processing Excel Power Automate