Data to AI™ / Copilot/Google Merchant Center

Google Merchant Center to Microsoft Copilot integration

Let ecommerce and marketing teams ask a Copilot agent in Teams which products are blocked, mispriced or missing data in Merchant Center.

Better answers, fewer tokens.

  • Lower AI costs for the same work
  • More accurate, reliable answers
  • Read-only
  • Uses the Google Merchant Center data you already sync
  • SOC 2 Type II certified
Microsoft 365 Copilot
Connected to Dataddo

Which feed issues keep the most of our products out of Shopping right now?

Copilot Answer · Google Merchant Center

Invalid GTINs affect 412 of 5,020 products (8.2%), more than price mismatches and small images combined (283).

IssueItem Level Issue Attribute NameProductsShare of catalog
Invalid GTIN Product statuses gtin4128.2%
Price mismatch Product statuses price1863.7%
Image too small Product statuses image_link971.9%

Counted from the latest Product statuses run, which pulls every current product; the dataset has no date range.

source
Google Merchant Center · as of Mon 06:40 UTC
covers
Catalog on 28 Sep 2026
Example answer · fictional account and figures
Google Merchant Center in Copilot

Questions Copilot can answer from your Google Merchant Center data

Google Merchant Center holds the product listings that appear on Google Shopping. Dataddo extracts two datasets: Products, with feed attributes such as price and availability, and Product statuses, with approval status and item-level issues.

Brand feed health in Teams

Ask Copilot

@Feed Health How many products per Brand have at least one item-level issue right now? Show the five worst brands.

Category managers mention the agent in their Teams channel, see which brands carry the most issues and assign fixes to the right supplier contact in the same conversation.

Sale prices that are not discounts

Ask Copilot

@Feed Health List offers where Sale Price is equal to or higher than Price, with Offer ID, Title and Price Currency.

In Microsoft 365 Copilot, the pricing team gets a list of sale prices that do not discount anything and corrects them before the next feed upload.

Feed validation rules in VS Code

Ask Copilot

Use the dataddo tools to describe the Products entity and update our feed validation rules for Price, Availability and GTIN.

A developer uses GitHub Copilot in Agent mode to align in-house validation with the attributes that Merchant Center names in Item Level Issue Attribute Name.

Google Merchant Center datasets and the questions they answer in Copilot →
Pricing

Priced per seat.

Data to AI™ is priced per seat, like the AI assistants your team already uses, with ~25% off on annual billing. Need tailored contracts or volume pricing? Talk to us about Enterprise.

Data to AITM

Serve governed business data to Claude, ChatGPT and other AI tools over MCP.

$10.49/month

per seat

3 seats minimum

Enterprise

Flexibly deploy Dataddo in any cloud or hybrid environment.

Custom

We have a payment model that works for you

See all plans and features →
Setup

Connect Google Merchant Center to Copilot step by step

  1. 1
    Connect Copilot to Dataddo Add Dataddo as an MCP tool to a Copilot Studio agent and sign in, or add it to mcp.json for GitHub Copilot in VS Code.
  2. 2
    Connect Google Merchant Center to Dataddo Sign in with your Google Merchant Center account in Dataddo and choose the datasets to sync, such as Product statuses and Product statuses: item-level issues.
  3. 3
    Choose what Copilot can see Select the Google Merchant Center data Copilot may query. Access is read-only, and data you don't select stays out of reach.
Copilot setup guide →
With vs. without

Google Merchant Center in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Feed status for the whole team One person owns the Merchant Center login and forwards screenshots of diagnostics to whoever asks. A Copilot Studio agent in Teams answers any category manager from the same Product statuses data. Everyone sees the same issues
Routing questions to the data Copilot answers feed questions from general knowledge, because it cannot see your catalog. The server description in Copilot Studio tells the agent to call Dataddo for products, prices, availability and item-level issues. Answers from your feed
Validation code in VS Code Developers copy attribute names from documentation pages and hope they match what the feed actually contains. GitHub Copilot reads field names from Dataddo through .vscode/mcp.json, once an org admin on Business or Enterprise enables the MCP servers in Copilot policy. Rules match the feed
Token consumption Copilot spends tokens exploring raw Google Merchant Center columns, sampling rows and retrying until it understands the data. Field definitions and relations are supplied up front, so the model skips the exploration and goes straight to the answer. Fewer tokens per answer
Answer quality Prone to wrong joins, invented fields and numbers that are hard to check. Answers built on agreed definitions. In the Dataddo benchmark, Opus 5.5 reached 95.2% good outcomes, against 81% over raw SQL. Better answers
Datasets

