@Harry N Nomikos For this issue, it is better to use Power Automate to achieve it. However, considering you are limited to use Script Editor or Power Automate, you can check if you can use SharePoint 2013 workflow in your tenant. If yes, you can consider using SharePoint 2013 workflow to do that.
The following steps for your reference:
- Open your site using SharePoint Designer 2013 and create a SharePoint 2013 workflow for your list
- Design your workflow like the following:
- Set the workflow automatically start when an item is created.
Note: please remember to change your email content as your needs. - Publish the workflow.
Please have a try and let's know the result.
-------------------------------
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.