How to use make to extract address from the item column and populate Location column with it.
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.