I had to do a similar job.

I used triggers to keep the primary key of rows that changed into a log table.

Then I had a process that processed those...