This Instagram insights export template gives your team a simple historical record without building a full analytics product. It pulls Instagram account insights on a schedule and appends timestamped rows to the spreadsheet you already use.
How to export Instagram insights
There are three practical ways to get Instagram insights into a spreadsheet:
- Copy the numbers by hand. Instagram shows insights in the app for recent periods. That works for one account, once.
- Use a reporting tool that already stores Instagram history and offers a CSV export.
- Pull insights through an API on a schedule and write them to your own sheet. This template is that route. InvisibleAPI reads insights live and stores nothing, so the rows you append become your history.
What you build
You get a scheduled exporter that writes one row per connected Instagram professional account. Each row includes the run date and the insight values your team chooses, while earlier rows remain untouched for later analysis.
How it works
- Resolve the connected Instagram professional accounts.
- Read overview, trends, breakdowns, and audience insights through the MCP insights tool.
- Add one timestamped row per account to the spreadsheet.
- Leave previous rows unchanged so the sheet becomes the history.
- Mark accounts that need reconnect and continue exporting the accounts that are ready.
Before you paste the prompt
- Choose the spreadsheet and columns your team needs.
- Connect the Instagram accounts and confirm their insights scopes.
- Decide the schedule and timezone for the export.
Start from this template
Paste the prompt into Claude, connect the InvisibleAPI MCP server, and connect your spreadsheet provider. The spreadsheet becomes your historical store because InvisibleAPI returns current insights rather than a long-term archive. For charts instead of rows, build an Instagram analytics dashboard. For a summary per client, use the Instagram report template.
