Google Sheets Starter | Observable | Observable
•ojs
•ojs
•ojs
•ojs
•ojs
Comments (5)
Visnu Pitiyanuvath
Jun 23, 2021
My instinct was to use plain y for this rather than a facet?
Reply
Brett Cooper
Jul 30, 2021
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
Toph Tucker
Aug 10, 2021
Thanks Brett!! Incorporated your technique — I didn't know about it but it feels easier.
Zach Bogart
Sep 5, 2021
"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/
Toph Tucker
Sep 21, 2021
Wonderful, good catch, thanks Zach! Merged and republished.
Reply
Add comment
Subscribe to notifications
2,047
2,047
Google Sheets Starter | Observable | Observable