Platform
Resources
Pricing
Sign in
Get started
Brian Herbert
Workspace
Fork
Published
By
Brian Herbert
Edited
Jul 26, 2022
1 fork
Importers
1 star
Insert cell
Insert cell
data
=
await
getGoogleSheetAsArray
(
DEMO_SHEET_KEY
)
Insert cell
Insert cell
Insert cell
Inputs
.
table
(
await
getGoogleSheetAsArray
(
DEMO_SHEET_KEY
,
2138097605
)
)
Insert cell
Insert cell
async
function
getGoogleSheetAsArray
(
key
,
gid
=
0
)
{
return
getCsvAsArray
(
getSheetUrl
(
key
,
gid
)
)
}
Insert cell
async
function
getCsvAsArray
(
url
)
{
var
csvData
=
await
getSheet
(
url
)
var
arrData
=
csvStringToArray
(
csvData
)
return
arrData
}
Insert cell
Insert cell
Insert cell
function
getSheetUrl
(
key
,
gid
=
0
)
{
var
url
=
`https://docs.google.com/spreadsheet/pub?key=${
key
}&gid=${
gid
}&output=csv&cacheBust=${
Math
.
random
(
)
}`
console
.
log
(
"hit url "
+
url
)
return
url
}
Insert cell
Insert cell
Math
.
random
(
)
Insert cell
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
data
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
DEMO_SHEET_KEY
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
getGoogleSheetAsArray
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
getCsvAsArray
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
getSheet
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
getSheetUrl
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
csvStringToArray
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML