Using Word with DataDoe MCP

This guide shows how to use DataDoe MCP inside Microsoft Word through the Claude add-in, so you can draft reports and analyses powered by your Amazon data without leaving Word.

Before you start: This guide assumes you have already connected DataDoe MCP to Claude. If you haven't done that yet, see Using Claude first.

Set up the Claude add-in for Microsoft 365

Follow the steps in Claude for Microsoft 365 documentation (opens in a new tab) to install the Claude add-in and sign in with your Microsoft account.
Once the add-in is installed it will appear in the Word ribbon and you can open it from any document.

Start a conversation in Word

Open a document in Word.
Click the Claude icon in the ribbon to open the Claude side panel.
Make sure DataDoe is listed as an active connector in the Claude panel. If it is missing, re-add it following the Using Claude guide.
Type your prompt in the chat input and press Enter.

Note: In a new conversation, Claude may not immediately see the DataDoe connector. If that happens, ask Claude to refresh connectors.

Basic analysis - Sales Report

Prompt:

Use the DataDoe connector to write a sales report for the last 30 days. Group the data by day and include sales, units sold, and orders. Add a short summary with the total sales, total units sold, the best day, and the worst day.

Response:

Advanced analysis - Performance report

Prompt:

Use the DataDoe connector to write a detailed English performance report for the last 30 days. Include an executive summary, a sales performance overview, advertising performance, top products by revenue, a profitability analysis, and key insights and recommendations.