BBCode - Embed Google Documents Collection (BB Code)

[BirdOPrey5]

Embed Various Google Docs

Live Demo: Here (http://www.juot.net/forums/showthread.php?p=872381#post872381)

Google Docs (https://docs.google.com/) is a free service by Google. Google Docs are a professional collection of "Office" applications like a Word Processor, Spreadsheet, Presentation Designer, and Drawing tool. Google Docs is a serious alternative to the very expensive Microsoft Office. Documents are stored online, can be shared among users, and in the case of this BB Code they can be embedded in other web pages.

There are several BB Codes in this collection, Google Doc (Document), Google Spreadsheet and Google Presentation. Google Drawings can be embedded using the standard tags but I will give an example here anyway.

When working on any Google Document in the top right of the window will be a "Share" button with drop-down arrow. Click on this arrow and choose "Publish to Web" or "Publish / Embed" and you will be given code to link to and/or embed the document. You will be given a URL such as:
https://docs.google.com/document/pub?id=1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

What you need is the document ID which is the long string of characters after "id=" or "key=" and before the ampersand (&) if present, in this case your id is:
1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

In all cases you put the ID between the appropriate tag for the type of document.

Google Document (Word Processor Document)
1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc

Google Spreadsheet
0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc

Google Presentation
dcjktv94_1fcpptwqc

Google Drawing
No special BB Code is needed to embed a drawing because it's rendered as any other image. Just put the URL given between IMG tags...
[IMG]https://docs.google.com/drawings/pub?id=1C1arwoUzUyzxnzk9yD7ysx6vyMfcDuDXXzQTqnngh2 c&w=640&h=480

To add one or more of these BB Codes follow any of the below instructions:

Add a New BB Code

Title: Google Document
BB Code Tag Name: gd
Replacement:

<div align="center"><iframe src="https://docs.google.com/document/pub?id={param}&amp;embedded=true&single=true&gid=0&output=html&widget=true" width="95%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id={param}">Direct Link to Google Document</a>.</iframe></div>

Example:1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc
Description: Embed a Google Document.
Use Option: No
Button Image: (optional) https://vborg.vbsupport.ru/attachment.php?attachmentid=122127&stc=1&d=1284852027
Remove Tag If Empty: Yes
All Disable Options: Yes

------

Add a New BB Code

Title: Google Spreadsheet
BB Code Tag Name: gs
Replacement:

<div align="center"><iframe width='95%' height='500' frameborder='0' src='https://spreadsheets.google.com/pub?key={param}&hl=en&single=true&gid=0&output=html&widget=true'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key={param}&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>

Example: 0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc
Description: Embed a Google Spreadsheet.
Use Option: No
Button Image: (optional) https://vborg.vbsupport.ru/attachment.php?attachmentid=122128&stc=1&d=1284852027
Remove Tag If Empty: Yes
All Disable Options: Yes

------

Add a New BB Code

Title: Google Presentation
BB Code Tag Name: gp
Replacement:

<div align="center"><iframe src="https://docs.google.com/present/embed?id={param}" frameborder="0" width="700" height="559">IFRAME Not Available. <a href="https://docs.google.com/present/view?id={param}">Direct Link to Presentation.</a></iframe></div>

Example:dcjktv94_1fcpptwqc
Description: Embed a Google Presentation.
Use Option: No
Button Image: (optional) https://vborg.vbsupport.ru/attachment.php?attachmentid=122129&stc=1&d=1284852027
Remove Tag If Empty: Yes
All Disable Options: Yes

------

In any of the above codes you can edit the height and width attributes to suit your needs.

------

Please mark as installed if you use this. :)

Check My Profile (https://vborg.vbsupport.ru/member.php?u=258922) for other BB Code enhancements. They work on all versions.

Download the .txt file for a copy of the Install instructions.

Screenshots Attached:

[WoodiE]

I have the spreadsheet set to publish to anyone with the link and I still can't show the spreadsheet on my site. The iframe displays:

We're sorry.

The publishing options given are not valid. Please check the options and try again.

[BirdOPrey5]

For a Spreadsheet you click on "Share" on the top right of the Google Spreadsheet window, choose "Publish as Web Page" and follow instruction to publish.

The "key" is pretty long, such as: 0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc
Make sure you copy only up to the ampersand (&) if you copy too much you may get an error.

If this still doesn't work it might be a Google problem. I would copy and paste all the data into a new spreadsheet and try sharing that.

[cowcowcow]

works perfect ty

[taylor_smith]

Has anyone tried this with vBulletin 3.7?

[BirdOPrey5]

It will work fine in 3.7... all bbcodes work with all versions pretty much.

[taylor_smith]

Thank you. :)

[whodah]

Oops - just realized there is a separate thread for 4.x branch. Moved question there, post #59:
https://vborg.vbsupport.ru/showthread.php?t=250780&highlight=Embed+Google+Documents