# How to Utilise Google Maps/Places API Data **URL:** \ **Category:** Ask for Help\ **Created:** [November 12, 2020, 11:47am UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304 "2020-11-12T11:47:58Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [November 12, 2020, 11:47am UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304/1 "2020-11-12T11:47:58Z")
Hi all, I want to be able to use Google Maps API Place data within an app. I have got a Google Maps API key and am able to ‘call’ data using a URL - see example below that grabs the rating of a place. ![111](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/071e86e7f6252dcbbdb7204a03bba9b642e3a64e.jpeg) I want to be able to display things like the Google rating of a place within an app but don’t know how to do this with the information I can grab via a URL. I have seen examples on-line that create a Google Script to extract this data but I’m trying to avoid using scripts (mainly as I don’t want to add things into my app that I can’t fix if they go wrong!). And also I’m not sure if you can legally store Google Maps Data. Any help appreciated ---
**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:** [November 12, 2020, 11:55am UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304/2 "2020-11-12T11:55:43Z")
Does it return a JSON? ---
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [November 12, 2020, 11:58am UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304/3 "2020-11-12T11:58:25Z")
I think it does. Does that make the output more useable? ---
**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:** [November 12, 2020, 1:26pm UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304/4 "2020-11-12T13:26:24Z")
Yeah, I imagine it can work with a custom function called importJSON. > **[bradjasper/ImportJSON](https://github.com/bradjasper/ImportJSON)** > > Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet - bradjasper/ImportJSON ---
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [November 12, 2020, 1:41pm UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304/5 "2020-11-12T13:41:01Z")
Thanks. I’ll have a play to see what that custom function provides and what I can extract from it. ---
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [November 20, 2020, 7:49pm UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304/6 "2020-11-20T19:49:47Z")
Hi. I have managed to get the IMPORTJSON function to work but only when I insert the URL dorectly into the IMPORTJSON formula. I want to reference the URL from another column and when I reference a column within the array formula the IMPORTJSON function comes back with a ‘Error getting data’ message. Copy of formula below. Any help appreciated. =ArrayFormula(IF(ROW($A:$A)=1,“Rating”, IF(AE:AE="","",IMPORTJSON(HYPERLINK(CHAR(34)&AF:AF&CHAR(34)),“result/rating”)))) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 20, 2020, 7:53pm UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304/7 "2020-11-20T19:53:42Z")
I probably wouldn’t use the HYPERLINK function. All it needs is the url text. ---
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [November 20, 2020, 7:56pm UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304/8 "2020-11-20T19:56:24Z")
Thanks. I did also try it without the hyperlink part and it came up with the same. =ArrayFormula(IF(ROW($A:$A)=1,“Rating”, IF(AE:AE="","",IMPORTJSON(CHAR(34)&AF:AF&CHAR(34),“result/rating”)))) ---
**Author:** ![Chad1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chad1/32/35126_2.png) [@Chad1](https://community.glideapps.com/u/Chad1)\ **Post date:** [January 22, 2024, 3:51pm UTC](https://community.glideapps.com/t/how-to-utilise-google-maps-places-api-data/18304/9 "2024-01-22T15:51:25Z")
> **[Using the google maps api to import businesses and parameters required to...](https://www.loom.com/share/c4127b0f94e84a588a77d187d78a662c)**