Google My Business
Connect your Google My Business to your data warehouse. Sync locations, reviews, media, posts, and metrics to BigQuery, Redshift, PostgreSQL, Databricks, and more.
Using the Erathos platform
When selecting Google My Business as a new connector on the Erathos platform, you will need to name your connection and fill in the following form:
Client ID — the OAuth 2.0 client ID from your Google Cloud project, used to identify the connection
Client Secret — the secret that pairs with the Client ID for the OAuth 2.0 token exchange
Sign in with Google — authorize the Google account that manages your Business Profiles (scope
business.manage)
With this connection created you can seamlessly move your Google My Business data to your BigQuery, Redshift or PostgreSQL data warehouse.
How to find my token?
Google My Business (the Google Business Profile API) uses OAuth 2.0 instead of a static token, so the connector is authenticated with a Google Cloud Client ID and Client Secret plus a one-time authorization of your Google account.
To get them, open the Google Cloud Console and create (or select) a project: enable the Google Business Profile API family under APIs & Services → Library, configure the OAuth consent screen adding the scope https://www.googleapis.com/auth/business.manage, and create an OAuth client ID of type Web application under APIs & Services → Credentials. Copy the generated Client ID and Client Secret.
Paste the Client ID and Client Secret into the Erathos connector form, then complete the Sign in with Google step with the Google account that manages your Business Profiles. After Google redirects you back, click Save and close — Erathos stores the refresh token and renews the access token (valid for ~1 hour) automatically. Note that Google's default API quota is 0 until your Cloud project is approved for Basic API Access, with a rate limit of 300 queries/minute per API plus per-endpoint daily caps.
Endpoints and fields
account_admins
Sync type availability: Full-refresh
Child of accounts
name
text
admin
text
account
text
role
text
pendingInvitation
boolean
account_invitations
Sync type availability: Full-refresh
Child of accounts
name
text
role
text
targetType
text
targetAccount
json
targetLocation
json
accounts
Sync type availability: Full-refresh
Parent of account_admins, account_invitations, locations, recommended_google_locations
name
text
accountName
text
primaryOwner
text
type
text
role
text
verificationState
text
vettedState
text
accountNumber
text
permissionLevel
text
organizationInfo
json
attributes
Sync type availability: Full-refresh
parent
text
valueType
text
displayName
text
groupDisplayName
text
repeatable
boolean
valueMetadata
json
deprecated
boolean
categories
Sync type availability: Full-refresh
moreHoursTypes
json
name
text
displayName
text
serviceTypes
json
customer_media
Sync type availability: Full-refresh
Child of locations
name
text
mediaFormat
text
locationAssociation
json
googleUrl
text
thumbnailUrl
text
createTime
timestamp
dimensions
json
insights
json
attribution
json
description
text
sourceUrl
text
dataRef
json
daily_metrics_time_series
Sync type availability: Full and incremental refresh
Cursor: metric_date
Child of locations
metric_date
date
✓
daily_metric
text
date
json
value
text
followers_metadata
Sync type availability: Full-refresh
Child of locations
name
text
count
text
food_menus
Sync type availability: Full-refresh
Child of locations
menu_index
integer
labels
json
sourceUrl
text
sections
json
cuisines
json
local_posts
Sync type availability: Full-refresh
Child of locations
name
text
languageCode
text
summary
text
callToAction
json
createTime
timestamp
updateTime
timestamp
scheduledTime
timestamp
recurringInstanceTime
timestamp
event
json
state
text
media
json
searchUrl
text
topicType
text
alertType
text
offer
json
location_admins
Sync type availability: Full-refresh
Child of locations
account
text
admin
text
name
text
pendingInvitation
boolean
role
text
locations
Sync type availability: Full-refresh
Parent of customer_media, daily_metrics_time_series, followers_metadata, food_menus, local_posts, location_admins, lodging, media, place_action_links, reviews, searchkeyword_impressions_monthly, service_list, verifications, voice_of_merchant_state
Child of accounts
name
text
languageCode
text
storeCode
text
locationName
text
primaryPhone
text
additionalPhones
json
address
json
primaryCategory
json
additionalCategories
json
websiteUrl
text
regularHours
json
specialHours
json
serviceArea
json
locationKey
json
labels
json
adWordsLocationExtensions
json
latlng
json
openInfo
json
locationState
json
attributes
json
metadata
json
priceLists
json
profile
json
relationshipData
json
moreHours
json
lodging
Sync type availability: Full-refresh
Child of locations
name
text
metadata
json
property
json
services
json
policies
json
foodAndDrink
json
pools
json
wellness
json
activities
json
transportation
json
families
json
connectivity
json
business
json
accessibility
json
pets
json
parking
json
housekeeping
json
healthAndSafety
json
sustainability
json
commonLivingArea
json
guestUnits
json
allUnits
json
someUnits
json
media
Sync type availability: Full-refresh
Child of locations
name
text
mediaFormat
text
locationAssociation
json
googleUrl
text
thumbnailUrl
text
createTime
timestamp
dimensions
json
insights
json
attribution
json
description
text
sourceUrl
text
dataRef
json
place_action_links
Sync type availability: Full-refresh
Child of locations
createTime
timestamp
isEditable
boolean
isPreferred
boolean
name
text
placeActionType
text
providerType
text
updateTime
timestamp
uri
text
place_action_type_metadata
Sync type availability: Full-refresh
placeActionType
text
displayName
text
recommended_google_locations
Sync type availability: Full-refresh
Child of accounts
name
text
location
json
requestAdminRightsUrl
text
reviews
Sync type availability: Full-refresh
Child of locations
name
text
reviewId
text
reviewer
json
starRating
text
comment
text
createTime
timestamp
updateTime
timestamp
reviewReply
json
reviewMediaItems
json
reviewReplyUrl
text
searchkeyword_impressions_monthly
Sync type availability: Full and incremental refresh
Cursor: impression_month
Child of locations
impression_month
date
✓
searchKeyword
text
insightsValue
json
service_list
Sync type availability: Full-refresh
Child of locations
service_item_index
integer
isOffered
boolean
price
json
structuredServiceItem
json
freeFormServiceItem
json
verifications
Sync type availability: Full-refresh
Child of locations
name
text
method
text
state
text
createTime
timestamp
announcement
text
voice_of_merchant_state
Sync type availability: Full-refresh
Child of locations
hasVoiceOfMerchant
boolean
hasBusinessAuthority
boolean
waitForVoiceOfMerchant
json
verify
json
resolveOwnershipConflict
json
complyWithGuidelines
json
Entity Relationships
Last updated

