Welcome to the Airtable community!
Scripts run from the Scripting App cannot run on a schedule. They only run when a button is pressed.
Scripts run as Scripting actions in Automations can be run automatically, but the scheduling is not exact. A script set to run on the hour every hour might run several minutes after the hour at times.
Here is a simple api for csv export if this helps. You will be able to use it in a scheduled script.
Details can be found here
It will only work with the parameters so any issues check the documentation for assistance or reach out :slightly_smiling_face:
While the above example is simple to use I really recommend using version 2 which only requires one extra step, but is a lot more secure - and the unique URL generated is a lot more usable :slightly_smiling_face: