Pushing data from a Google spreadsheet to an external app

[Murray Spork]

Hi,

Not sure if this is the right group to ask this - sorry in advance if
not (and maybe you can point me to the right group to ask).

I want to push data from a Google Spreadsheet to some external web app
- something like what the Coda folks show in this blog:

http://blog.coda2go.com/2008/05/30/google-apps-integration-brings-spreadsheet-joy-to-accountants-2/

I can of course have my external app poll the spreadsheet atom feed -
but I want it to be triggered from the spreadsheet.

Is this possible? If so what is the easiest way to do this?

I've seen google scripts - I imagine it will support this - but of
course I do not have access to that.

I've thought of other possibilities - but they all seem a bit hacky:

* Embedded Gadget that is just a "publish" button
* use something like Greasemonkey to inject custom javascript logic

Maybe an iGoogle widget would help?

Any ideas/ pointers would be appreciated.

Cheers,
Murray

[Jeff S (Google)]

Hi Murray,

I think the discussion group for the Google Docs and Google Spreadsheets APIs would be a better place for this question.

http://groups.google.com/group/Google-Docs-Data-APIs

What you describe sounds a bit like web hooks, you want to updates to a spreadsheet to trigger notifications to other end points on the web.

I don't think that the Spreadsheets API has this yet (it would be good to ask just to make sure). If not yet supported, you could implement something like this on App Engine using a design similar to that in PubSubHubbub http://code.google.com/p/pubsubhubbub/. The app engine hub could be responsible for polling the Spreadsheets API for changes and pushing notifications to other endpoints (cron for polling, urlfetch for pushing notifications downstream).

Thank you,

Jeff

[Murray Spork]

Thanks Jeff - not quite what I'm looking for - but that gives me some
ideas. I'll follow up on the Google Spreadsheets API group.

Murray

On Jul 21, 12:58 pm, "Jeff S (Google)" <j...@google.com> wrote:
> Hi Murray,
>
> I think the discussion group for the Google Docs and Google Spreadsheets
> APIs would be a better place for this question.
>
> http://groups.google.com/group/Google-Docs-Data-APIs
>
> What you describe sounds a bit like web hooks, you want to updates to a
> spreadsheet to trigger notifications to other end points on the web.
>
> I don't think that the Spreadsheets API has this yet (it would be good to
> ask just to make sure). If not yet supported, you could implement something

> like this on App Engine using a design similar to that in PubSubHubbubhttp://code.google.com/p/pubsubhubbub/. The app engine hub could be

> responsible for polling the Spreadsheets API for changes and pushing
> notifications to other endpoints (cron for polling, urlfetch for pushing
> notifications downstream).
>
> Thank you,
>
> Jeff
>

> On Mon, Jul 20, 2009 at 3:38 PM, Murray Spork <murray.sp...@gmail.com>wrote:
>
>
>
> > Hi,
>
> > Not sure if this is the right group to ask this - sorry in advance if
> > not (and maybe you can point me to the right group to ask).
>
> > I want to push data from a Google Spreadsheet to some external web app
> > - something like what the Coda folks show in this blog:
>

> >http://blog.coda2go.com/2008/05/30/google-apps-integration-brings-spr...