Auto-Fetch Instagram Metrics

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.