Pass values to Google Sheet

General
1

Hi guys!

What’s the best practice to pass a column of data to Google Sheets?

In my use case, I have a table with restaurants, where one of the columns is an address. My goal is to populate another column in Restaurants with the latitude and longitude of the restaurant address automatically (as this seems to be best practice when displaying the address in Mapbox). The conversion to latitude and longitude is quite easy to do in Google Sheets, so I want to pass the column with all the restaurant addresses to Google sheets.

I would that action to be triggered automatically, so that everytime I add restaurants to my database, these restaurants are added automatically to Google sheets.

Thanks :slight_smile:

2

You can do this using the fetch URL column instead.

2 Likes
3

Thanks @ThinhDinh
I have followed the tutorial, but the step where the Experimental Code column tries to fetch the JSON latitude doesn’t work for me…

I have built the URL and if I put in Chrome, it gives me back the JSON, so I think this part is fine.

image
image1240×276 39.9 KB

image
image2018×1092 152 KB

And this is my lat column configuration:
image

But as you can see, no values are fetched :frowning:

4

Hi Dani,

Can you remove the jq query and see if anything comes up or just put in the period <.> on its own, to make sure its not a jq reference issue. I am doing something similar but I am using Fetch JSON

5

seems to work with fetch JSON

https://nominatim.openstreetmap.org/search/Unter%20den%20Linden%201%20Berlin?format=json&addressdetails=1&limit=1&polygon_svg=1

image
image676×677 42 KB

3 Likes
6

Is this the same “Fetch JSON” column Dan was using above?

7

Found the problem. It seems the format of the API has changed slightly.

When using the following format it worked well:

https://nominatim.openstreetmap.org/search.php?q=address&format=jsonv2

2 Likes
8

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.