fetch_google_places

Given the latitude and longitude coordinates of a location in each row, uses the Google Places API to enrich the dataset with information about the surrounding businesses, their ratings etc. See below for further information about the specific columns to be added by the step.

???+ info “API integration” To use this step your team needs to have the Google Places integration configured in Graphext. The corresponding credentials are required to connect to a third-party API. You can configure API integrations following the INTEGRATIONS or ADD INTEGRATION link in the top-left corner of your Team’s page, selecting API keys, and then the name of the desired third-party service.

To enable the Google Places integration in particular you will need access to Google’s Places API. Follow the instructions here to create the required API key.

fetch_google_places(lat: number, lon: number, {
    "param": value,
    ...
}) -> (
	places_total: number,
	places_number_ratings: number,
	places_ratings_mean: number,
	places_number_types: number,
	places_types: list[category],
	places_names: list[category]
)

integration

string

required

ID of the integration you’d like to use.

radius

number

default:"1500"

Search radius in meters around the given location.

Values must be in the following range:

10 ≤ radius < inf

type

[string, null]

Search for a specific type of place only. For supported types also see the Google Places documentation here.

Values must be one of the following:

accounting airport amusement_park aquarium art_gallery atm bakery bank bar beauty_salon bicycle_store book_store bowling_alley bus_station cafe campground car_dealer car_rental car_repair car_wash casino cemetery church city_hall clothing_store convenience_store courthouse dentist department_store doctor drugstore electrician electronics_store embassy fire_station florist funeral_home furniture_store gas_station grocery_or_supermarket gym hair_care hardware_store hindu_temple home_goods_store hospital insurance_agency jewelry_store laundry lawyer library light_rail_station liquor_store local_government_office locksmith lodging meal_delivery meal_takeaway mosque movie_rental movie_theater moving_company museum night_club painter park parking pet_store pharmacy physiotherapist plumber police post_office primary_school real_estate_agency restaurant roofing_contractor rv_park school secondary_school shoe_store shopping_mall spa stadium storage store subway_station supermarket synagogue taxi_stand tourist_attraction train_station transit_station travel_agency university veterinary_care zoo

keyword

string

Specific keyword to use in the search for places.

Prepare

Analyse

Report