This Instagram insights export template gives your team a simple historical record without building a full analytics product. It pulls account insights on a schedule and appends timestamped rows to the spreadsheet you already use.
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.