Hi,
My name is Chandrasekhar and I have overall 12+ years of experience with SharePoint development.
I have good hands on automation with SharePoint Power Automate flows, Power apps and SharePoint Online and On-Prem Development.
I have worked with simple, medium and complex power automate flows.
I have worked with different connectors like Excel Online, SharePoint, Outlook, teams.
I have created, updated and copied data to and from excelcsv with flows and have working knowledge of it.
I would suggest power automate for the same. we can discuss more on the approach on a call/meeting.
Regards,
Chandrashekhar