Documentation updates

[drewatk]

We need to update documentation to make this a bit better on beginners

• How to query for data, and what fields are available: How do I query from the plugin? #21 How to query from Google Sheet #13
• Limitations of the google sheets api: Import stops after a single blank/empty row even if additional rows exist. #20 "The gatsby-source-google-sheets plugin has generated no Gatsby nodes" when sheet has a single row #17

[drewatk]

Also add new "type guessing" logic from #19

[krerkkiat]

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

[Waschnick]

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?

[krerkkiat]

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

[stewest]

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

[doublejosh]

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

[stewest]

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.

[doublejosh]

@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",

[stewest]

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!