yes, this is generally done using the Reporting plugin and/or Watcher, which are x-pack features.
You could write your own script that hits Elasticsearch with that query and creates a csv from the result.
To see what ES-query Kibana is using in Discover for a Saved Search, open the Inspect-tab from the menu on the top.