Get Google My Business Reviews


Hello all,

I have a Google My Business account with many locations. I am trying to pull all of the reviews into a pbix doc to analyze customer verbatim and ratings of my locations. Has anyone been able to use an API key to pull in reviews from My Bussiness before? I think I would need to create a custom function in order to accomplish this for all locations but I have not been successful thus far. Any help would be greatly appreciated.

Thank you!


I’m not sure I can add much on this at the present time. Haven’t dived into APIs a significant amount. Hopefully there may be others who can assist quicker.