In theory, yes, that is possible. But the reality is that you'll have each web page structured very differently. And, as such, it will be difficult to get anything useful into the output CSV file dynamically, without actually training your flow on each individual web page.
If you can use some specific keywords to get what you need, you might be able to scrape some of that data and reduce the manual task. But it is highly likely it won't be 100% accurate.
Also, using a search engine to find the specific web pages can also return varying results and unless you actually provide the URLs instead of the names of the companies in your input file, you are likely to get some inconsistencies there, too. If these are all local companies to your area, you might have some local company registry available online or a database of sorts where you can find the web page of the company based on its name. That would make it slightly more accurate.
But still, there are too many possible points of failure in a flow like this to possibly expect RPA to handle it accurately. It works well when all rules in the flow are in fact clear and defined. But when you want to do stuff that's as vague as scraping the same data from 1000+ websites without defining each of them manually, it will likely not work.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
