Make sure:

1. The Google Sheet is set to "Anyone with the link can view"

2. Go to File → Share → Publish to web

3. Select the "Live" sheet and CSV format

4. Click "Publish"