A new question: the distance calculated betwe...

[Marlon_Xavier_M]

A new question: the distance calculated between latlong and a changelocation is in straight line? or on a route?

[Levent_KULACOGL]

@Marlon_Xavier_Medina the calculation is as per straight line, not on a route. To calculate as per a route, you need Google Maps API Scripting.

[Marlon_Xavier_M]

DO this API work together with Appsheet?

[Levent_KULACOGL]

@Marlon_Xavier_Medina any publicized external API can work with AppSheet. However you should construct a script for that. You can create a standalone Google Apps Script project, publish it as a webapp and then use its URL as a webhook URL endpoint in AppSheet.