In order to play a workshop mod, you just need to subscribe to it. That should start a small download and after that you should be able to see it when creating a room, in the workshop tab. Have you checked if it's there?

And yeah, while it's not needed, you can subscribe to mods while the game is open. They will take a few seconds before showing up in the list.