2f:[] 2d:{"title":"Reading and writing to a Google sheet","cells":[{"id":0,"value":"md`# Reading and writing to a Google sheet\n\nAn example of how to both read from a Google Sheet and write back to it.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"md`## Reading\n\nFollowing the instructions [here](https://observablehq.com/@bryangingechen/importing-data-from-google-spreadsheets-into-a-notebook-we) we can publish our sheet to the web and then read it as tab-separated using d3.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"sheet = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data\n let sheet =[];\n const url = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vS_fQFNcSrpAwaY4EC5mMLVnqTiY9AMOsoNl9Ph0IiC8hqphTZHXFANN4BDt2rwdhJ6qGqxPnC5KCM9/pub?gid=1799576380&single=true&output=csv\";\n const spreadsheet = await d3.csv(url).then(data => data.forEach(d => sheet.push(d))); // d3.csv returns a Promise\n return sheet;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":73,"value":"md`## Writing\n\nWe can write to this sheet by setting up a google form and then finding the form action and entry details as described [here](https://stackoverflow.com/questions/39679786/html-form-data-to-google-sheets/62025104#62025104).`","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"html`\n\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":151,"value":"md`## Display\nIt may take a few minutes for items written above to appear below.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":31,"value":"sheetHeadings = Object.keys(sheet[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"display = html`\n\n ${ sheetHeadings.map( key => `` )} \n ${ sheet.map( row => `${ sheetHeadings.map( key => `` )}` )}\n

${key}
${row[key]}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}