SQL Email Trigger Configuration

I need help configuring an email trigger based on an SQL event using SMTP. Our IT Services has set up email service using SMTP2GO and has sent successful test emails. I know how to write queries (I typically run queries in Excel using database connection). I don't know how to set up a trigger. I'd like a learn how to do this in addition to just having it done.

Requirements:
- The email should be triggered on an "insert" action.
- Email content must include:
- Updated data details
- Timestamp of update
- User who made the update

Ideal Skills and Experience:
- Proficiency in SQL
- Experience with SMTP and email configuration
- Knowledge of working with database triggers and sending emails on database events