How can I point to SSH keys in AWS Secrets Manager in the ansible inventory file?

I want to do something like this:

[my servers]
1.2.3.4 ansible_ssh_private_key_file={{ lookup('amazon.aws.aws_secret', 'sshkey') }}

I want to do this so I can set a different ssh key for each instance and have ansible just grab it out of secrets manager when it needs it.

Is this possible? Is there any way to ensure that the key is not held as plaintext and discarded when it is no longer needed?