How do I extract only the first Google result using IMPORTFROMGOOGLE?

By default, the =IMPORTFROMGOOGLE() formula returns the first 10 organic results from Google Search on any query.

To retrieve only the first result, you can use the num_results option as a 3d parameter of your function. This option allows to specify the number of results to extract for each keyword.

And here’s the formula to retrieve the first Google Search result:

=IMPORTFROMGOOGLE("your query", "title,link", "num_results:100")