ImportFromWeb has been designed to work efficiently with hundreds of pages at a time, and it can handle up to 4,000 pages in a single spreadsheet.
Please note that Google Sheets can handle 30 functions simultaneously. Thus, processing time increases with a higher number of URLs to scrape, but ImportFromWeb is well-equipped to manage these demands effectively.
For tips on efficiently scraping hundreds or thousands of URLs with ImportFromWeb, we recommend checking out our resource: Our Tips for Mass Web Scraping with ImportFromWeb.