Aug 12, 2022 08:15 AM
Hey! I recently added the Maps extension and connected the Google API, however, when it comes to the next steps I’m stumped at what to do. For context, we are a small non-profit that offers two programs, and this one specifically provides diapers, wipes, and formula.
When our mamas submit request forms with their full address, we want to capture the distance between their home and our Diaper Bank. If they’ve selected ‘contactless drop-off’ and their home address is outside of the GA perimeter (xx radius) then their status will change to ‘office pick-up’ and send an automated message.
Is this possible? And if so, what do I need to do or what resources are available for me to attempt the setup?
Thanks for the help!
Aug 12, 2022 09:18 AM
Aug 12, 2022 03:34 PM
Your best bet is to find some online route-planning software that is already setup for those purposes
They already have that with Google Maps API.
One thing to consider, radius is not always an exact measure of travel distance.
Since you have an API key, you can have Make.com call Google Maps and give you the resulting distance back in Airtable.
While Airtable cannot perform this natively, it is pretty easy to set up in gasp… Google Sheets.
See this link: Google Maps Formulas for Google Sheets - Digital Inspiration
You can copy the example sheet to get the Google Apps script that is required.
If you want to stay in Airtable, create an automation that appends a new row with both address’ now google sheets can tell you the distance, now you can set up a ZAP to feed the resulting distance back to Airtable. Keep in mind this is driving distance, so not radius distance. But the nice thing is you do not need a Google Maps API key which I believe requires a credit card on file.
Aug 12, 2022 04:51 PM
Oh wow, thanks so much for pointing that out to me! I didn’t even realize this, and I use Make.com every single day with my Airtable clients! Lol. :crazy_face: :man_facepalming:
Make natively offers the ability to Get A Distance Matrix using Google Maps.
I haven’t yet tested this on my end, but this could end up being incredibly easy & already completely figured out for @Tender_Team!
Some instructions on how to use the Distance Matrix are located here.
And a basic list of the native Google Maps functionality are located here:
Aug 17, 2022 10:18 AM
This is so far beyond my general understanding :grinning_face_with_sweat: but I’ll work it out! Thank you BOTH for the insight and resources. I’ll start the trial and error phase now! :stuck_out_tongue_closed_eyes:
Aug 17, 2022 12:51 PM
Haha, you’re welcome! I would highly recommend doing it directly with Make, so you don’t have to deal with any programming code!