Integration spotlight: Google Maps

Overview

Our Google Maps integration is just what you need if you want to get directions, geocode locations and find their locations, or search for places and get their details.

Pricing and API limits

All function cost 0.01 per execution, except for:

  • NEARBY_SEARCH_GOOGLE and PLACE_SEARCH_GOOGLE cost 0.12 per execution,
  • PLACE_DETAIL_GOOGLE cost 0.04 per execution

All functions return as much data as is possible within dashdash’s cell limits.

Functions

Function Description
DIRECTIONS_GOOGLE Get directions to a place.
REVERSE_GEOCODE_GOOGLE Get the address for a set of coordinates.
PLACE_SEARCH_GOOGLE Get places that match your search.
PLACE_DETAIL_GOOGLE Get details about a place.
NEARBY_SEARCH_GOOGLE Get places within a location.
GEOCODE_GOOGLE Get coordinates for an address.
ELEVATION_GOOGLE Get the elevation for some coordinates.
DISTANCE_MATRIX_GOOGLE Calculate a matrix of directions.

DIRECTIONS_GOOGLE

Use DIRECTIONS_GOOGLE to get directions according to your start and end locations. You can also narrow down your search by adding the start time, transport mode, what transit elements to avoid, and even add waypoints.
And to get everything neatly in a table with just one click, use our Directions recommended table.

Syntax

DIRECTIONS_GOOGLE(start, end, [mode], [start_time], [end_time], [avoid], [waypoints])

Parameter Mandatory Description
start Yes The origin name, address, latitude and longitude, or Google place ID. For example: "Porto, Portugal".
end Yes The destination name, address, latitude and longitude, or Google place ID. For example: "Berlin, Germany".
mode No The travel mode. Choose either:
- "driving" (default)
- "walking"
- "bicycling"
- "transit"
start_time No The departure time in UNIX format. For example: 1600281000. If provided, it ignores end_time.
end_time No The arrival time in UNIX format. For example: 1600281000.
avoid No What transit elements to avoid in the route. Choose either:
- blank or "" (default) for normal routing
- "tolls"
- "highways"
- "ferries"
- "indoor"
waypoints No List of addresses, "latitude,longitude", or Google place IDs to stop on the way, separated by a |. For example: "Madrid,Spain|Paris,France".

:memo: Note: To convert a normal time to UNIX time, use our UNIX() function.

Examples

If you want to get the directions from Berlin to Hamburg:

=DIRECTIONS_GOOGLE("Berlin, Germany","Hamburg, Germany")

If you want to get bicycle directions from the train station in Berlin to the Reichstag:

=DIRECTIONS_GOOGLE("Hauptbanhoff, Berlin","Reichstag, Berlin","bicycle")

If you want to get directions from Porto to Lisbon, via Coimbra, and leaving at 2020-09-18 16:00:00 (1600444800)

=DIRECTIONS_GOOGLE("Porto, Portugal","Lisbon, Portugal",,1600444800,,,"Coimbra, Portugal")

Directions example

DISTANCE_MATRIX_GOOGLE

Use DISTANCE_MATRIX_GOOGLE to calculate the distance and duration for a matrix of starting locations and destinations. For example, if you want to know if it’s shorter to go from Porto or Lisbon to Coimbra or Faro, you’d use this function to caluculate that. It’ll calculate:

  • Porto to Faro
  • Porto to Coimbra
  • Lisbon to Coimbra
  • Lisbon to Faro

You can further define the calculation by adding a mode of transportation, a start or end time, and what transit elements to avoid.

If just want to know the distance and duration for the first combination, use our Distance and duration recommended table.

Syntax

DISTANCE_MATRIX_GOOGLE(start, end, [mode], [start_time], [end_time], [avoid])

Parameter Mandatory Description
start Yes List of origin names, addresses, latitude and longitude, or Google place IDs, separated by a |. For example: "Porto, Portugal | Lisbon, Portgual".
end Yes List of destination names, addresses, latitude and longitude, or Google place IDs, separated by a |. For example: "Berlin, Germany | Hamburg, Germany".
mode No The travel mode. Choose either:
- "driving" (default)
- "walking"
- "bicycling"
- "transit"
start_time No The departure time in UNIX format. For example: 1600281000. If provided, it ignores end_time.
end_time No The arrival time in UNIX format. For example: 1600281000.
avoid No What transit elements to avoid in the route. Choose either:
- blank or "" (default) for normal routing
- "tolls"
- "highways"
- "ferries"
- "indoor"

:memo: Note: To convert a normal time to UNIX time, use our UNIX() function.

Examples

To figure out which Portuguese city is closest to Berlin or Hamburg, avoiding highways:

=DISTANCE_MATRIX_GOOGLE("Porto, Portugal | Lisbon, Portugal","Berlin, Germany | Hamburg, Germany",,,"highways")

Distance matrix example

ELEVATION_GOOGLE

Use ELEVATION_GOOGLE to quickly find the elevation, in meters, of any geographic coordinates.

Syntax

ELEVATION_GOOGLE(lat, long, [short])

