ChatGPT plugin & AI reporting

How to Connect Shopify to ChatGPT

Install the Data Bloo plugin from ChatGPT's directory, sign in once, and ask about orders, revenue, average order value and top products straight from the chat. Then line store revenue up against your ad spend for true ROAS. Read-only, and here's the 1-minute setup.

Free to start Read-only & secure 1-minute setup
ChatGPTData Bloo installed
@Data Bloo How did the store do last month, and which products drove the revenue?
query_data · Shopify ✓
Shopify overview
Last 30 days
NET SALES
€184,200
ORDERS
2,140
AOV
€86.07
Product
Orders
Revenue
Starter Bundle
612
€52,400
Refill Pack
488
€21,900
That's an €86.07 average order value with a 31% repeat customer rate. The Starter Bundle drives 28% of revenue from 29% of orders.
Ask anything…
The one thing you need

The Data Bloo plugin

Open Plugins in ChatGPT, search Data Bloo, hit Install and sign in. No private app, no Admin API token, no server URL and no API key anywhere in this setup. Everything below is just where to click.

Data Bloo Data BlooAnalyze your marketing data Install plugin

What connecting Shopify to ChatGPT actually means

You ask ChatGPT about your Shopify store and get a real answer, pulled from your actual store, in seconds. Type "@Data Bloo how did the store do last month" and it reads your numbers, draws a small dashboard in the thread and tells you which products carried it. No exports, no Analytics tabs. The connection runs through the Data Bloo plugin in ChatGPT's own directory, takes about a minute, and it's read-only.

Shopify publishes its own MCP servers, aimed at storefront search and developer workflows. They're good at what they do. What they don't do is put your store revenue next to your ad spend, which is the question every e-commerce marketer actually has. That's the job Data Bloo does, and that's what the rest of this guide covers.

Why connect Shopify to ChatGPT

Stop exporting Shopify Analytics. Start asking.

The same store you already track in your Data Studio reports, now answering questions in a chat.

Ask, get instant answers

"Which products sold best last week?" ChatGPT pulls the numbers and explains them.

A dashboard, not a wall of text

Sales, orders and AOV come back as tiles and a product table, drawn inside the thread.

True ROAS, finally

Line store revenue up against Facebook, Google and TikTok spend in one answer, not three tabs and a spreadsheet.

Diagnose a slow month

"Why did revenue dip in week three?" It looks across products, discounts and customer types and explains it.

Client-ready summaries

"Turn last month's store performance into a summary." Paste it into Slack, email or a doc.

Connect once, use everywhere

The same store you linked for Data Studio is instantly available to ChatGPT, zero duplicate setup.

Supported data sources

Shopify, plus every other connector

Already connected in Data Bloo? It's instantly available to ChatGPT, connect once, use everywhere.

Pick your route

Three ways to connect Shopify to ChatGPT

They solve different problems. Here's the honest version so you don't set up the wrong one.

For reporting

A connector like Data Bloo

One-click install from ChatGPT's directory, sign in once, ask in plain English. No private app, no Admin API token, nothing to host. Read-only, blends store revenue with your ad spend, and the same connection feeds your Data Studio reports.

✓ Free to start · ~1 minute

Shopify's own MCP servers

Shopify publishes MCP servers of its own, aimed at storefront search, the Dev Assistant and Admin API workflows. Free and official. They're built for developers and storefront agents, not for pulling revenue next to your ad spend.

→ Best for storefront and dev work

A manual export

Export orders or an analytics report from Shopify, save the file, upload it into the chat. Free, and it works once. Then you do it again next week, and it never lines up with your ad data.

✕ Breaks down past a one-off

Data Bloo vs Shopify's own MCPs vs a manual export

Data BlooShopify's MCPsManual export
Setup~1 min, one clickDeveloper-flavouredNew export each time
Reads your dataYes, liveYes, liveA snapshot
Changes your accountNo (read-only)Yes, via Admin APINo
Blends other channelsYes, 15+ connectorsNo, Shopify onlyBy hand
Draws a dashboard in chatYesText answersText answers
Feeds Data StudioYes, same connectionNoNo
PriceFree to startFreeFree
UpkeepNoneToken and scope managementRedo it each time

