How to create a custom template for a custom post types category

I’m working on a custom post type and need to assign a new template to one of the custom post types categories.

So far i’ve tried adding a new categories.php file with the category name at the end, which is ‘automotive’. However, It didn’t seem to overwrite the default template which is set for the custom post type.

Can someone please advise me on how I can assign a new template to a custom post type category.