Sam, thank you. You pointed me in the right direction and I was able to get things working. In case others have a similar need:
I used directions that @JDRoberts posted a few years back to create a virtual switch: FAQ: Creating a virtual Device
I then created an IFTTT applet that calls me if the virtual switch is turned on.
I then used Lighting Automation to create a rule that turns the virtual switch on if the door I’m monitoring is opened and the mode is Night
I added the IFTTT phone number to the list of contacts that can bypass my phone’s Do Not Disturb setting so I’ll get the call if someone opens the door when I’m asleep and my phone is on DnD.