The avatar for @mariodelgadosr
Mario Delgado
Designing and Engineering a Better Tomorrow
Public
Google Sheet Techniques
Edited
Jan 21, 2023
Fork of Using Google Sheets as a Proxy Server Workaround for Cross-Origin Resource Sharing (CORS) Restrictions
1
Google Sheet Techniques
Using Google Sheets as a Proxy Server Workaround for Cross-Origin Resource Sharing (CORS) Restrictions
Warehouse Visualization with DataVisualMicrosoft Money Sunset Edition Open Financial Exchange (OFX) file for Updating Portfolio Security Prices
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
fetch(
"https://github.com/datablist/sample-csv-files/raw/main/files/organizations/organizations-100.csv"
).then((response) => response.text())
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
googleProxyURL = "https://docs.google.com/spreadsheets/d/e/2PACX-1vQODu_Au-Ynem_QBlyWNXxzyvQF5KuS7MpNUG-11lcH-vYJgF72Ks5Z5xswuyymooiJhqVRxD_HxByI/pub?gid=0&single=true&output=csv"
Insert cell
Insert cell
Insert cell
dataFromGoogleSheet = fetch(googleProxyURL)
.then((response) => response.text())
.then((text) => d3.csvParse(text))
Insert cell
Insert cell
Plot.plot({
marks: [
Plot.barY(dataFromGoogleSheet.slice(0, 7), {
x: "Country",
y: "Number of employees",
fill: "blue"
})
]
})

Insert cell
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