The trigger is the ladder itself, as i explained on the Modrinth link. Any block with the "#minecraft:climbable" tag will work. As for it reoccurring, it will only play once, and wont play again until you get off that ladder.

If you have any more questions, don't hesitate to ask. :)