Google maps distance integration

Our company filters our leads based on their distance from us in miles. We have a distance field that we manually update but it is time consuming to check each one manually. Has anyone been able to create an automation to determine the driving distance between two addresses and set that as the value in a custom field? In google sheets we are able to leverage the google maps API but I have not had luck doing this in pipedrive.

Comments