search

serpapi / public-roadmap

Public Roadmap for SerpApi, LLC (https://serpapi.com)
45 stars 3 forks source link

[Google Sheets Extension] `SERPAPI_RESULT` formula returning `#ERROR!` for some countries #1684

Open martin-serpapi opened 2 weeks ago

martin-serpapi commented 2 weeks ago

A user reported that the SERPAPI_RESULT formula returns #ERROR! when some countries are selected in the Locale settings in Google Sheets. Below is an example using Locale=Argentina:

image

The same formula returns results when a different country, Australia for example, is selected in the File -> Settings -> General -> Locale settings:

image

SERPAPI_RESULT formula:

=SERPAPI_RESULT("engine=google&q=Coffee&location=Austin, Texas, United States&google_domain=google.com&gl=us&hl=en", "organic_results.0.title")

Front | intercom