The avatar for @orazal
orazal
Public
Edited
Mar 21, 2023
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
user = "pango"
Insert cell
Insert cell
Insert cell
Insert cell
lastUserReply = userReplies[0]
Insert cell
lastUserNote = userNotes[0]
Insert cell
lastReply = data[data.length-1]
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
data = sheet.valueRanges[0].values
Insert cell
Insert cell
Insert cell
Insert cell
sheet = (await fetch(`https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}/values:batchGet?ranges=replies_2022&majorDimension=ROWS&key=${apiKey}`)).json()
Insert cell
viewof spreadsheetId = Inputs.text({label: "Spreadsheet ID", value:"1-CIIwIL1AXaKsbQNxRl5WWprGkYt3LDdhDVOOlXkQls"})
Insert cell
viewof apiKey = Inputs.text({label: "API key", value:"AIzaSyBRVsCc572q5mizNF6OBPFpQ0BQMG75EEE"})
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