Copy and paste automations

Hi I would like to know how to create an automation to copy a record view in one table and use it to create a new record in another table. This is time series data so I am copying todays data into a table with a history of data by date.
Would anyone be able to help?