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 thi…

[image] Is there a limit on the number of map pins? I need 1300 https://nominatim.org/release-docs/latest/api/Search/ Or you can try this API straight in the fetch URL column. You can do this using the fetch URL column instead.

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] [image] And this is my lat column …

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

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]

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

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

Pass values to Google Sheet

General

ThinhDinh October 31, 2022, 2:31am 2

You can do this using the fetch URL column instead.

Topic		Replies	Views
Computed columns Ask for Help	3	178	May 12, 2023
Automatic geocoding using Google Scripts Ask for Help	37	5165	June 26, 2025
Auto Complete Address Ask for Help	12	146	September 4, 2024
Fetch Column Ask for Help custom-code	76	5722	March 8, 2022
Geocoding addresses in Google Sheets Ask for Help	1	549	June 8, 2020

Pass values to Google Sheet

Related topics