How to Connect Instagram Public Data to Microsoft Copilot (No Code)

If you run social or competitive research, you already know the pain of pulling public Instagram data by hand. The native views are slow, they only show one profile at a time, and there is no simple way to line up a competitor against a benchmark and just read the answer.

So the data ends up scattered. Screenshots in one folder, a spreadsheet of follower counts somewhere else, a CSV export you downloaded last month and never opened again. Every time a stakeholder asks “how are these three creators doing compared to us,” it turns into an afternoon of copy and paste.

What you actually want is to ask a question in plain English and get a real answer back, using live public profile data instead of stale exports. The fix is connecting Instagram Public Data to Microsoft Copilot with Windsor.ai.

Ready to try it? Start for free with Windsor.ai. Free forever plan, no credit card.

Before you start

You will need three things in place before you connect anything:

• An Instagram Public Data source with real numbers behind it. This connector reads public business or creator profile data, so you can point it at your own public profile or at competitors and influencers you want to benchmark. No login to the analyzed account is needed.
• A Windsor.ai account. It is free forever and no credit card is required to get started.
• Access to Microsoft Copilot Studio, where you will add Windsor as a tool for your agent.

Connect Instagram Public Data to Copilot with Windsor.ai

The whole flow takes a few minutes and does not require writing any code.

1. Connect the data source in Windsor.ai. Go to https://onboard.windsor.ai/app/instagram_public, sign in, and authorize Instagram Public Data. Pick the account or accounts you want to analyze, then click Next.
2. Add Windsor MCP as a tool in Copilot Studio. In Microsoft Copilot Studio, create a new agent. Click + Add tool, then + New tool, then Model Context Protocol. Fill in the details: Server Name is Windsor MCP, Server URL is https://mcp.windsor.ai, Authentication is API Key, and Header name is Authorization. Click Create, then Add and configure.
3. Create a new connection. Under “Not connected,” choose Create new connection and enter your Windsor API key with the Bearer prefix, for example: Bearer YOUR_WINDSOR_API_KEY.
4. Start querying. Open a new chat. Copilot will ask you to connect to Windsor MCP through the Connections manager. Click Connect, then Submit. Return to the chat, click Retry, and ask about your data.

That is it. From here Copilot reads your Instagram Public Data through Windsor.ai and answers your questions. This is reporting and analysis only, so nothing is ever changed or posted on Instagram.

The Instagram Public Data metrics that matter

When you ask Copilot about a public profile, these are the real fields it can pull and reason over. Naming them in your prompts gives you sharper answers.

Metric	What it tells you
Likes per post	Average likes a profile earns per post, the cleanest way to compare engagement across accounts of different sizes.
Comments per post	Average comments per post, a signal of how much conversation the content actually drives.
Media Like Count	Total likes on a specific post, so you can spot the individual pieces of content that broke out.
Comments count	Total comments on a specific post, useful for finding the content that sparked real discussion.
Profile followers count	Audience size of the profile, the baseline for any benchmark comparison.
Profile follows count	How many accounts the profile follows, a quick read on whether it behaves like a brand or a community account.
Profile media/posts count	How many posts the profile has published, which lets you gauge posting cadence and output over time.

You can also slice these by dimensions like Instagram profile, Media caption, Media type, Media product type, Media permalink, and Date, so Copilot can group results the way a human analyst would.

What to ask Copilot: prompt ideas

Copy any of these straight into a Copilot chat once the connection is live.

Compare the last 30 days of these three public Instagram profiles by average likes and comments per post, and tell me which posts performed best.

For [profile], look at the last 30 days and break down likes per post and comments per post by media type and media product type. Which format gets the most engagement?

Compare profile followers count and posts count for these competitor profiles, then rank them by average likes per post over the last 90 days and flag any account that is punching above its follower size.

Bonus: analyze Instagram Public Data alongside your full stack

Because Windsor.ai brings many sources into one place, Copilot can read Instagram Public Data next to the rest of your marketing data for blended reporting. Everything below is read-only, so it pulls numbers together for analysis without touching any platform.

• Owned versus benchmark. Blend competitor public profile engagement with your own Instagram organic and Facebook organic numbers to see exactly where your content sits against the field, all in one cross-channel report.
• Content themes versus spend. Line up the public profiles you benchmark against your Google Ads and Meta Ads data so you can see whether the themes competitors lean into match where your budget and ROAS are going.
• Interest signals versus site traffic. Combine public posting cadence and engagement trends with your GA4 traffic to check whether competitor activity lines up with shifts in category interest, giving you a single source of truth for the read.

Conclusion

Connecting Instagram Public Data to Microsoft Copilot with Windsor.ai turns slow, siloed public research into a plain-language conversation. You ask, Copilot reads the live profile data, and you get an answer, with the option to blend in the rest of your stack whenever you need the bigger picture.

Start for free at onboard.windsor.ai. Free forever plan, no credit card.