Yes. I created a scheduled workflow for something we have sitting in a SharePoint list. If the list is updated, it finds the item that was edited and updates the information. If a new item is created in the list, it adds a new record to the table. 

Where is your source data coming from?

I should point out that our data is synced to oracle on-premise using a power shell script to update the list every night. 

The source data is a Excel or CSV list that gets updated once a week.
 

I think I see where you are coming from. The scheduled workflow looks for changes and then does an add or change row action.

Maybe I was overthinking it.

With that idea, I can see using a component workflow to do on demand changes.

Good deal. Yeah I’m not sure how you would work in a live excel or CSV file. We don’t connect to files like that, we primarily stay in the lane of a SharePoint list. But good luck! :)