I have also observed this disappearing dropdown inputs for other nodes now. Not only the Sheets nodes but also Categories for example. The workaround of opening a different script that has a different type of dropdown node and then opening script I actually want still works.