How to set conversation response to just "ding" sound in automation?

HA has the nice ding sound when you use sentence local command like “Turn on the lights” and the lights are in the same room as the voice assistant. I would very much like to trigger this as a conversation response from my automation. Is this possible?

I have checked Method of disabling conversation response in an automation - #7 by mchk and Completely disable conversation response from custom sentence automation? - #4 by adynis

But this is a bit different. I dont want “no response” basically I want a “custom audio response”. It would be cool to use what already is available in HA, like the sound before announcement is broadcasted, or whatever else is bundled.

I think this would have to be added as new action “Set response audio”, but maybe I am wrong and it is somehow possible?

Thanks!

  - action: media_player.play_media
    metadata: {}
    data:
      media:
        media_content_id: media-source://media_source/local/acknowledge.mp3
        media_content_type: audio/mpeg
    target:
      device_id: "{{ trigger.device_id }}"
  - set_conversation_response: ""

the sound is here, place it in your media folder
core/homeassistant/components/assist_pipeline at dev · home-assistant/core