Easily done with the python_script integration.
church_bells.py
service_data = {'entity_id':'media_player.alex_s_echo_dot', 'media_content_type':'sound', 'media_content_id':'amzn_sfx_church_bell_1x_02'}
for i in range(10):
hass.services.call('media_player', 'play_media', service_data, False)
time.sleep(2)
Adjust sleep(2) to the number of seconds needed to allow for the playing of the media content.
Automation simply becomes this:
- alias: 'The house was flooded with water notification'
trigger:
platform: state
entity_id:
- binary_sensor.storage_water_sensor
from: 'off'
to: 'on'
action:
service: python_script.church_bells