I would get Zapier and using fetch to send all your data to Zapier and then to any excel or google sheet you would like to use.
I use this solution in more than 5 projects now and it works like a charm.
If you want to schedule the export just make a function in a http-functions file that you hit by using some free cron service online like easycron.com or similar and then do your export in that function. Then you also get it scheduled.
Otherwise add your code in a data hook like after_insert and then your sheet will be updated just seconds after your data has been inserted into your Data Collection.