Google Spreadsheet Integration

webby

Administrator
Admin
Toys For Tots
55,469
23,791
Google Spreadsheets:

For those who would like to create and share spreadsheets with users, we now have a way of doing just that.

First create a spreadsheet in google, or copy an existing excel spreadsheet over to google documents.
http://docs.google.com - free service for creating/sharing files. You just need a google login (or gmail account).

Step 1.) Create Your Spreadsheet -
======
gshare4.png


========

Step 2.) Publish The Document
go to "file" > "publish"
You will get a new popup menu like below.

Click "Start Publishing"

publish.png


After clicking "start publishing", a new window will pop up. Click close on that new popup. Nothing needs done with that info.

Step 3.) Edit The Share Settings - Top Right Button


gshare3.jpg


======


Step 4.) Edit The Share Settings - Make It Public

gshare1.jpg

======


Step 5.) Copy The Code Provided : Everything From "key=" Needs Copied


gshare.jpg


========

Step 6.) Paste The "key=" Code In Your Post With These "Tags" Below

The code copied from google needs to be inserted into "gss" tags. See image below for example

screenshot of example post. Note the "gss" opening tag, and the "/gss" closing tag.
gss.png


Follow that ^ example and you'll have a working spreadsheet that members can all see.
:wavey:
 
Last edited:
Just a heads up, it did not work with just these steps. I had to go into File>Publish To Web. After that there is a check box to auto publish upon changing it, check that and hit Publish in the window and you should be good to go!
 
Back
Top