Observable

Templates: Integrations

Observable’s first-party templates, collected here, are displayed on https://observablehq.com/templates

Templates

I think a document can be accessed as a csv without having todo the whole publish thing. 
https://observablehq.com/@hellonearthis/load-in-csv-data-from-googlesheets

Brett Cooper

Thanks Brett!! Incorporated your technique — I didn't know about it but it feels easier.

Toph Tucker

"getCsvUrl" doesn't seem to work for getting different sheets. The function correctly identifies the gid, but Google Sheets seems to always return the first sheet. 

Made a fork for multiple sheets (see added readme cells): https://observablehq.com/@zachbogart/google-sheets-starter

Used this as reference: https://www.highviewapps.com/blog/how-to-create-a-csv-or-excel-direct-download-link-in-google-sheets/

Zach Bogart

Wonderful, good catch, thanks Zach! Merged and republished.

Load a Google Sheet into a notebook and start visualizing it with Plot.