Automatically exporting Woocommerce orders for specific products

Hello, I run a shop which receives tickets to post products, often live for 1-2 weeks. At the end of this sale period, the sales data is exported as a spreadsheet and sent to the ticket owner. The problem right now is that the sales data cannot be shared automatically with the user throughout the sale period, only at the end(and manually) through Woocommerce.

Is there any way to integrate Microsoft 365 to automatically make a shareable Excel file that updates every time an order is placed on Woocommerce? The closest thing I could find (even custom code plugins) was to export all orders automatically into an Excel with CRON scheduling. However, we want each individual product to be in its own sheet, which seems to require a CRON job for each product.

If anyone has done something like this, or used a plugin to do it, let me know! Happy to learn and try to make something myself but not sure where to start.

• This topic was modified 8 months, 2 weeks ago by oliverm0001.