Google Sheets Starter | Observable | Observable
ojs
ojs
ojs
ojs
ojs
Author
Observable
@observablehq
The end-to-end solution for building and hosting better data apps, dashboards, and reports.
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
© 2026 Observable, Inc.
Terms of service
Privacy policy
Product
About
Pricing
Documentation
Release notes
Contact us
Open source
Notebook Kit
Plot
D3
Community
Explore
Forum
Bluesky
YouTube
X
2,046
Follow
Follow
Google Sheets Starter | Observable | Observable