Google sheets | configure script with trigger

the current situation in a Google sheets DB sheet: rows are appended with location data. we have a script to extract country information from the location data.

your task is complete when: the script is only executed when a new row is added to spreadsheet