How can i automate Web+Excel+AI?

I have a commerce background. I am a beginner (Please guide me like a begginer i can't understand heavy tech language), and I don't have experience with Agentic AI, Automation, or coding. So, I want to know how I can automate Web+Excel+AI and what skills I need to do so, like coding or n8n.
This is how my workflow looks:

1. Automate the extraction of PDF from the Web, and convert the data given in the file to Excel
2. Creating an AI which act as a brain for automation and does what I want to make them do, like sum, putting different-different formula and functions in each cell as per the requirement.

This is the basic workflow.
And which Automation tool should I use to do the above, like MS Power Automate?
Give me a Roadmap of where I should begin my tech skills.
This will be a plus if you can provide Video links to the playlist.

Thank you for helping in advance!