The spreadsheet must be published to the Web so Google can generate the CSV data files for you.
- Select File > Publish to the Web ...
- Select the sheet you would like to publish
Choose Comma-separated values (.csv) as the publishing format
If your spreadsheet has never been published before, press the Publish button
Copy the resulting .csv URL
In the CMS, add a new source and ensure you select CSV URL as the Source