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?
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.