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 |
| category | Collects the category of the place. For example: restaurant, bank, bar etc. |
| 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 |
| place_url | Collects the Google Maps place URLs found from a Google Maps Search URL |
| place_status* | Tells you whether the place is currenty opened or closed |
| time_table* | Returns the opening days & hours of the address (can not be mixed with any other selectors) |
| place_tags* | Collects the different tags associated to the place |
| place_id* | Extracts the unique identifier of the place |
| feature* | Returns the attributes of the place (Reservations required, Kids’ menu, Free parking lot, etc.) |
*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.
NOTICE: emails are not directly available via Google Maps.
However, we have two workarounds for this:
- Use IMPORTFROMWEB and the “emails” generic selector on any webpage:
IMPORTFROMWEB("https://www.example.com", "emails") - Use IMPORTFROMGOOGLE with a boolean search:
=IMPORTFROMGOOGLE("your query @gmail.com","emails")
You can try this Google Sheets template to collect emails from the website associated to the Google My Business account.