# Google docs onebox gem requires a "published" document

**URL:** https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649
**Category:** Support
**Created:** [9월 23, 2015, 4:42오후 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649 "2015-09-23T16:42:23Z")
**Posts on this page:** 14
**Page:** 2

<div class="post-metadata">

### Author: ![erlend\_sh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/erlend_sh/32/119475_2.png) [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)
#### Post date: [8월 11, 2016, 9:06오전 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/21 "2016-08-11T09:06:24Z")

</div>

Maybe private docs could also use the text field to have a note about that status? E.g. just put “_Document is private_” there.

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [8월 11, 2016, 3:05오후 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/22 "2016-08-11T15:05:03Z")

</div>

> [@mcwumbly](#):
>
> Perhaps that “title” should be rendered in bold blue text as “Google Sheets” or “Google Docs” or “Google Slides” when the title content can’t be retrieved?

> [@mcwumbly](#):
>
> would it be possible to make the large icon clickable as well?

> [@erlend\_sh](#):
>
> Maybe private docs could also use the text field to have a note about that status?

Done! 🌻

> **[Google Docs: Sign-in](https://accounts.google.com/v3/signin/identifier?continue=https%3A%2F%2Fdocs.google.com%2Fdocument%2Fd%2F1Ul13it0xzHxzjM1vQYAJPIimVVFbyThYqIJjizqy0qs%2Fedit%3Fusp%3Dsharing&dsh=S974844454%3A1780311509923012&followup=https%3A%2F%2Fdocs.google.com%2Fdocument%2Fd%2F1Ul13it0xzHxzjM1vQYAJPIimVVFbyThYqIJjizqy0qs%2Fedit%3Fusp%3Dsharing&ltmpl=docs&osid=1&passive=1209600&service=wise&flowName=GlifWebSignIn&flowEntry=ServiceLogin&ifkv=AWa2PaurSaWzmOfLSIzLiKBQdZ5MZ2c0uf5JZxMdBVXjiYOE_ObYpM292AzhvTmNCTA6pj01IU9c)**
>
> Access Google Docs with a personal Google account or Google Workspace account (for business use).

---

<div class="post-metadata">

### Author: ![alehandrof](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alehandrof/32/119526_2.png) [@alehandrof](https://meta.discourse.org/u/alehandrof)
#### Post date: [8월 22, 2016, 1:06오후 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/23 "2016-08-22T13:06:10Z")

</div>

This is perfect, except for a minor quibble:

This works: `https://docs.google.com/spreadsheets/d/gibberish/edit`

But this doesn’t: `https://docs.google.com/spreadsheets/d/gibberish`

Both are valid URLs as far as Google Docs is concerned.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [8월 22, 2016, 11:04오후 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/24 "2016-08-22T23:04:36Z")

</div>

Sure @techapj can you have a look at that?

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [8월 23, 2016, 12:43오후 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/25 "2016-08-23T12:43:40Z")

</div>

Fixed via:

[https://github.com/discourse/onebox/commit/d7c626d2622668d04878ad653ea7d6671773c5e8](https://github.com/discourse/onebox/commit/d7c626d2622668d04878ad653ea7d6671773c5e8)

---

<div class="post-metadata">

### Author: ![alehandrof](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alehandrof/32/119526_2.png) [@alehandrof](https://meta.discourse.org/u/alehandrof)
#### Post date: [9월 8, 2016, 7:21오전 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/26 "2016-09-08T07:21:44Z")

</div>

FWIW, I find the summaries for public documents underneath the title to be overlong and redundant.

For Google Sheets in particular, the summary is confusing as it runs along the column headings with data.

Real-world example:

 ![](https://global.discourse-cdn.com/meta/original/3X/e/f/efb2c05b35937f0e5f52ad7543368f800391e614.png)

I don’t see this as useful at all.

I would love an option to turn the summaries off – or to turn them off entirely, unless there are stalwart fans of them.

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [9월 12, 2016, 4:14오전 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/27 "2016-09-12T04:14:47Z")

</div>

Yeah it feels like there is other metadata that is far more interesting.

- Creation date of the document
- Last editor
- Last edit

Perhaps we can pick that up instead?

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [9월 12, 2016, 5:27오전 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/28 "2016-09-12T05:27:11Z")

</div>

> [@sam](#):
>
> Creation date of the document  
> Last editor  
> Last edit

Accessing that data will require API credentials. Currently we are relying on OpenGraph data which provides title, type, description (summary), image (snippet).

---

<div class="post-metadata">

### Author: ![ewanly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/ewanly/32/62854_2.png) [@ewanly](https://meta.discourse.org/u/ewanly)
#### Post date: [10월 31, 2016, 11:52오전 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/29 "2016-10-31T11:52:14Z")

</div>

I’m just started to try out the google docs onebox. The following link: ([https://docs.google.com/spreadsheets/d/1lAuOv25IyOQgvkrTQb0ijKQhigAIeRrm2DoJUOsUiDQ/pubhtml?gid=1732160294&single=true](https://docs.google.com/spreadsheets/d/1lAuOv25IyOQgvkrTQb0ijKQhigAIeRrm2DoJUOsUiDQ/pubhtml?gid=1732160294&single=true)) is puplished and are able to access through the browser or from the onebox even. But still said as you could see below; “`This Sheet is Private`”.

[https://docs.google.com/spreadsheets/d/1lAuOv25IyOQgvkrTQb0ijKQhigAIeRrm2DoJUOsUiDQ/pubhtml?gid=1732160294&single=true](https://docs.google.com/spreadsheets/d/1lAuOv25IyOQgvkrTQb0ijKQhigAIeRrm2DoJUOsUiDQ/pubhtml?gid=1732160294&single=true)

---

<div class="post-metadata">

### Author: ![Andrew\_Shanahan](https://avatars.discourse-cdn.com/v4/letter/a/71c47a/32.png) [@Andrew\_Shanahan](https://meta.discourse.org/u/Andrew_Shanahan)
#### Post date: [1월 6, 2017, 10:31오전 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/30 "2017-01-06T10:31:26Z")

</div>

> [@sam](#):
>
> Can you add that to your list? Embedding a full Google spreadsheet, doc, etc is kind of insane when you think about it..
> 
> Yeah, if anything it should be optional, opt-in. I would hold off for 1.7 though and just have it use the generic default onebox support (after mini onebox is built)

Hmm, this has really screwed us over at [www.talk.manvfat.com](http://www.talk.manvfat.com) we used embedded Google Spreadsheets as a way for guys to record their weights, the spreadsheet then calculated BMI, etc.

e.g. - how it used to work for us:

[https://talk.manvfat.com/t/weigh-in-day-16th-december/18283](https://talk.manvfat.com/t/weigh-in-day-16th-december/18283)

What it looks like now:

[https://talk.manvfat.com/t/weigh-in-day-06-01-2017/18738](https://talk.manvfat.com/t/weigh-in-day-06-01-2017/18738)

We also used them as a way of running tracking threads - e.g. guys who wanted to track days off booze, etc.

It wasn’t perfect (mobile users didn’t report great functionality) so it could have been improved but neither of those functions can be replicated by Discourse as standard, so to my mind, you’ve stripped away something without much thought about who might be using this function.

Is there any other way of doing this? Any suggestions?

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [1월 6, 2017, 3:03오후 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/31 "2017-01-06T15:03:20Z")

</div>

> [@Andrew\_Shanahan](#):
>
> Is there any other way of doing this? Any suggestions?

Create a custom plugin based on old onebox code.

---

<div class="post-metadata">

### Author: ![burke](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/burke/32/4211_2.png) [@burke](https://meta.discourse.org/u/burke)
#### Post date: [4월 13, 2017, 5:03오후 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/32 "2017-04-13T17:03:11Z")

</div>

> [@codinghorror](#):
>
> Can you add that to your list? Embedding a full Google spreadsheet, doc, etc is kind of insane when you think about it.

Bummed that we lost the ability to embed Google Docs. The ability to easily iframe a Google Doc was a nice way to get shared notes in front of people’s eyes who are less likely to click through to a separate document. I wish there was a way to get the original embedded behavior (e.g., put “embed:” in front of the URL). Oh well. :sadpanda:

---

<div class="post-metadata">

### Author: ![Hugh\_Roberts](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hugh_roberts/32/181083_2.png) [@Hugh\_Roberts](https://meta.discourse.org/u/Hugh_Roberts)
#### Post date: [8월 6, 2020, 8:30오전 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/33 "2020-08-06T08:30:48Z")

</div>

이 문제에 대한 우회책이 여전히 없나요? 최소한 슬라이드 덱을 임베드할 수 있다면 매우 유용할 것 같습니다.

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [6월 8, 2024, 12:36오후 UTC](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649/34 "2024-06-08T12:36:53Z")

</div>

이 주제는 3180일 후 자동으로 닫혔습니다. 더 이상 새로운 답글을 작성할 수 없습니다.

[이전 페이지](https://meta.discourse.org/t/google-docs-onebox-gem-requires-a-published-document/33649.md?page=1)
