This task can be performed using Extracto
Automagically scrape any website into Google Sheets with AI.
Best product for this task

Extracto
productivity
Extracto.bot is a no-configuration, intelligent web scraper. Use Google Sheets and AI to automagically collect data from any site.

What to expect from an ideal product
- Simply paste website URLs into Google Sheets and let the AI figure out what data to grab
- Works right away without setting up any code or configuring scrapers
- Pulls data automatically by understanding the website's structure using AI
- Saves everything directly to your Google Sheets where you can easily work with it
- Gets around website changes by adapting to new layouts without manual updates