How to use Make to extract address from the item column and populate Location column with it

Platform discussions
1

How to use make to extract address from the item column and populate Location column with it.

2

Hi Mike,

You need to get the latitude and longitude of the address and use them to populate a GraphQL mutation request.

Here are the details for the GraphQL: Location

How can you get longitude and latitude? There might be some free solutions, but a common approach would be to use Google Maps API and then use a Google Maps module in make to search for a location based on the string from the item column.

Google Maps is free up to a point and fairly generous with the amount of monthly requests, so if you’re using it on a small scale you should be fine.

Here’s a starting point: Google Maps Platform Documentation  |  Google Developers

It’s a little daunting, but hopefully that points you in the right direction. Feel free to reach out if you need help.

3

Hi @mdzemtsov @FrancisElliott

Great news! We’ve just released a new feature in our app Location Toolkit that allows you to convert any address into a Location column. For example when a form is submitted or when you import an excel containing addresses.

In this video you can see the feature in action, although we’re using an import as an example, you can also use a different trigger, like a button click, to convert the existing text value into a Location column.

Don’t hesitate to reach out when you have any questions or thoughts!

Best,

Maarten