Parameter Mandatory Description
lat Yes The latitude of a location. For example: "41.1579438".
long Yes The longitude of a location. For example: "-8.6291053000".
short No Boolean indicating whether to return just the elevation or not. Choose either:
- TRUE to get just the elevation (default)
- FALSE to get additional information`

Examples

To get the elevation for the geographic coordinates 41.1579438,-8.6291053000:

=ELEVATION_GOOGLE("41.1579438","-8.6291053000")

Elevation example

GEOCODE_GOOGLE

Use GEOCODE_GOOGLE if you want to get the latitude and longitude, and even the place ID, for a given address. And to speed things out, try these data rows:

  • Latitude and longitude to get the latitude and longitude
  • Place ID and location to get the Google place ID and formatted address

Syntax

GEOCODE_GOOGLE(address, [short])

Parameter Mandatory Description
address The address to be converted. For example: "R. de São Filipe de Nery, 4050-546 Porto".
short Boolean indicating whether to return just the coordinates or not. Choose either:
- TRUE to get just the coordinates
- FALSE to get additional information (default)

:memo: Note: When short is set to TRUE, the data rows will not return any values.

Examples

To get just the latitude and longitude of R. de São Filipe de Nery, 4050-546 Porto:

=GEOCODE_GOOGLE("R. de São Filipe de Nery, 4050-546 Porto", TRUE)

Geocode example

NEARBY_SEARCH_GOOGLE

Use NEARBY_SEARCH_GOOGLE to find places within a radius of a given set of coordinates. You can narrow down your search by providing keywords and even place types.
To get your results quickly and neatly into a table, just use our Places recommended table.

Syntax

NEARBY_SEARCH_GOOGLE(lat, long, radius, [query], [type])

Parameter Mandatory Description
lat Yes The latitude of a location. For example: "41.1579438".
long Yes The longitude of a location. For example: "-8.6291053000".
radius No The radius, in meters, within in which to find places. For example: "2000".
query No Search terms that identify the business or public point of interest to find. For example: "PGE" or "KFC, chicken".
type No The type of place to return. For example: "meal_takeaway". For a list of supported types, check Google’s documentation.

Examples

To get as many places as possible within 1000 meters of 41.1579438,-8.6291053000:

=NEARBY_SEARCH_GOOGLE("41.1579438","-8.6291053000","1000")

To get all the barbeque or chicken restaurants within 2000 meters of 41.1579438,-8.6291053000:

=NEARBY_SEARCH_GOOGLE("41.1579438","-8.6291053000","2000","barbeque, chicken","restaurant")

Nearby search example

PLACE_DETAIL_GOOGLE

Use PLACE_DETAIL_GOOGLE when you want to get details about a specific place, such as the phone number, opening hours, or reviews. Try out these recommended data rows to get the information you need in one click:

  • Contact details to get the official name, address, phone number, and website of the place
  • Latitude and longitude to get the geographic coordinates

And if you want to see the user reviews, just use the User reviews recommended data table.

Syntax

PLACE_DETAIL_GOOGLE(place_name)

Parameter Mandatory Description
place_name Name or Google place ID of the point of interest. For example: "Berlin Hauptbanhoff" or "ChIJe-ff-71RqEcRqvy8lRR4PHo".

Examples

To get details on the Eiffel Tower:

=PLACE_DETAIL_GOOGLE("Eiffel Tower")

Place detail example

PLACE_SEARCH_GOOGLE

Use PLACE_SEARCH_GOOGLE when you want to find places, along with their addresses, place IDs, coordinates, and ratings, based on a query. You don’t need to provide a location if you don’t want to - just make sure that your keywords are spot on to find what you need.
Then, why not use the Places recommended table to get the place’s names, addresses, ID’s, types, ratings, number of user ratings, and opening hours all into a table. Or, if you just want the geographic coordinates, use the Latitude and longitude data row.

Syntax

PLACE_SEARCH_GOOGLE(search_query, [short])

Parameter Mandatory Description
search_query Yes Search terms that identify the business or public point of interest you want to find. For example: "McDonalds in London". Note: If you just use "McDonalds London", you’ll get results for McDonalds that have London in their name.
short No Boolean indicating whether to return just the first place found or not. Choose either:
- TRUE to get just the first place (default)
- FALSE to get additional places

Examples

To get all the KFCs in London:

=PLACE_SEARCH_GOOGLE("KFC in London")

Place search example

REVERSE_GEOCODE_GOOGLE

Use REVERSE_GEOCODE_GOOGLE when you need to get the formatted address of some geographic coordinates.

Syntax

REVERSE_GEOCODE_GOOGLE(lat, long, [short])

Parameter Mandatory Description
lat Yes The latitude of a location. For example: "41.1579438".
long Yes The longitude of a location. For example: "-8.6291053000".
short No Boolean indicating whether to return just the address or not. Choose either:
- TRUE to get just the address (default)
- FALSE to get additional information

Examples

To get the address for a place with a latitude of 41.1579438 and a longitude of -8.6291053000:

=REVERSE_GEOCODE_GOOGLE("41.1579438","-8.6291053000")

Reverse geocode example

Summary

So, never again will you have trouble getting details about or directions to a place. And what’s better - you get it all in a spreadsheet. Naturally, we’ve made it even simpler with some templates:

So, time to travel the world and build :rocket:!