search

serpapi / public-roadmap

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

[Playground] Change Default Selector in Export Code for Google Sheets #860

Open schaferyan opened 1 year ago

schaferyan commented 1 year ago

Customers typically try to copy and paste the Google Sheets formula from Export to Code into their Google Sheets and expect it to work as is. Currently the default selector is always "suggestions.0.value" which leads to an error for most engines.

Screenshot 2023-05-17 at 2 43 02 PM

While the customer would still need to learn about how to modify the selector to get the data points they are interested in, at a minimum we can provide a different selector depending on which engine is used.

Potentially we could also have this change based on which element or key the user has clicked in the iFrame or JSON. However this might require more work.

Intercom

schaferyan commented 8 months ago

This continues to be a source of confusion for Google Sheets users.

A user recently opened a Public Roadmap issue due to this:

https://github.com/serpapi/public-roadmap/issues/1335

Freaky commented 6 months ago

As part of #1406 I changed this to organic_results.0.title, on the basis that it's more likely to work on typical engines.

hilmanski commented 3 months ago

Just to clarify, it currently shows organic_results.0.title for all engines, including Google News. CleanShot 2024-06-06 at 06 29 23

I mentioned this since a customer confused about this. Intercom

NateSkiles commented 1 month ago

I had a user run into some confusion with this, as well working with the Google Maps API

=SERPAPI_RESULT("engine=google_maps&type=search&google_domain=google.com&q=Coffee&ll=" & ENCODEURL("@40.7455096,-74.0083012,14z") & "&hl=en", "organic_results.0.title")

organic_results.0.title instead of local_results.0.title

Intercom