My local models interact with Sheets exclusively over the API with Python scripts I been curating for years

Given how well the API works, that we are discussing Googlers, my guess is that's how they dog food their services. Programmers don't get hired by Google for mouse skills.

The GUI is for spot checking results, final presentation.

If you're sitting there point-n-clicking everything into place perhaps consider you are doing it wrong.