2c:null 2d:["$","title",null,{"children":"Google Sheets Live Embed | Alok Pepakayala | Observable"}] 32:[] 30:{"id":"2491c01b02ed39ef","slug":"google-sheets-live-embed","title":"Google Sheets Live Embed","thumbnail":"f6acd335eaf0df415b125abdd16f75dab0ff05f066abd4c75b76db8c4cff1275","access_level":"public","create_time":"$D2021-12-26T09:29:47.687Z","update_time":"$D2021-12-26T10:41:36.314Z","view_time":null,"first_public_time":"$D2021-12-26T10:39:23.971Z","has_unpublished_edits":null,"fork":{"id":"21d1b3d3e49e8f08","slug":"google-sheets-starter","title":"Google Sheets Starter","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":1,"starred":false,"owner":{"type":"team","id":"ebdd8a722ae381e2","login":"a10k","name":"Alok Pepakayala","avatar_url":"https://avatars-next.observableusercontent.com/f28a7b5f4fb16a63caaace8a87a531e60bea383d6e9d50e126570c77c0814ba9","tier":"starter_2024"},"version":387,"publish_version":387,"role":null,"authored":false,"authors":[{"type":"individual","id":"e594cd7b50bd5352","login":"a10k","name":"Alok Pepakayala","avatar_url":"https://avatars-next.observableusercontent.com/a79accbaf1cb39d92bac556179588a03429b7ed84c64707b7ae8d86c9ffacfc7","tier":null}],"members":[{"type":"individual","id":"e594cd7b50bd5352","login":"a10k","name":"Alok Pepakayala","avatar_url":"https://avatars-next.observableusercontent.com/a79accbaf1cb39d92bac556179588a03429b7ed84c64707b7ae8d86c9ffacfc7","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Google Sheets Live Embed","cells":[{"id":371,"value":"md`# Google Sheets Live Embed`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"md`This notebooks shows a simple example for using live google sheet embed to drive your notebook, example usecase: you want to edit the data live in the notebook without having to switch tabs etc., (as you are already logged in, the embed will let you edit even though its shared with view only permission for the people with the link)\n\n_ One issue with this approach is, after you make changes, there is no automatic trigger to let the notebook runtime know, for executing the downstream cells that reference this data, so we have a button on top to refresh._`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":261,"value":"viewof doc = {\n var id = '1WpjUAJLgWMMSq51aDO6r1E9CXAyBN58p20IvK0Fcij0';\n var title = \"Google Doc Title\";\n var dom = html`

\n ${title}\n \n

\n\n\n

`;\n var data = d3.csv(\n `https://docs.google.com/spreadsheets/d/${id}/export?format=csv`,\n d3.autoType\n );\n dom.value = data;\n dom.querySelector('button').addEventListener('click', () => {\n var data = d3.csv(\n `https://docs.google.com/spreadsheets/d/${id}/export?format=csv`,\n d3.autoType\n );\n dom.value = data;\n dom.dispatchEvent(new Event(\"input\"));\n });\n return dom;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"Inputs.table(doc)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1"}} 31:"$30:body"