The bottom line: if you want an agent that works inside the store, Shopify's own MCPs do that. If you want to read and report on revenue with your ad spend in the same answer, that's Data Bloo.

The honest bit

When to use Shopify's own MCPs instead

Data Bloo isn't the right tool for everyone, and Shopify's own MCP servers are good at what they're built for: storefront search, the Dev Assistant, and Admin API workflows where you want an agent creating and changing things in the store.

Where they stop is reporting across channels. They see Shopify and nothing else, so they can't tell you whether last month's revenue justified the ad spend that produced it, or which channel actually drove the repeat customers. That comparison is the whole job for most e-commerce marketers, and it needs a connector that sees both sides.

Why Data Bloo

Read-only safety and your dashboards, in one connection

The write-capable routes make you choose: hand an AI the keys to your store, or keep exporting by hand. Data Bloo doesn't ask you to choose. It reads, it reports, and the exact same connection already powering your Data Studio dashboards now answers questions in ChatGPT.

It can't touch your store

All seven tools are read-only. ChatGPT pulls and analyzes your orders and revenue, but it can't edit a product, refund an order, change a price or touch a customer record. No safety checklist to memorize, because there's nothing to switch off.

One connection, two surfaces

The Shopify source you built for Data Studio is the same one ChatGPT reads. No second setup, no second bill, and the numbers ChatGPT quotes always match the dashboards you send clients. It's the one thing a Shopify-only server structurally can't give you.

What you need

1A Data Bloo account with your Shopify store connected. Free tier is fine.
2Access to the store in Shopify admin, with reporting permissions.
3A ChatGPT account. Web or the desktop app, the steps are identical.
That's it. No private app, no Admin API token, no server URL, no API key.
Setup · ~1 minute

How to connect Shopify to ChatGPT

Seven clicks, start to finish. It works the same on ChatGPT web and the desktop app.

1
Connect Shopify in Data Bloo

If you already use Data Bloo for your Data Studio reports, skip this, your store is ready. If not, sign up free and link your Shopify store once.

2
Open the Data Bloo listing

Jump straight to Data Bloo in the ChatGPT plugin directory. You'll see sample prompts and the list of supported sources, Shopify among them.

Open Data Bloo in ChatGPT →
3
Click Install plugin

The black Install plugin button sits at the top right of the listing, next to the Data Bloo name.

4
Sign in with Data Bloo

ChatGPT opens Data Bloo's sign-in page. Log in with your Data Bloo account (or the email you use for your connectors) and approve read access.

5
Click Try in chat

Once installed, the button flips from Install plugin to Try in chat. Click it to jump straight into a new conversation.

6
Mention @Data Bloo and ask

Try: "@Data Bloo How did the store do last month, and which products drove the revenue?"

7
Pick the store, get the analysis

If you have more than one store, ChatGPT asks which to analyze. Answer, and it returns a rendered dashboard plus a written read of what moved and why.

Confirm it works: in a fresh chat, type "@Data Bloo list all the Shopify stores I have connected." If your store comes back in the list, you're connected.

See it in action

Take the plugin for a spin

Click through the whole thing, install to a live analysis, no signup, right here in the page.

Under the hood

Seven read-only tools, why your store stays untouched

You ask in plain language, ChatGPT picks the tool. The usual path for a Shopify question: get_connector_accounts → list_fields → query_data.

Tool
What it does
get_user
Your plan, access and how many calls you have left.
list_data_sources
Every connector available to you, Shopify included.
get_connector_accounts
Your linked Shopify stores, and the IDs to query.
list_fields
The valid metrics and dimensions for Shopify.
query_data
The actual pull: metrics and dimensions over a date range.
list_accounts
Every connected account across every connector, in one call.
get_dates
Turns "last month" into the exact start and end dates to query.

Plus a built-in skill. The plugin ships with data-bloo-channel-analysis, so ChatGPT doesn't just fetch rows, it knows how an e-commerce operator reads them: which product carries the margin, which discount is eating it, and whether the ad spend paid for itself.

Read-only, always. ChatGPT can pull and analyze your store data, it can never edit a product, refund an order or change a price.

The data

What Shopify data you can pull

The same metrics you use in your reports, sliced by product, type, vendor, SKU, discount code, country and customer type.

