# Pass values to Google Sheet **URL:** \ **Category:** General\ **Created:** [October 30, 2022, 10:58pm UTC](https://community.glideapps.com/t/pass-values-to-google-sheet/52921 "2022-10-30T22:58:47Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Danimirror](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danimirror/32/49590_2.png) [@Danimirror](https://community.glideapps.com/u/Danimirror)\ **Post date:** [October 30, 2022, 10:58pm UTC](https://community.glideapps.com/t/pass-values-to-google-sheet/52921/1 "2022-10-30T22:58:47Z")
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 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 31, 2022, 2:31am UTC](https://community.glideapps.com/t/pass-values-to-google-sheet/52921/2 "2022-10-31T02:31:10Z")
> [@Is there a limit on the number of map pins? I need 1300](https://community.glideapps.com/t/is-there-a-limit-on-the-number-of-map-pins-i-need-1300/50094/8): > > [https://nominatim.org/release-docs/latest/api/Search/](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. ---
**Author:** ![Danimirror](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danimirror/32/49590_2.png) [@Danimirror](https://community.glideapps.com/u/Danimirror)\ **Post date:** [October 31, 2022, 9:32am UTC](https://community.glideapps.com/t/pass-values-to-google-sheet/52921/3 "2022-10-31T09:32:34Z")
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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/8/68df0dff9920d57ce7ee38a494c6641ef0cb8a2a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f23ef6c1ad0667cde67706e6b17a7a6d16b770a5.jpeg) And this is my lat column configuration: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/add47e7718d446d680e90810085d77965874317b.png) But as you can see, no values are fetched ☹ ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [October 31, 2022, 10:33am UTC](https://community.glideapps.com/t/pass-values-to-google-sheet/52921/4 "2022-10-31T10:33:28Z")
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 ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [October 31, 2022, 10:55am UTC](https://community.glideapps.com/t/pass-values-to-google-sheet/52921/5 "2022-10-31T10:55:43Z")
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](https://nominatim.openstreetmap.org/search/Unter%20den%20Linden%201%20Berlin?format=json&addressdetails=1&limit=1&polygon_svg=1) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ffce718148c3887d69a5a17c53073da5728b09a0.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 31, 2022, 11:43pm UTC](https://community.glideapps.com/t/pass-values-to-google-sheet/52921/6 "2022-10-31T23:43:43Z")
Is this the same “Fetch JSON” column Dan was using above? ---
**Author:** ![Danimirror](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/danimirror/32/49590_2.png) [@Danimirror](https://community.glideapps.com/u/Danimirror)\ **Post date:** [November 1, 2022, 10:07am UTC](https://community.glideapps.com/t/pass-values-to-google-sheet/52921/7 "2022-11-01T10:07:45Z")
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](https://nominatim.openstreetmap.org/search.php?q=address&format=jsonv2) ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 2, 2022, 10:08am UTC](https://community.glideapps.com/t/pass-values-to-google-sheet/52921/8 "2022-11-02T10:08:08Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.