The spreadsheet must be published to the Web so Google can generate the CSV data files for you. 

  1. Select File > Share > Publish to the Web ...
  2. Select the sheet you would like to publish

  3. Choose Comma-separated values (.csv) as the publishing format

  4. If your spreadsheet has never been published before, press the Publish button

  5. Copy the resulting .csv URL

  6. In the CMS, add a new data source, label it so you know it's referring to your Google Sheet and select CSV URL as the Source. In the next step, paste the URL you copied from your Google Sheet web publishing step.