Can Spreadsheet Do Calculations of a Link? How to Extract and Compute Data from URLs? Alternatively:

Nah, it’s not wishful thinking! You can extract data from URLs in spreadsheets.

Google Sheets has IMPORTXML, but it’s hit or miss with random URLs.

Better to use a custom script (Apps Script) to fetch and parse the URL.

Or try =SPLIT(SUBSTITUTE(A1,"?","&"),"&") to break it down.

Excel folks can use TEXTBEFORE/TEXTAFTER (new functions!).