How to do targeted mailing in Redash for example for alerts?

for example, a notification about the results of an alert needs to be sent only to whose email will be displayed as a result of the request

Redash doesn’t do targeted mailing. But you could configure an Alert to trigger another service to do it for you. Something like Zapier or n8n or perhaps one you write for yourself.