Reply
Frequent Visitor
Posts: 8
Registered: ‎09-20-2017

Google My Business Reviews API

Has anyone been able to list all of their reviews in My Business via Power Query?

 

I am trying to list all reviews from multiple locations and already have an established key. I get an error when I test the URL for a single location in a web browser:

 

{
  "error": {
    "code": 401,
    "message": "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",
    "status": "UNAUTHENTICATED"
  }
} 

  I have tried connecting through Power Query but I get the error:

"A Web API key can only be specified when a web API key name is provided." I am trying to connect to the source through the web connector and pass the key through the WEB API access. 

 

I've followed the steps outlined by Google but still cannot figure this one out:  

 

 

Moderator
Posts: 8,880
Registered: ‎03-10-2016

Re: Google My Business Reviews API

@caseyd,

Based on the article, you need to use OAuth credential to access the Google My business API. I would recommend you get OAuth credential first, then use Power Query to connect to the API following the guide in the blog below.

https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

Regards,
Lydia

Regular Visitor
Posts: 42
Registered: ‎05-17-2018

Re: Google My Business Reviews API

@caseyd have you been successful in connecting the review data yet?

Frequent Visitor
Posts: 8
Registered: ‎09-20-2017

Re: Google My Business Reviews API

We are still waiting to hear back from google regarding our API key. They have not responded to the request that went in over a month ago. I would like to use Power BI to pull google reviews in for all of our locations but I feel like our hands are tied by google and they are not responsive. Has anyone else had success using Power BI to pull google reviews?

Regular Visitor
Posts: 42
Registered: ‎05-17-2018

Re: Google My Business Reviews API

I would like to do the same with Power BI and Google Reviews. 

 

I got my API credentials and key. I even tried playing around with the API with the OAuth Playground, and it seems to work... I'm just stuck on connecting to Power BI.

Frequent Visitor
Posts: 8
Registered: ‎09-20-2017

Re: Google My Business Reviews API

What connectors have you tried? I believe the Oauth connector should work and then a function can be written in M to extract all of the reviews. I've seen Curbal write a function for a google data set here:

https://www.youtube.com/watch?v=87UsaOYD-ZM

 

Regular Visitor
Posts: 42
Registered: ‎05-17-2018

Re: Google My Business Reviews API

I haven't tried using any connectors other than Web and Odata feed. I never used an Oauth connector before, so I'm not too sure how to go about it? Do you have any reosurces that can explain how to go about that?

Highlighted
Frequent Visitor
Posts: 8
Registered: ‎09-20-2017

Re: Google My Business Reviews API

Unfortunately I do not. Sorry