Linking external date and time to column

Is there a way to link external date and time to a column? For instance a large amount of data get added to the sheet, have it autofill the current date and time within a specific column.