Metrics
Total SalesGross SalesNet SalesTotal PriceTotal DiscountsTotal RefundsAverage Order ValueAverage Orders per CustomerRepeat Customer RateOrders CountTotal Line Items QuantityTotal Tax
Dimensions
Product TitleProduct TypeVendorSKUFinancial StatusFulfillment StatusPayment GatewayDiscount CodeShipping CountryNew vs Returning CustomerCreated At
Real answers

What ChatGPT actually gives you back

Three prompts and the kind of answer ChatGPT returns once Shopify is connected through Data Bloo, numbers, then a plain-language read.

"@Data Bloo Pull net sales, orders and average order value for last month."

ChatGPT: €184,200 net sales from 2,140 orders, an €86.07 average order value. Discounts came to €14,800 and refunds to €6,240. Repeat customers made up 31% of orders.

The read: AOV is holding but discounts are running at 8% of sales. That's the first place to look before spending more on acquisition.
"@Data Bloo Which products drove the most revenue?"

ChatGPT: Top three, the Starter Bundle (€52,400 from 612 orders), the Refill Pack (€21,900 from 488) and the Gift Set (€18,300 from 204). The Gift Set has the highest revenue per order at €89.70.

The read: the Bundle is the volume driver and the Gift Set is the margin one. Worth testing the Gift Set as an upsell on Bundle checkouts.
"@Data Bloo Did last month's ad spend pay for itself?"

ChatGPT: Combined ad spend across Facebook, Google and TikTok came to €44,760 against €184,200 net sales, a 4.1× blended return. Facebook returned 5.2×, Google 3.8× and TikTok 2.4×.

The read: the blended number is healthy, and TikTok is the one dragging it down. That comparison needs both sides connected, which is the point.

Example outputs shown for illustration; your figures come live from your own connected store.

Data Bloo plugin

Not just charts. Finished, branded deliverables

Plug your live Shopify data into ChatGPT, Claude or Gemini through Data Bloo, and generate branded presentations, audits and executive reports straight from a chat prompt.

Client presentations

Slide-ready decks with your logo, colors and commentary, built from live data, ready to send.

92
!

Audits

Automated account audits that flag issues, wins and opportunities, with clear next steps.

REV
€184K
ORDERS
2.1K
AOV
€86

Executive reports

Concise, narrative summaries for leadership, the numbers that matter, explained in plain language.

Try it

Shopify prompts to paste into ChatGPT

Start each one with @Data Bloo so ChatGPT reaches for your store instead of guessing.

Start here
@Data Bloo List all the Shopify stores I have connected.
@Data Bloo How did the store do last month?
@Data Bloo What fields can I query for my Shopify store?
Sales & orders
@Data Bloo Pull net sales, orders and average order value for the last 30 days.
@Data Bloo Show total discounts and refunds by week for the last quarter.
@Data Bloo Show repeat customer rate and average orders per customer.
Products & discounts
@Data Bloo Which products drove the most revenue last month?
@Data Bloo Show revenue by product type and vendor for the last 30 days.
@Data Bloo Which discount codes cost the most and what did they bring in?
True ROAS & cross-channel
@Data Bloo Did last month's ad spend pay for itself, compare spend against net sales.
@Data Bloo Compare Facebook Ads and Google Ads spend against store revenue.
@Data Bloo Write a client-ready store performance summary for last month.
Who it's for

Built for how you actually work

Same connection, different job to be done. Here's the prompt each type of marketer tends to start with.

E-commerce & DTC

See revenue, AOV and repeat rate without opening Analytics, and catch a discount quietly eating your margin.

"@Data Bloo show net sales, AOV and total discounts by week for the last quarter."

Agencies

Put store revenue next to the ad spend you manage, and report on return rather than clicks.

"@Data Bloo compare total ad spend against net sales for the last 30 days and give me the blended return."

Founders & operators

Ask the question you actually have, in the words you'd use, and get the number without a dashboard.

"@Data Bloo which products made the most money last month, and which ones lost money after refunds?"
Troubleshooting

Common issues and fixes

ChatGPT answers without using your data

Start the message with @Data Bloo. Without the mention it may answer from general knowledge instead of reaching for the plugin, and you'll get a confident, generic reply that has nothing to do with your store.

