I like this but can you use a markdown code block (the triple ```) instead of a remote image for the sample output?

Sorry for the super late response here. Went down the road of pulling this one in and unfortunately the Google Sheets API has been removed by Google 😱

Gonna have to close this one as stale—sorry!!

@zachleat Open it again!

Sheets v4 API can be used, see here https://developers.google.com/sheets/api/guides/migration

Instead of publishing the sheet on the web, you just create a API KEY in Google Console and pass it to the URL. Like this: https://sheets.googleapis.com/v4/spreadsheets/[[your-spreadsheet-id]]/values/Sheet1?key=[your-api-key]

Just tested and got the following output:

{
  "range": "Sheet1!A1:Z1000",
  "majorDimension": "ROWS",
  "values": [
    [
      "name",
      "age"
    ],
    [
      "Fluffy",
      "2"
    ],
    [
      "Snugglepants",
      "5"
    ],
    [
      "Lord Featherbottom",
      "4"
    ],
    [
      "Pennywise",
      "9"
    ]
  ]
}

@crockwave are you still available to update this PR using the new sheets API?

The web site I created this for is going out of service. I don't have a current application for this. I examined Google Sheets API V4 and was able to successfully run a sample GET on one of my sheets, but had to use OAuth rather than the general purpose API key that I generated. That GET returned JSON data.

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get

As long as you can generate an updated JSON data file before compiling your site, you should be able to accomplish the use case of a community edited Google sheet that is the data source for an Eleventy compiled static page