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")
=IMPORTFROMWEB(A2,B1:C1)
| Selector | Description |
| name | Collects the name of the place |
| type | This selector collects the type of place it is. For example: restaurant, bank, bar etc. |
| category | Collects the category of the place |
| website | Collects the website of the place |
| address_1 | Collects the name and number of the street of the place |
| address_2 | Collects the city and the postal code of the place |
| address_full | Collects the name, the street number, the city, the region and the postal code of the place |
| country | Collects the country of the place |
| phone_number | Collects the phone number of the place |
| rating | Collects the average rating given to the place (from its google business page). The rating is out of 5 |
| reviews_count | Collects the number of reviews given to the place (from its google business page) |
| language | Collects the language in which the information and description is written in |
| language_code | Collects the code of the language in which the information and description is written in (en, fr, it etc.) |
| image_source | 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 |
| timezone | Collects the timezone of the given address or google page |
| longitude | Collects the longitude of the address |
| latitude | Collects the latitude of the address |