Connection API to google doc spreadsheet

View: New views
4 Messages — Rating Filter:   Alert me  

Connection API to google doc spreadsheet

by DaveMan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Does anyone know of any documentation or process whereby I can get a
GM script to parse output to a shared google spreadsheet ?

Thanks

DaveMan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "greasemonkey-users" group.
To post to this group, send email to greasemonkey-users@...
To unsubscribe from this group, send email to greasemonkey-users+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/greasemonkey-users?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: Connection API to google doc spreadsheet

by qufighter :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


I would start here http://code.google.com/apis/spreadsheets/

There are samples using many server side languages, so while it may be
possible to create your own method of interfacing with the API using
JavaScript directly it may be safer and easier to send the data to
your own web server first, which then authenticates and adds it to the
spreadsheet, otherwise your credentials to connect to the spreadsheet
being in the user script is a security vulnerability if your sharing
it with multiple people.

On Nov 1, 1:56 pm, DaveMan <webtea...@...> wrote:
> Does anyone know of any documentation or process whereby I can get a
> GM script to parse output to a shared google spreadsheet ?
>
> Thanks
>
> DaveMan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "greasemonkey-users" group.
To post to this group, send email to greasemonkey-users@...
To unsubscribe from this group, send email to greasemonkey-users+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/greasemonkey-users?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: Connection API to google doc spreadsheet

by DaveMan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


I can set it up on a server, but is there any documentation that will
give me examples of methods for making the connection ?

Thanks

DaveMan

On Nov 1, 2:49 pm, qufighter <qufigh...@...> wrote:

> I would start herehttp://code.google.com/apis/spreadsheets/
>
> There are samples using many server side languages, so while it may be
> possible to create your own method of interfacing with the API using
> JavaScript directly it may be safer and easier to send the data to
> your own web server first, which then authenticates and adds it to the
> spreadsheet, otherwise your credentials to connect to the spreadsheet
> being in the user script is a security vulnerability if your sharing
> it with multiple people.
>
> On Nov 1, 1:56 pm, DaveMan <webtea...@...> wrote:
>
>
>
> > Does anyone know of any documentation or process whereby I can get a
> > GM script to parse output to a shared google spreadsheet ?
>
> > Thanks
>
> > DaveMan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "greasemonkey-users" group.
To post to this group, send email to greasemonkey-users@...
To unsubscribe from this group, send email to greasemonkey-users+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/greasemonkey-users?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: Connection API to google doc spreadsheet

by qufighter :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


I'm assuming ( you mean the connection between greasemonkey and the
web-server.  The solution is GM_xmlhttprequest, with which you can
post your data in any format you want.  I would say just post your
data using CSV, then with your server side script split the data into
whatever format it needs to be to add it to the spreadsheet using
whichever language it is that you choose to use.  Once you get the
server side script working getting the data into a spreadsheet the
rest should be pretty trivial.  You can test it using GET and request
like /script.ext?addRow=1,2,3,4.  Alternatively you might construct
the exact data object to send to Google client side in greasemonkey
and post it to your script, while your server side script is more of a
pass through, although this solution seems less secure and a lot more
work, and a bigger client side script and more data to send which may
reduce server cpu at additional bandwidth cost.  I would just make
your server side script accept various commands to perform the actions
you need to perform.  And if you need to add more than one row at a
time, or more than one command at a time, implement it in such a way
that you still only post one time.  Take into consideration with CSV
that you can't add data that contains comas unless you account for
them somehow.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "greasemonkey-users" group.
To post to this group, send email to greasemonkey-users@...
To unsubscribe from this group, send email to greasemonkey-users+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/greasemonkey-users?hl=en
-~----------~----~----~----~------~----~------~--~---