Want to extract Google Maps data straight into your spreadsheet?
You can see below the exhaustive list of selectors designed for Google Maps. These built-in data selectors are used within your =IMPORTFROMWEB( ) function and work both with places (i.e. https://www.google.com/maps/place/xxxxxxxx) and search urls (i.e. https://www.google.com/maps/search/xxxxxxxx).
To use the =IMPORTFROMWEB function, you need to input the selector into the function or refer to a cell / range of cells that contain selectors. For example, if you are looking for the name and the rating of a Google Maps place, just write:
=IMPORTFROMWEB("url", "name, rating")
|Collects the name of the place
|This selector collects the type of place it is. For example: restaurant, bank, bar etc.
|Collects the category of the place
|Collects the website of the place
|Collects the name and number of the street of the place
|Collects the city and the postal code of the place
|Collects the name, the street number, the city, the region and the postal code of the place
|Collects the country of the place
|Collects the phone number of the place
|Collects the average rating given to the place (from its google business page). The rating is out of 5
|Collects the number of reviews given to the place (from its google business page)
|Collects the language in which the information and description is written in
|Collects the code of the language in which the information and description is written in (en, fr, it etc.)
|Collects the link of the default image shown on the google maps page. This selector can be combined with the function =IMAGE(link) which will allow you to visualize the image on google sheet
|Collects the timezone of the given address or google page
|Collects the longitude of the address
|Collects the latitude of the address
|Tells you whether the place is currenty opened or closed
|Returns the opening days & hours of the address (can not be mixed with any other selectors)
|Collects the different tags associated to the place
*Please note that those selectors only work with the google maps places URLs (https://www.google.com/maps/place/xxxxxxxx) and do not work with the Google Maps search URLs.
While emails are not directly available via Google Maps, we have two workarounds for this:
- Use IMPORTFROMWEB and the “emails” generic selector on any webpage:
- Use IMPORTFROMGOOGLE to perform a boolean search:
=IMPORTFROMGOOGLE("your query @gmail.com","emails")