Published
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.
Learn more