google sheets copy and paste formula get Oops field not found

[pleabargain]

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

[hartator]

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]

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:

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