Yes, you can do it.
If you already have google maps places API then you can directly use it in AirTable Automation Script.
Or you can use some other location-based API that calculates distance based on locations.
You can use checkout more details on the attached page.
Keep in mind that you must need to enable API in the google developer console.
Ok, let me know if your guy can’t do it.
You can use any type of place API which supports it.
Also, keep in mind that these types of APIs are not free so you also have to pay for API calls.
You can see pricing here.