So I got a Siri shortcut put together that will get all the files in the Pages folder, and will export them as Word documents into another folder. And it will replace duplicate files, so you don’t have to worry about it creating multiple duplicates of the same files. I attached the iCloud link for it. My Apple Pages folder is in iCloud, and the “Pages to Word” folder I created in “On My iPad”. You can edit these folder destinations if you like as well. I believe you should be able to replicate this for Numbers by duplicating the Shortcut in the Shortcuts app and renaming the duplicate “Numbers to Excel” and replacing the Pages “Export Document in Background” action with Numbers version, but I haven’t tried that. I also believe you should be able to pair this with an automation that will run this shortcut whenever a new file is saved into the Pages folder, so you may not even have to manually trigger it. Actually, just looked it up, and looks like you’d have to do it on a scheduled interval, there’s no automation triggers for saving files in a folder. But you can set up an automation that will automatically run this shortcut at different times of the day. I hope that helps you out! 🙂👍🏻
I made the Numbers to Excel version as well! 👍🏻