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
- Copy and paste any website URL into Extracto to start pulling data instantly
- Let the AI figure out the page structure and important content automatically
- Export scraped data directly to Google Sheets with one click
- Works on any website without needing to set up complex rules or code
- Continuously updates your spreadsheet as website content changes over time