BB Code Media Site support for Google Spreadsheets 1.0

[Saeed]

Saeed submitted a new resource:

BB Code Media Site support for Google Spreadsheets (version 1.0) - Allows embedding of Google Spreadsheets by adding support under XenForo's BB Code Media Site Manager

This resource / tutorial will help you add an entry for Google Spreadsheets to your BB Code Media Sites in your Admin Control Panel.

--------------------------------------------------


1. Go to your Admin Control Panel > Home > BB Code Media Sites > Add BB Code Media Site.

2. Here, enter the following information:

Media Site ID: googlespreadsheet

Site Title: Google Spreadhsheet

Site URL: https://docs.google.com/

Match URLs:
https://docs.google.com/spreadsheet/ccc?key={$id}#

Embed HTML:

<iframe width='750' height='750' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key={$id}&output=html&widget=true'></iframe>

You may change the width and height to your liking (shown in the code above in blue).

3. Click "Save the BB Code Media Site".

4. To embed the document with the URL of a Google Spreadsheet, click "Embed Media" and paste the URL.

5. To embed the spreadsheet manually, the format would be something like this:

[media=googlespreadsheet]0Aq-ZUoz4kLmPdGlLX2tOSEpPZFlaQ2t1VXMyZ1U0U1E[/media]

The result should look something like this:

 

[Keith]

Thankyou very much for the guide, it's works like a treat

 

[principia]

fyi
after switching my google account to google drive the bb code doesnt work any longer.
is it possible, that something is changed?

 

[Saeed]

fyi
after switching my google account to google drive the bb code doesnt work any longer.
is it possible, that something is changed?

I just tried with a spreadsheet now uploaded at my own Google Drive. It seems to be still working for me.

Could you post a link to a document uploaded on your Google Drive and I could probably have a look?

 

[principia]

I just tried with a spreadsheet now uploaded at my own Google Drive. It seems to be still working for me.

Could you post a link to a document uploaded on your Google Drive and I could probably have a look?

Mhh, very interesting. I have tried it again and it works
Sorry

 

[chinleng]

When embedding a google spreadsheet,

I encounter an error when I use this in the Matched URLs:

https://docs.google.com/spreadsheet/ccc?key={$id}#

But I get it to work if I use this in the Matched URLs:

https://docs.google.com/spreadsheet/pub?key={$id}

 

[CFodder]

Using XF 1.2.3 I get the error

The specified URL cannot be embedded as media

Have followed the steps as per your instructions (also tried chinleng's fix) but it keeps comign up with the error.

 

[tajhay]

Does this still work?

 

[RockThatClock]

It's not working here.

 

[Jim Boy]

Google docs have changed the url format.

You now need to look for:

https://docs.google.com/spreadsheets/d/{$id}/pubhtml

and replace with:

<iframe src="https://docs.google.com/spreadsheets/d/{$id}/pubhtml?widget=true&amp;headers=false" frameborder="0" height="500" width="100%"></iframe>

Note that you can change height and width to suit

@Saeed - FYI

 

[DFI]

BBCode is no more working for new spreadsheets. I thing google changes the extensions.

Its Showing like this :

https://docs.google.com/spreadsheet/d?key={$id}#

 

[DFI]

Someone please help.

 

[karzac]

Now:



Match URLs:
https://docs.google.com/spreadsheet/pub?key={$id}&output=html

Embed HTML:
<iframe width="500" height="300" frameborder="0" src="https://docs.google.com/spreadsheet/pub?key={$id}&output=html&widget=true" frameborder="0" height="500" width="100%"></iframe>



with Xenforo 1.3.6