Help me creating a workflow to automate Web+Excel+AI

Reddit r/artificial / 4/23/2026

💬 OpinionDeveloper Stack & InfrastructureIdeas & Deep AnalysisTools & Practical Usage

共有:

Key Points

A beginner is asking how to build a workflow that automates extracting data from the web (including PDFs) and converting it into Excel.
They want to use AI as a “brain” for the automation, such as generating formulas and functions and filling Excel cells according to requirements.
The user requests guidance on which skills to learn (e.g., VBA, Python, Power Query) and what level of technical knowledge is needed.
They also ask which automation tool to use (for example, Microsoft Power Automate) and want a practical learning roadmap with video playlist links.

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:

Automate the extraction of PDF from the Web, and convert the data given in the file to Excel
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.
So, tell me how I can do this and what skills I need to learn (VBA, Python, Power Query)
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!

submitted by /u/Stunning_Capital_354
[link] [comments]