Sign up for free
Functions

DISTANCE_MATRIX_GOOGLE

Get the recommended distance and time between start and end locations.

icon of Google MapsGoogle Maps
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

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

Start address. For example: "515 Broadway, New York".

end

Start address. For example: "148 Lafayette St Floor, New York".

[optional] mode

The travel mode. Choose either:

  • "driving" (default)

  • "walking"

  • "bicycling"

  • "transit"

Selected options:
Bicycling
Driving
Transit
Walking
[optional] start_time

The departure time in UNIX format. For example: 1600281000. If provided, it ignores end_time.

[optional] end_time

The arrival time in UNIX format. For example: 1600281000.

[optional] avoid

What transit elements to avoid in the route. Choose either:

  • blank or "" (default) for normal routing

  • "tolls"

  • "highways"

  • "ferries"

  • "indoor"

Selected options:
Ferries
Highways
Indoor
Routing

Examples

DISTANCE_MATRIX_GOOGLE("New York,NY|Boston,CA", "Miami,FL|Palm Beach,FL") returns JSON with directions from New York to Miami and Palm Beach (first row) and from Boston to Miami and Palm Beach (second row)