Google Sheets Extraction Automation

I keep a master Google Sheet where every new entry records a sender, a recipient and the date of the action. I want an Apps Script (or comparable no-add-on solution) that automatically copies defined fields (such as project name, sender, recipient and the date etc —into a second spreadsheet, keeping every new row in strict chronological order.

The workflow I have in mind is straightforward:

• Each time a new row is added (or on a timed trigger if that’s more reliable), the script checks the master sheet, extracts the latest sender/recipient pair along with the date, and appends it to the log sheet.
• The log sheet must stay sorted by date even when multiple rows are added in quick succession.
• Duplicates need to be skipped cleanly so the log never shows the same interaction twice.

Once the Google Apps Script sheet is completed, your will set it up with a dashboard type of trigger setting function. A quick demo run that proves the entries land exactly where expected will complete the job.

Once completed, you will stay on to make adustments.