I have the following code that load the datas from the spreadsheet properly:

Highcharts.chart('container', {
  title: {
    text: 'Highcharts data from Google Spreadsheets'
  },

  data: {
    googleAPIKey: 'API_KEY',
    googleSpreadsheetKey: 'SPREADSHEET_KEY',
    error: console.error
  }
});

I’m trying to use it with a Dashboard like that:

Dashboards.board('container', {
  title: {
    text: 'Highcharts data from Google Spreadsheets'
  },
  dataPool: {
    connectors: [
      {
        type: 'GoogleSheets',
        id: 'activity-data',
        googleAPIKey: 'API_KEY',
        googleSpreadsheetKey: 'SPREADSHEET_KEY'
      }
    ]
  },
  components: [
    {
      connector: {
        id: 'activity-data',
        columnAssignment: [
          {
            seriesId: 'Price',
            data: ['Date', 'Price']
          }
        ]
      },
      renderTo: 'dashboard-cell-0',
      type: 'Highcharts',
      sync: {
        highlight: true
      },
      chartOptions: {
        title: {
          text: 'Price'
        },
        tooltip: {
          valueDecimals: 2,
          valueSuffix: ' USD'
        },
        series: [
          {
            type: 'line',
            id: 'Price',
            name: 'Price'
          }
        ]
      }
    }
  ]
});

And now I have a 403 when fetching the datas and the following error:

dashboards.js:8 Error: Method doesn't allow unregistered callers (callers without established identity). Please use API Key or other form of API consumer identity to call this API.
    at dashboards.js:8:47989

Same API key and Spreadsheet ID in both cases.

Any idea what I’d going wrong?

Thank you!

I tried to fix the error with the documentation and using GPT, but no luck 🙁