PowerBI using a gateway is capable of refreshing data on a set interval from a spreadsheet. However, exporting this data is currently a manual process for the end user.
Providing the ability to allow an automatic export post sync, and provide a dedicated location where the results should be sent to would allow data staging for a gateway or a desktop app.