Fetch Reviews from Google My Business with AppScript

In my new company, we have 100+ stores on Google Map, and we are aiming for collecting reviews of all stores for further analysis.

In this post, we will use Google App Script (One of my favorite language 💞) to get reviews through Google Business API with 3 steps:

1. Many many settings 🥱
2. Use OAuth2 in Google App Script
3. Fetch Data from GMB

Step 1. Many Many Settings

I was not familiar with Business Profile before joining my current company. Here is a brief introduction from Google Business Profile Overview:

Business Profile provides a fast and easy way for businesses, products, brands, artists, and organizations to manage their online presence with Google. … The Business Profile APIs are programming interfaces that allow developers to write applications to manage their Business Profile account and location data.

We can finish all the setting of Google API console and Business Profile by following 👉the official document. The only difference in my case is that, my company uses an official account for the business profile (and yes, we use that account to create a project on Google cloud console ☁), but I want to use my personal account to fetch Reviews. So I need to…