search

serpapi / public-roadmap

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

google sheets copy and paste formula get Oops field not found #1335

Closed pleabargain closed 6 months ago

pleabargain commented 6 months ago

Here's the formula

=SERPAPI_RESULT("engine=google&q=new flights&location=Jeddah, Makkah Province, Saudi Arabia&google_domain=google.com.sa&gl=sa&hl=en&tbm=nws", "suggestions.0.value")

plugin is installed API key is active

image

hartator commented 6 months ago

Oops field is not found: suggestions (selector: suggestions.0 value means that this search doesn't have suggestions results unfortunately.

Maybe try different search parameters?

hilmanski commented 6 months ago

Hi @pleabargain
The suggestions.0.value is just a template. You should change it to the actual value you want to retrieve. For example, based on the result here: https://serpapi.com/playground?engine=google_flights&departure_id=CDG&arrival_id=AUS&gl=us&hl=en&currency=USD&outbound_date=2024-01-06&return_date=2024-01-12

Here is the JSON structure result: CleanShot 2024-01-05 at 11 24 48@2x

So to get the first value, we need to replace the suggestions.0.value with best_flights.0.flights.0.departure_airport.name

Here is a basic tutorial on using our Google Sheets extension: https://serpapi.com/blog/connect-serp-api-with-google-sheet-no-code/

If you have any technical questions on using SerpApi, feel free to contact us at contact@serpapi.com