n8n is a good solution to do this. We have a few clients doing stuff like this. We also have used it to migrate the data.
