Automation Email

I am trying to make an airtable automation that shows up in an email from the automation tab. i need the automation to show. i need it to show a sum of a column, but am having difficulty creating the automation via a script. i am new to scripts FYI. All help is appreciated