How to export data automatically on local PC?

You can create a R command step, which will export the data as CSV every time you run the step.

Here is the how-to note.

Exploratory checks if the underlying data has been changed. If a change was not detected then the step doesn’t run even when you click on the step. If the underlying data (data source, data wrangling steps) was changed then it will run the step (export the data) by clicking on the step.

If you want to force running the step you can always click on the Run (play icon) button to execute the step.