TypeError: Cannot read property 'worksheets' of undefined about gatsby-source-google-sheets HOT 15 CLOSED

Unfortunately, this repository seems completely abandoned, and as this issue describes, it's also broken. @yeswanth and I have decided to use his working fork of the project and continue maintenance there. So, if anyone is interested, you can find it here: https://github.com/yeswanth/gatsby-source-google-sheets.

from gatsby-source-google-sheets.

Looks like @yeswanth has a working version here: https://github.com/yeswanth/gatsby-source-google-sheets.
Also looks like @advisciglio has one here: https://github.com/advisciglio/gatsby-source-google-sheets

Any chance we can create a GitHub organisation and work together on a successor of this plugin instead of building our own versions? 😄

from gatsby-source-google-sheets.

@ehannes I ended up using https://github.com/sondrele/gatsby-source-google-spreadsheet to fix the Google API issue. The repo you reference is a fork from the original that I had to make in order to bridge the Gatsby v2 to v3 issue, but I think it still has permission failures (I stopped using it altogether).

from gatsby-source-google-sheets.

@ehannes Definitely a good idea. I would love to collaborate with you on this.

from gatsby-source-google-sheets.

@ehannes I am using it with V2 but I think it should work on V3 as well.

In gatsby-source-google-sheets, the v3 incompatibility relies on the usage of boundActionCreators, which was deprecated in favor of actions (see https://www.gatsbyjs.com/docs/reference/release-notes/migrating-from-v2-to-v3/#removal-of-boundactioncreators).

gatsby-source-google-spreadsheet uses actions, for which I assume it should work with Gatsby v3.

In regards to plugin maintenance, yes, it looks less popular and equally abandoned.

from gatsby-source-google-sheets.

@advisciglio Yes, I just sent you a mail :)

from gatsby-source-google-sheets.

As per @ehannes message above I am closing this as it is apparent that this plugin is no longer functional with Google updating their API and this plugin not being maintained.

Ive decided to move the google sheets into a csv folder within the repository and use gatsby-transormer-csv as a quick solution.

For anyone wanting a google-sheets plugin see @ehannes' link above.

from gatsby-source-google-sheets.

Same issue on this side.
FYI @brandonmp @MartinNuc @drewatk @KyleAMathews @britt @j-nolan

from gatsby-source-google-sheets.

Same issue

from gatsby-source-google-sheets.

This seems to be related to #39, caused by the Google API V3 version being recently deprecated.

Provided this plugin doesn't seem to be supported anymore, I suggest replacing it with https://github.com/sondrele/gatsby-source-google-spreadsheet. I could replace it successfully in my project; there are minor implementation differences but overall it's pretty much the same.

Some differences I stumbled upon:

• The new plugin retrieves all sheets with one configuration object (as opposed to one object per sheet)
• The new plugin returns boolean values (checkboxes) as TRUE or FALSE strings
• The graphql node types have a different type (allGoogleSheetSheetnameRow vs. allGoogleSpreadsheetSheetname)

from gatsby-source-google-sheets.

@advisciglio Agree. It seems they dropped it on 2nd August, 2021 and its weird we are facing this issue since 16 August, 2021. Anyway, i have gone through the migration part and noticed the changed the URL's for API which we might need to implement here in this project. So we can use the same plugin instead of going to another plugin.
FYI @brandonmp @MartinNuc @drewatk @KyleAMathews @britt @j-nolan

from gatsby-source-google-sheets.

@rajan-magar are you working with a migration? Would be great to be able to continue using this plugin, we use it in several projects.

I also opened #46 to see if we can get in touch with the author of this plugin since it seems abandoned. Otherwise, we might need to fork it... Maybe start a community around it?

I will also take a deeper look at the suggested alternative above, though latest update there is also old: Oct 30, 2019...

from gatsby-source-google-sheets.

@yeswanth are your version of the plugin working? If so, then maybe we could continue with either:

• Create an organisation here on Github so that we co-own the project
• Or invite me and hopefully other collaborators to your repository
• Or at least open it up your repository so that one can submit issues

Would also be nice if we could release the plugin officially at npmjs.org.

Maybe you could contact me at [email protected] to discuss the details further? Thanks for wanting to share 😄

from gatsby-source-google-sheets.

@advisciglio good that you found a solution. Is that other plugin maintained? It has just 15 commits and last one was made Oct 30, 2019. Does it support Gatsby v3?

from gatsby-source-google-sheets.

@yeswanth any change we can get in contact? 😃

from gatsby-source-google-sheets.