Creating a temp db for reporting

Hi,
I am trying to generate reports from Bubble and I did not find (besides CSV export in workflow, which did not work well for me) any native solution.
Hence I am trying to create a temp db with the info I need.
My question is how to go through the filtered record in one db (db1) and for each record in db1 create a record in db2 with some modifications (enhancements for reporting purposes).
Or if anyone has found an elegant reporting solution, I will consider it.
Anyone can help, please?
Many thanks
Gerard

Sounds like you need to use a backend workflow

Hi Paul,
any way guiding me through how to do an example?
Thank you