Auto-Fetch Instagram Metrics

Замовник: AI | Опубліковано: 09.01.2026

I keep a simple worksheet—one column is reserved for Instagram post or Reel links. The moment I drop a link into that first column I want the second column to show the real-time like count and the third to show the view count. The numbers can appear as plain text; no JSON, no CSV, just the raw figures in the cells. Key points you should know • Update trigger: only when a new URL is pasted or an existing one is edited. No recurring cron jobs needed. • Invalid URLs: if the link is broken or not an Instagram post/Reel, the cell should immediately display a clear error message so I spot issues at a glance. • Environment: I am flexible—Google Sheets (Apps Script), Excel with VBA, or a lightweight Python script that writes back into the sheet through an add-in or API would all work. Use the method you are most confident will stay stable with Instagram’s current endpoints. • Rate limits & log-ins: please handle any authentication or token requirements internally so I only need to paste the link and see the numbers. Deliverables 1. A working sheet or small utility script wired to the sheet that populates likes in column B and views in column C on demand. 2. Clear setup instructions so I can reinstall or transfer it to another machine if needed. 3. A short note describing any tokens, libraries, or endpoints used, so future maintenance is straightforward. Once you hand it over I’ll test by pasting a few links and checking that likes/views appear instantly and that bad links return the specified error message.