I try to automate a simple workflow. Its a oneliner in Terminal, nothing really special. And also tested via Terminal - it works perfect.
During this workflow R should be started via Automator (run a shell script). But it's impossible to start R via Automator (run shell script). Interesting: It is also impossible to run "psql" via automator-shell script, but "Python" works.
Whats the secret behind that? (R & psql runs perfect via normal Terminal.)