I’ve been thinking about something similar - Microsoft needs to make dead simple “AI scripts” record: I download this csv file, I then manipulate the data this way, add these formulas, add a cover sheet, do these checks, and then upload the new sheet a with the following columns into system X. Once you have that recorded, and adjusted to what you want. Next you just download the file and run the script.
The amount of repetitive data manipulation at companies is literally insane, just ask anyone in accounting, operations, hr, etc… just being able to automate repetitive task in excel for people that can’t code or aren’t excel/Vba super users would be incredibly valuable.
This is exactly what PowerBi does, once you downloaded your file if it has the same name as the previous one and is in the same place you can just hit refresh in Bi.
That’s how custom agents in Microsoft copilot and Microsoft copilot studio work.
You pretend it’s AI, but in reality you’re just building literally power automate flows which you can call through an LLM lmao