Google maps data selectors

Want to extract Google Maps data straight into your spreadsheet?

You can see below the exhaustive list of selectors designed for Google Maps places. These built-in data selectors are used within your =IMPORTFROMWEB( ) function; just pick them up directly in our Google Maps template (in the IMPORTFROMWEB sidebar) or use them by yourself in your own spreadsheet. 

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
nameCollects the name of the place
typeThis selector collects the type of place it is. For example: restaurant, bank, bar etc. 
categoryCollects the category of the place
websiteCollects the website of the place
address_1Collects the name and number of the street of the place
address_2Collects the city and the postal code of the place
address_fullCollects the name, the street number, the city, the region and the postal code of the place
countryCollects the country of the place
phone_numberCollects the phone number of the place
ratingCollects the average rating given to the place (from its google business page). The rating is out of 5
reviews_countCollects the number of reviews given to the place (from its google business page)
languageCollects the language in which the information and description is written in 
language_codeCollects the code of the language in which the information and description is written in (en, fr, it  etc.)
image_sourceCollects 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
timezoneCollects the timezone of the given address or google page
longitudeCollects the longitude of the address
latitudeCollects the latitude of the address