Export CSV from Google Sheet

Open the sheet document in Google Drive.

File > Public to the web ... > Link tab

There are 2 dropdowns:
select the sheet
select .csv

Copy paste the generated URL in a browser. Sample URL:

https://docs.google.com/spreadsheets/d/[some key]/pub?gid=[some id]&single=true&output=csv