Text message help

Hi all,
Happy Thanksgiving to those in the US.
regarding Google text messages/notification.
I want a sound attached to text message. Sound simple. But, I only want to receive text message notifications and nothing else. Also i want to set a different sound for each notification. Ie: email vs text message.
I used to be able to do this function and I need to do it again.
I have the google Pixel 4XL.

First, I highly recommend Textra (paid) to replace the built in SMS app. And I just saw on their site they recommended Zedge for sounds. I’ve never used it, but it might be worth a look.