Documentation updates about gatsby-source-google-sheets HOT 9 OPEN

@drewatk Does anyone taking this issue yet? May I be any help?

from gatsby-source-google-sheets.

I still haven't figured out how to query data with GraphQL. I did setup everything with credentials and it builds, but how do I write the API queries?

from gatsby-source-google-sheets.

@Waschnick If you still looking into how to query, please have a look at changes in #29 (or a rendered README.md here).

from gatsby-source-google-sheets.

Hi @doublejosh yes, indeed, odd name. I think it needs to make it unique, as one could have multiple sources. Getting the name from GraphQL is the way. Good luck with your project!

from gatsby-source-google-sheets.

Also add new "type guessing" logic from #19

from gatsby-source-google-sheets.

YES! That helps a lot, thanks! https://github.com/krerkkiat/gatsby-source-google-sheets/tree/revise-documentation

from gatsby-source-google-sheets.

Can someone please document what the graphQL query is supposed to look like to use this plugin?

from gatsby-source-google-sheets.

Hi @doublejosh

Did you see https://github.com/brandonmp/gatsby-source-google-sheets/pull/29/files#diff-b335630551682c19a781afebcf4d07bf978fb1f8ac04c6bf87428ed5106870f5R50

It will depend on the shape of your data sheet, i.e. the column names.

from gatsby-source-google-sheets.

@stewest The confusing part is the table/type name, not the columns. In the example it's allGoogleSheetPublicationsRow

I was only able to discover mine by hitting the local GraphQL endpoint http://localhost:8000/___graphql

It seems to generate a name from the title of the sheet and the tab name, and makes choices about capitalization.

In my case... allGoogleSpreadsheetWwWebsiteContentVideos

spreadsheetName: "WWWebsiteContent",
typePrefix: "GoogleSpreadsheet",

from gatsby-source-google-sheets.