Google Merchant Center datasets and the questions they answer in Copilot

The Google Merchant Center datasets marketing teams use most, with their real field names. Copilot queries them by name through the Dataddo semantic layer.

Dataset Metrics and attributes Ask Copilot
Product statuses
  • Last Update Date
  • Product ID
  • Title
  • Destination
  • Status
  • + others
Which products have a Last Update Date older than a month?
Product statuses: item-level issues
  • Item Level Issue Attribute Name
  • Item Level Issue Code
  • Item Level Issue Servability
  • Item Level Issue Description
  • + others
Is the number of issues per Item Level Issue Attribute Name rising compared with last week?
Products: catalog
  • Item Group ID
  • Offer ID
  • Title
  • Brand
  • Google Product Category
  • + others
How many variants does each Item Group ID contain in our product feed?
Products: price and availability
  • Price
  • Price Currency
  • Sale Price
  • Sale Price Effective Date
  • Availability
  • + others
How did the average Price of our products change over the last quarter?
Products: identifiers and targeting
  • Channel
  • GTIN
  • MPN
  • Target Country
  • Content Language
  • + others
How are our products split between the online and local Channel?
See all Google Merchant Center datasets, metrics and attributes on the connector page →
Benchmark

Fewer confident mistakes. No leaked personal data.

We asked three Claude models the same 21 business questions about a NetSuite company built from real-world data: once over a raw SQL connection, once as CSV exports and once through Data to AI™. Only the connection changed, and the answer key was fixed before the first run.

95.2%

good outcomes with Opus 5.5 on Data to AI™, against 81% on a raw SQL connection

58%

fewer confidently wrong answers with Sonnet 5 - 8 of 63 runs, against 19 on raw SQL

24x

cheaper per question: Haiku 5.5 on Data to AI™ (87.3%) beat Opus 5.5 on raw SQL (81%)

0 of 9

attempts disclosed a sales rep's email address, against 9 of 9 on raw SQL

Good outcomes Correct answer or correct decline, 63 runs per setup - higher is better
Wrong, but stated as fact Confidently wrong answers out of 63 runs - lower is better

21 questions, 3 runs each. 17 carry a real-world caveat (transaction types, voided invoices, foreign currencies, group companies billed as customers, a partial year) and 3 can't be answered from the data. Ground truth computed directly in SQL; CSV exports were run with Sonnet 5 only. Run date: 26 October 2026.

Read the benchmark →
FAQ

Google Merchant Center and Copilot: FAQ

How do I connect Google Merchant Center to Copilot?

Create Dataddo sources for Products and Product statuses from Google Merchant Center and attach them to a Copilot destination or AI Model. In Copilot Studio, add a Model Context Protocol tool with https://headless.dataddo.com/mcp-data, select OAuth 2.0 with Dynamic discovery, sign in and publish to Teams and Microsoft Copilot.

Where can my team use the Merchant Center agent?

In Microsoft 365 Copilot and in Teams, after you publish the Copilot Studio agent through Channels > Teams and Microsoft Copilot. Users type @ and select the agent.

How do I make the agent call Dataddo only for product questions?

Write the server description in Copilot Studio around Merchant Center products, prices, availability and item-level issues. The agent uses that description to decide when to call Dataddo.

Can developers query the same feed data from VS Code?

Yes, with GitHub Copilot. Add the server to .vscode/mcp.json, start it and sign in, then use Agent mode. Business and Enterprise orgs need the MCP servers in Copilot policy enabled.

Does the agent show feed changes over time?

Each run pulls the full current catalog without a date range, so the agent answers about the catalog as of the last run, not a history of changes.

Can the Copilot agent edit products in Merchant Center?

No. It only reads the extracted Products and Product statuses data. Feed updates happen in Merchant Center or in your feed tooling.

New from Dataddo · Data to AI™

Ask Claude or ChatGPT about your ads, analytics and CRM

“What did a new lead cost us last week, by paid channel?”

Connect 400+ sources once and get the answer right in your AI chat, without building a report. Better answers: your metrics are defined once, so the AI doesn't have to guess.