Error: No values in the header row

[74yearoldsocialist]

I receive the following error despite there being values in row 1 of my spreadsheet. Every column that has any used cells has a header.

ERROR #11321  PLUGIN

"gatsby-source-google-spreadsheets" threw an error while running the sourceNodes
lifecycle:

No values in the header row - fill the first row with header values before trying
to interact with rows

  Error: No values in the header row - fill the first row with header values before
   trying to interact with rows
  
  - GoogleSpreadsheetWorksheet.js:292 GoogleSpreadsheetWorksheet.loadHeaderRow
    [shop-by-shape]/[google-spreadsheet]/lib/GoogleSpreadsheetWorksheet.js:292:13
  
  - task_queues.js:95 processTicksAndRejections
    internal/process/task_queues.js:95:5
  
  - GoogleSpreadsheetWorksheet.js:424 GoogleSpreadsheetWorksheet.getRows
    [shop-by-shape]/[google-spreadsheet]/lib/GoogleSpreadsheetWorksheet.js:424:29

warn The gatsby-source-google-spreadsheets plugin has generated no Gatsby nodes. Do
 you need it?

[butlerx]

Can you please post a link to the sheet if possible or a duplicate without any sensitive data for testing

[adamavenir]

Getting the same issue. The url for the data is https://docs.google.com/spreadsheets/d/1Jl79Ko7-RAA-4nZ2Zypn_FPqZIEAVRnBbVJt9COxYbA/edit?usp=sharing

[adamavenir]

Slightly different error, actually -- but same error summary.

  - task_queues.js:93 processTicksAndRejections
    internal/process/task_queues.js:93:5
  
  - From previous event:
  
  - From previous event:
  
  - api-runner-node.js:553 
    [tricitiesvote.com]/[gatsby]/src/utils/api-runner-node.js:553:14
  
  - timers.js:461 processImmediate
    internal/timers.js:461:21
  
  - From previous event:
  
  - api-runner-node.js:526 
    [tricitiesvote.com]/[gatsby]/src/utils/api-runner-node.js:526:13
  
  - From previous event:
 
  - interpreter.js:131 
    [tricitiesvote.com]/[xstate]/lib/interpreter.js:131:23

Things I've tried:

• removing all blank columns
• ensuring all headers are titled with dashes instead of spaces or camelCase
• speaking softly in a gentle voice