By default, the =IMPORTFROMGOOGLE() formula returns the first 10 organic results from Google Search on any query.
To extract more than the initial 10 results, you can use the num_results option within the IMPORTFROMGOOGLE formula. This option allows you to specify the number of results to be extracted for each keyword.
Here’s an example formula to retrieve the first 100 results:
=IMPORTFROMGOOGLE("your query", "title,link", "num_results:100")
Please note that the maximum value accepted is 300. And this 300 records cap is set by Google itself (by the way, when you serach on Google, you get a maximum of 30 pages with up to 10 records per page).