How can I check the size of a column to send an email?

There are cases where data larger than the defined column size is sent.
In this case, we would like to detect that such data has been sent and notify the operator.
I have tried to do this with Data Health, but there does not seem to be an option.
How can we achieve this kind of check?