Google My Business Connector

Connect Google My Business to your data stack with Weld. Fully managed pipelines, set up in minutes, ready for your agents.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Google My BusinessYour warehouseLive

account24 columnsSynced

media22 columnsSynced

local_post_media6 columnsSynced

account_location43 columnsSyncing

local_post29 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Google My Business

Data source

Authenticating...

Ready to connect

Overview

Google My Business in your warehouse.
Ready for your agents.

Weld's Google My Business connector is fully managed: it extracts data from Google My Business, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Agent context

Google My Business data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Google My Business is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 15
fields: 191
relationships: 7

Loading diagram…

account_location

organization_info_address_address_lines

organization_info_address_administrative_area

organization_info_address_language_code

organization_info_address_locality

organization_info_address_organization

account_location

categories_primary_category_name

categories_primary_category_display_name

storefront_address_revision

account_location_primary_category_more_hour_type

localized_display_name

account_location_primary_category_service_type

service_type_id

account_location_additional_category

account_location_additional_category_more_hour_type

localized_display_name

account_location_additional_category_service_type

service_type_id

account_location_regular_hour_period

close_time_hours

pending_invitation

call_to_action_action_type

call_to_action_url

event_schedule_start_date_year

local_post_media

location_performance_daily

location_search_keywords_impressions_monthly

location_association_category

dimensions_width_pixels

reviewer_profile_photo_url

reviewer_display_name

reviewer_is_anonymous

review_reply_comment

review_reply_update_time

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Google My Business.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Google My Business context, finds the tables it needs and queries your warehouse.

Agent contextGoogle My Business tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextGoogle My Businesstables15fields191joins7

>

How many local_post_media rows do we have per account? Use our Google My Business data.

Reading the Google My Business context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.google_my_business_profile.local_post_media

raw.google_my_business_profile.account

+ 13 more Google My Business tables

●weld·get_reference_schema

⎿local_post_media · 6 columns

joins account on account_id

●weld·run_query

⎿select a.id, count(*) from {{raw.google_my_business_profile.local_post_media}} l

join {{raw.google_my_business_profile.account}} a on l.account_id = a.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Google My Business data in your warehouse

>Ask about your Google My Business dataMCP

Destinations

Load Google My Business into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Google My Business setup guide

Step-by-step instructions to configure and start syncing.

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Google My Business connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Google My Business ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "google-my-business-profile",
    "destination_schema_name": "google-my-business-profile_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

Put your Google My Business data to work.

Connect Google My Business, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors