Here are some thoughts…
You might want to check out this thread:
You could use something like this automation or the custom automation:
Adding a “Creation Log” column to the board would allow you to filter by person and creation date. You could then export the filtered items to Excel.
Finally, to automate the entire process, I would recommend creating a Make/Integromat scenario.
Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: https://youtu.be/SARq3tmCIX8
Contact me directly here: Contact – The Monday Man