I didn't even Notebooks existed in ArcGIS Online and could be set as tasks. This is awesome and opens so many doors. I maintain a lot of scripts, tools, and services but run/maintain them all locally (which gives more control and whatnot, but this is great for simple things). The first thing that comes to mind is reporting (stats, dashboard, etc) and of course exactly what you did, generating spreadsheets from AGOL data. Thanks and you gained a sub!
I've used it a little to help get a foothold in Arcade, just to keep me in the right direction. Of course, you've got to have enough of a knowledge to know when or when not to trust what it's telling you.