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


  1. Select File > 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 source and ensure you select CSV URL as the Source