Quite a few community members have done this, usually to alert when a pet bowl or a Christmas tree reserve have gone dry.
However, to be honest, it’s usually better to choose a sensor that can be configured to report when dry because otherwise you tend to run the battery down really fast on a typical leak sensor.
You can see the projects that other community members have done by looking on the quick browse lists in the community – created wiki. Look down near the bottom of the page for the project reports section, and in this case I would just look on the “holidays“ list and you should find several.
Or you can just go straight to this thread (this is a clickable link)