Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

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

Field
Type

name

text

admin

text

account

text

role

text

pendingInvitation

boolean

account_invitations

Sync type availability: Full-refresh

Child of accounts

Field
Type

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

Field
Type

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

Field
Type

parent

text

valueType

text

displayName

text

groupDisplayName

text

repeatable

boolean

valueMetadata

json

deprecated

boolean

categories

Sync type availability: Full-refresh

Field
Type

moreHoursTypes

json

name

text

displayName

text

serviceTypes

json

customer_media

Sync type availability: Full-refresh

Child of locations

Field
Type

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

Field
Type
Cursor

metric_date

date

✓

daily_metric

text

date

json

value

text

followers_metadata

Sync type availability: Full-refresh

Child of locations

Field
Type

name

text

count

text

food_menus

Sync type availability: Full-refresh

Child of locations

Field
Type

menu_index

integer

labels

json

sourceUrl

text

sections

json

cuisines

json

local_posts

Sync type availability: Full-refresh

Child of locations

Field
Type

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

Field
Type

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

Field
Type

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

Field
Type

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

Field
Type

name

text

mediaFormat

text

locationAssociation

json

googleUrl

text

thumbnailUrl

text

createTime

timestamp

dimensions

json

insights

json

attribution

json

description

text

sourceUrl

text

dataRef

json

Sync type availability: Full-refresh

Child of locations

Field
Type

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

Field
Type

placeActionType

text

displayName

text

Sync type availability: Full-refresh

Child of accounts

Field
Type

name

text

location

json

requestAdminRightsUrl

text

reviews

Sync type availability: Full-refresh

Child of locations

Field
Type

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

Field
Type
Cursor

impression_month

date

✓

searchKeyword

text

insightsValue

json

service_list

Sync type availability: Full-refresh

Child of locations

Field
Type

service_item_index

integer

isOffered

boolean

price

json

structuredServiceItem

json

freeFormServiceItem

json

verifications

Sync type availability: Full-refresh

Child of locations

Field
Type

name

text

method

text

state

text

createTime

timestamp

announcement

text

voice_of_merchant_state

Sync type availability: Full-refresh

Child of locations

Field
Type

hasVoiceOfMerchant

boolean

hasBusinessAuthority

boolean

waitForVoiceOfMerchant

json

verify

json

resolveOwnershipConflict

json

complyWithGuidelines

json

Entity Relationships

Last updated