It means all of a sudden and unexpectedly. For example, someone who won the lottery may say that they had "friends and family coming out of the woodwork". This means that these people were appearing in someone's life who were no there before, or hadn't been present for a very long time.

(Salir de la nada) He came out of the woodwork and became a great star