Google Sheet Script Needed

I need a google sheet script that checks whenever a new row is added to the sheet and replaces the value of a cell based on the value that exists in another sheet.

DM for more details if you are able to work on this now.