I use MacroDroid although others have indicated BuzzKill will also accomplish this. [Edit Update: I have been informed that Tasker has similar functionality as well.]
Posted about it in several places:
Different Notification Sound for Each Individual Wyze Device & Type of Motion Alert
Different Alert Sound for Wyze Notifications - Post #1
Different Alert Sound for Wyze Notifications - Post #2
Other Macrodroid macros are discussed here: