I need to do this too.

We have a ceiling light in front of our pantry. So, I used an Aqara door sensor and a Shelly 1 relay to turn the light on when the pantry door is opened and turn it off (only if it was off before the door was opened) after it had been shut. Very simple, but it brings me a lot of joy.

I also have both kitchen lights on motion sensors. I don’t think I have manually turned the kitchen lights on or off more than 10 times in the last couple of years. More helpful than I expected it to be.