When is the best situation to implement test automation? When is it really worth it?

Please anyone tell me the best situation to implement test automation? When is it really worth it.