It’s important to note that the number of results you receive through IMPORTFROMGOOGLE is determined by Google itself and can vary based on several factors. Sometimes, Google displays widgets or other elements alongside search results, affecting the count and presentation of organic results.
This variation can result in cases where the expected 10 results might not be returned or where some results appear to be missing.
If obtaining precisely the top 10 results is crucial, utilizing an ARRAY_CONSTRAIN
formula can be an effective solution. This function allows users to limit the number of rows and columns in the returned array, ensuring precise control over the displayed results.