Just a week or so ago, the IMPORTHTML/XML and related functions in GSheets just...stopped working. There are Reddit and Google Helpdesk threads about it so it's clearly a global issue. As far as I know, no fix has landed yet.
I had to spend a weekend writing a bunch of scripts to reimplement importing functionality so an international competition hosting more than 600 people from 28 countries wouldn't collapse on the spot. Everyone on the team, including me, was initially glad we were using GSheets as it made our work much easier - until it suddenly made it much, much harder.
Google & co are doing their best to remove themselves from a rational person's critical path. They're too big, you're too small; they're full of AI and politics, you have no recourse.