Google Spreadsheet CMS Object Array: Unable to parse range


#1

Hey there,

having a problem with accessing my spreadsheet as an ObjectArray. But I can’t figure out why cause it has the specified range A-C and also the name fits.

My spreadshet looks like this (having colum A,B,C):

my config.js (replaced the id and creadentialsFile):

cms: {
    GoogleSheetsCMS: {
      spreadsheetId: '<id>',
      access: 'private',
      credentialsFile: '<keyfile.json>',
      sheets: [{
        name: 'quotes',
        type: 'ObjectArray',
        range: 'A:C',
      }]
    }
  },

#2

I’m a moron… I didnt enter the sheetname but the file name. Sry -.-

Thread can be closed


closed #3