search

butlerx / gatsby-source-google-spreadsheets

A source plugin for Gatsby that allows reading data from Google Sheets.
MIT License
39 stars 10 forks source link

Error: No values in the header row #15

Open 74yearoldsocialist opened 3 years ago

74yearoldsocialist commented 3 years ago

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 commented 3 years ago

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

sockdrawermoney commented 3 years ago

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

sockdrawermoney commented 3 years ago

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: