IG Insight Pilot

Create or enter your local dashboard password.

This protects the browser only. Your Google Sheet and Apps Script token protect the data.
Command centre

Setup Wizard

Welcome

Set up Instagram insight with one backend file.

The client owns the Google Sheet. The AI proxy runs in the background and protects your Gemini key.

No Instagram password. No direct Instagram API. No Gemini key for the user.
Step 1

Create a blank Google Sheet.

Open Google Sheets and create a blank Sheet for this workspace.

Example name: IG Insight POC - Client Name
Step 2

Copy the backend code.

In the Google Sheet, go to Extensions → Apps Script. Delete starter code, paste this full backend, then save.

Step 3

Run setupAll().

In Apps Script, select setupAll, click Run, and approve permissions.

setupAll creates all tabs, sets the token, prepares AI enrichment and writes config automatically.
Step 4

Deploy as Web App.

Deploy → New deployment → Web app.

1Execute as: Me
2Who has access: Anyone with the link
3Click Deploy
4Copy the Web App URL
Step 5

Connect this dashboard.

Step 6

Upload Instagram ZIP.

The ZIP is read locally in the browser. Only cleaned rows go into the client Google Sheet.

Drop Instagram ZIP hereor click to choose file
Step 7

Import, analyse, rebuild.

1. Import rows

Sends cleaned Instagram messages into the private Google Sheet.

2. Run AI intelligence

Runs hidden AI enrichment through the secure proxy.

3. Rebuild dashboard

Refreshes leads, gaps and AI intelligence.

Finish

Ready to review.

Open the dashboard and review opportunities, gaps and AI intelligence.

Engagement health

Real opportunities filtered from raw Instagram noise.

Import data to begin.

—response rate
—Conversations
—Messages
—Real gaps
—Replied
—Hot leads
—Action queue

Activity timeline

Response breakdown

Priority opportunities

Top lead signals

Raw View

AI Intelligence

Lead Queue

Real Gaps

Import & Health