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.
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
I think it does. Does that make the output more useable?
Yeah, I imagine it can work with a custom function called importJSON.
Thanks. I’ll have a play to see what that custom function provides and what I can extract from it.
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.
I probably wouldn’t use the HYPERLINK function. All it needs is the url text.
Thanks. I did also try it without the hyperlink part and it came up with the same.