BB Code Enhancements - BBCode - Embed Google Documents Collection (BB Code)

Embed Various Google Docs

Live Demo: Here

Google Docs 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 [img] tags but I will give an example here anyway.

You may get a warning message saying the {param}s aren't enclosed in quotes. You can hit "continue" to ignore this error. As you can see in the code there are eventually double-quotes.

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)
[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]

Google Spreadsheet
[gs]0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc[/gs]

Google Presentation
[gp]dcjktv94_1fcpptwqc[/gp]

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[/IMG]

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&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:[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]
Description: Embed a Google Document.
Use Option: No
Button Image: (optional)
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: [gs]0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc[/gs]
Description: Embed a Google Spreadsheet.
Use Option: No
Button Image: (optional)
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:[gp]dcjktv94_1fcpptwqc[/gp]
Description: Embed a Google Presentation.
Use Option: No
Button Image: (optional)
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.
Donations always appreciated. :up:
Nominate MOTM if you LOVE it!

Check My Profile for other BB Code enhancements. They work on all versions.

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

Screenshots Attached:

[BirdOPrey5]

Just use my original code with the &single=true removed.

[JabirA]

Thank you! Why don't make it default than?

[BirdOPrey5]

Just did.

[UK CHI3F]

Been using this mod for a while but all of a sudden the spreadsheets dont appear anymore, no changes have been made tried other sheets as well but to no avail

Any ideas?

[BirdOPrey5]

The spreadsheets still work on the demo page: http://www.qapla.com/mods/showthread...eets-and-Forms

So I don't think Google changed anything...

Can you post an example of one of yours that isn't working as well as copy the replacement code from the bbcode into a [code] box here?

[UK CHI3F]

Here is our main sheet on our site.
http://www.xboxplayers.co.uk/site/sh...2012-Standings

this is the bb code it has always had

[gs]0AjKwY3XXQSBvdGlrdjg4cjdDS1Y2Vm80S2p6b0FXV0E[/gs]

this is the original document
https://docs.google.com/spreadsheet/...6b0FXV0E#gid=7

This is the replacement code

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

Thanks for your help

[BirdOPrey5]

I don't know why you can't open it but my suggestion is to download a copy, reupload it, publish the new copy to the web and get the new code and use that- it worked for me.

You can edit your post with the new bbcode code.

[insidegames]

Doesn't work for me under 4.2. Always there are now Spreedshet. It's says "Sorry, it's not public now"

[BirdOPrey5]

It works on my 4.2.0 forum. Are you sure the documents are still public?

Demo: http://www.qapla.com/mods/showthread...eets-and-Forms

[kylek]

Originally Posted by BirdOPrey5

It works on my 4.2.0 forum. Are you sure the documents are still public?

Demo: http://www.qapla.com/mods/showthread...eets-and-Forms

Your spreedsheet example is not showing on your site right now, sames as what we get, just blank space.