If you want to "automatically retrieve information from websites," then Web scraping is a useful tool. I originally used VBA for scraping, but it became overwhelmingly easier after switching to Python ...
How to Scrape Google Maps Reviews: 3 Methods Ranked from Easy to Painful — Which One Actually Works at Scale, How to Pick the Right Tool, and Why Most DIY Scripts Break by Monday Google Maps reviews ...