I can't speak to Google Sheets, but the Excel support for Python is currently severely lacking and poorly thought out.

People want VBA to be replaced with Python, JS, or something else widely used and respected. Typescript would be good.

That's not what's happening. They're adding in piecemeal functionality that doesn't necessarily solve any problems or fit into the ecosystem.