It says it can't see your stores

You're likely not signed in yet, or Shopify isn't connected in Data Bloo. Ask "@Data Bloo list the accounts I have connected." If it comes back empty, open Data Bloo, confirm your Shopify source is connected, then try again.

The numbers don't match Shopify Analytics exactly

Shopify's own reports and the API can treat refunds, taxes and shipping differently depending on the report. Ask ChatGPT which metric it used, net sales and gross sales are not the same number, and most mismatches come down to that.

Revenue looks off after refunds

Refunds are reported separately from sales, so a big refund can make a month look worse than it traded. Ask for total refunds alongside net sales to see both halves.

ChatGPT won't take an action on your store

That's on purpose. The connection is read-only, so nothing in Shopify can be changed from a chat. If you need to change something, do it in Shopify itself.

Good to know

Query notes & FAQs

@Mention the plugin. Starting with @Data Bloo is the surest way to make ChatGPT reach for your data rather than guess.
One breakdown dimension per call. For multiple breakdowns, ask ChatGPT to run separate queries and combine them after.
Net vs gross matters. Net sales, gross sales and total sales are different fields. Name the one you mean and ChatGPT will use it.
Confirm fields first. Field IDs vary per connector. ChatGPT usually lists fields before querying to avoid rejected requests.

Connect your store in Data Bloo, then open Plugins in ChatGPT, search for Data Bloo, click Install plugin and sign in. Ask your first question with @Data Bloo. About a minute end to end, with no private app and no API token.

It's free to start, no credit card. The free tier includes plugin access with usage limits; paid plans raise the limits and add more connected accounts.

No. All seven Data Bloo tools are strictly read-only. ChatGPT can pull and analyze your orders and revenue but can never edit a product, refund an order, change a price or touch a customer record.

Shopify's MCPs are built for storefront search and developer workflows inside the store. Data Bloo is built for reporting, and crucially it sees your ad spend too, so it can answer whether the revenue justified the marketing that produced it.

No. Data Bloo is a listed plugin in ChatGPT's directory, so installing is one click and a sign-in. A server URL is only needed for clients without a directory, like Claude, and that's covered on our Shopify to Claude page.

Yes, and it's the main reason to connect Shopify here. With your ad accounts connected in Data Bloo, "compare last month's ad spend against store revenue" is a single question with one answer.

Yes. Connect each store in Data Bloo and name it in your prompt. If you don't specify, ChatGPT asks which store to analyze first.

It includes aggregate customer metrics, new vs returning, repeat rate and orders per customer. It doesn't expose individual customer records for reporting.

The Data Bloo plugin ships its own interface, so results render as KPI tiles and a table inside the chat. The written analysis still appears underneath, and you can ask for a plain table any time.

Simple, transparent pricing

Scale your reporting without limits

Every plan includes all data sources. Start free, upgrade only when your dashboards demand it.

FREE
$0/ forever

Best for individuals or early-stage teams starting with marketing data.

Create free account
Destinations included
& more
1 account per connector300 daily refreshes (API calls)All data sources includedData Bloo MCP
STARTER
$8.33/mo
billed annually · save $20/yrAnnual plan only

For individuals who need unlimited refreshes with a single account.

Choose Starter
Destinations included
& more
1 account per connectorUnlimited daily refreshesAll data sources includedData Bloo MCPEmail support
Most popularPRO
$16.66$19.99/mo
billed annually · save $40/yrbilled monthly

For freelancers & growing teams that need more accounts and volume.

Choose Pro
Destinations included
& more
Up to 5 accounts per connectorUnlimited daily refreshesAll data sources includedData Bloo MCPEmail support
AGENCY
$33.33$39.99/mo
billed annually · save $80/yrbilled monthly

For agencies managing multi-client reporting at scale.

Choose Agency
Destinations included
& more
Unlimited accounts per connectorUnlimited daily refreshesAll data sources includedData Bloo MCPPriority email & chat support

No credit card required to start · Cancel anytime · See plan FAQs →

Chat with your Shopify data today

Install the Data Bloo plugin in ChatGPT in about a minute and ask your first question. Free to start, no credit card, read-only.