You do not need to learn to code to automate the web, Excel, and AI. That is not a motivational slogan; it is the practical reality of the tools available today, and the workflow you described is a perfect example of what is now possible for someone with a commerce background and no technical training.
Your instinct to separate the problem into two parts is exactly right. First, you want to pull a PDF from the web and turn its contents into an Excel file. Second, you want an AI layer that can read that spreadsheet and apply formulas or functions cell by cell, based on what the data requires. Neither of these steps demands that you write a single line of Python or JavaScript. Tools like n8n are built for people like you: they use visual nodes and drag-and-drop connections, so you can build a workflow by seeing it, not by memorizing syntax. Power Automate works similarly if you prefer a Microsoft-centric environment. The skill you actually need is not coding; it is logical sequencing. You need to think in steps: fetch the file, save it, parse it, map the columns, then send that output to an AI prompt that tells it exactly what to do with each cell.
The second part, the AI acting as a brain, is where your commerce background becomes an advantage. You already know what "sum" or "apply a vlookup" means in a business context. The new skill is translating that intent into a clear instruction for the AI. For example, instead of saying "analyze this," you would say, "For each row, if column A is greater than 100, multiply column B by 0.9; otherwise, leave it unchanged." That is not technical jargon; it is structured thinking. You can practice this by writing plain-English rules for a spreadsheet you already use, then testing how the AI interprets them. Over time, you will learn how to phrase prompts to get consistent results. This is a learnable skill, and it is far more accessible than traditional programming.
As for a roadmap, start with a single end-to-end project that mirrors your own workflow. Choose a free n8N account, find a tutorial that shows how to fetch a PDF from a URL, and follow it step by step. Then add a second node that parses the PDF into a table, and a third node that sends that table to an AI model with a prompt you wrote yourself. Do not try to learn everything at once. Master one connection: web to Excel. Then add the AI layer. There are excellent beginner playlists on YouTube from channels like N8N's official tutorials or "Make Sense" style educators who explain automation without assuming prior knowledge. Search for "n8n PDF to Excel tutorial" and you will find exactly what you need.
The barrier to entry has moved from knowing how to code to knowing how to describe what you want. That is a shift you can exploit starting today. Your commerce background means you already understand the "why" behind the data. The automation tools handle the "how." Your only real task is to learn the vocabulary of triggers and actions, and you can do that in an afternoon. So start with one PDF, one Excel sheet, and one clear instruction. Build that small win, then expand. That is the entire roadmap.