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"