Web+Excel+AIを自動化するワークフローの作り方を教えてください

Reddit r/artificial / 2026/4/23

💬 オピニオンDeveloper Stack & InfrastructureIdeas & Deep AnalysisTools & Practical Usage

要点

  • 初心者として、WebからPDFを含むデータを抽出し、それをExcelに変換する自動化ワークフローの作り方を質問しています。
  • AIを「自動化の頭脳」として使い、条件に応じてExcelの各セルへ式や関数を生成・適用することを想定しています。
  • VBA、Python、Power Queryなど、必要なスキルと求められる技術レベルについてガイダンスを求めています。
  • さらに、Microsoft Power Automateのような自動化ツールの選定や、動画リンク付きの学習ロードマップも希望しています。

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.
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]