With Sheetgo, you can connect your Google Business Profile (formerly Google My Business) account directly to Google Sheets using the Google Business Profile API. This allows you to automatically retrieve business location data, customer reviews, ratings, and listing performance metrics into a structured spreadsheet. Instead of manually exporting reviews and insights from your Business Profile dashboard, Sheetgo automates the retrieval process using secure OAuth 2.0 authentication and scheduled refreshes. This ensures your marketing and operations teams always have up-to-date customer feedback and performance data inside Google Sheets.
Prerequisites
A Google Business Profile account
A Google Cloud Project
Google Cloud Console: https://console.cloud.google.com/
Google Business Profile API documentation: https://developers.google.com/my-business/
Google OAuth 2.0 documentation: https://developers.google.com/identity/protocols/oauth2
Enabled Business Profile API in your Google Cloud project
OAuth 2.0 Client ID and Client Secret
A Refresh Token generated via OAuth consent flow
Your Google Business Profile Account ID and Location ID
A Sheetgo account using the same Google account connected to Google Business Profile
Step 1: Identify the Required API Endpoint
Google Business Profile provides multiple endpoints depending on the type of data you want to retrieve, such as locations, reviews, or performance insights. All requests are made to the base URL https://mybusiness.googleapis.com/v4/. For example, to retrieve reviews for a specific location, use https://mybusiness.googleapis.com/v4/accounts/ACCOUNT_ID/locations/LOCATION_ID/reviews. To retrieve locations, use https://mybusiness.googleapis.com/v4/accounts/ACCOUNT_ID/locations. Replace ACCOUNT_ID and LOCATION_ID with your actual identifiers. Refer to the documentation linked in the Prerequisites to determine which endpoint matches your reporting needs.
Step 2: Generate API Credentials
Google Business Profile uses OAuth 2.0 authentication. Log in to Google Cloud Console and enable the Business Profile API for your project. Navigate to APIs & Services → Credentials and create an OAuth 2.0 Client ID. Configure the OAuth consent screen if required. After generating your Client ID and Client Secret, complete the OAuth authorization flow described in the documentation linked in the Prerequisites to generate an Access Token and Refresh Token. Access tokens expire approximately every hour, so the Refresh Token is required to maintain long-term automation within Sheetgo.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Log in to Sheetgo and create a new workflow. Select HTTP Request as your source and choose the GET method. Paste your full GET request URL into the Request URL field, such as https://mybusiness.googleapis.com/v4/accounts/123456789/locations/987654321/reviews. Then open the Headers section and insert the following JSON configuration:
{
"Authorization": "Bearer YOUR_ACCESS_TOKEN",
"Content-Type": "application/json",
"@auth": {
"auth_method": "oauth2",
"auth_type": "Bearer",
"refresh_url": "https://oauth2.googleapis.com/token",
"refresh_params": {
"client_id": "YOUR_CLIENT_ID",
"client_secret": "YOUR_CLIENT_SECRET",
"refresh_token": "YOUR_REFRESH_TOKEN",
"grant_type": "refresh_token"
}
},
"@pagination": {
"type": "page",
"page_param": "pageToken",
"per_page_param": "pageSize"
}
}Replace all placeholder values with your actual credentials. If the API response nests data under a reviews key, you may define a data root using the @flags parameter with data_root set to reviews.
Step 5: Choose the Destination Spreadsheet
After configuring the API request, click Next in Sheetgo. Choose Google Sheets as your destination. You may select an existing spreadsheet or create a new one. Sheetgo will automatically structure the JSON response into columns such as reviewer name, rating, comment, review date, and response status. If necessary, add a Filter by Condition processor before selecting the destination to refine your dataset. Confirm the sheet tab where the Business Profile data will be stored.
Step 6: Execute the Sheetgo Connection
Click Finish and Save to activate the workflow. Run the connection to test the integration. Sheetgo will retrieve your Google Business Profile data and populate your Google Sheet. Configure scheduled refreshes to keep your reviews and listing data updated automatically. Since OAuth refresh tokens are included in the header configuration, Sheetgo will automatically request new access tokens when required, ensuring continuous synchronization with Google Sheets.