Drop an Export Dataset action in the automation designer (no Execute script action is needed for this). Double-click it and the query (without the ending semicolon) on the dataset tab. Then you can go back to the options tab to set up the export format.
Then you can rt-click the action to run it or schedule it.
If your scripts consist of multiple select statements, then you’ll have to repeat this process for each select statement. So, just one statement per Export Dataset action.