Using Google Apps 'within' App Engine?

[sal]

I'm sure there's probably a simple answer out there for this one...
but minor brainflub is preventing me from connecting the dots yet - I
thought someone on the list might have a tiny bit of insight:

What I'm trying to figure out:

I'd like the user to click a link/button within my GAE app. The event
queries datastore, and shows the data inside of a Google Docs
Spreadsheet. However - I'd like to show the spreadsheet (along with
save / etc. functionality) within my GAE hosted web site... I'm
willing to stoop to using frames to give the illusion if possible.

The user should be single-signed-into Google Docs session, which seems
possible via the APIs we have access to - and I've seen the APIs for
interacting with Google Docs 'data'. But how do I mash together the
UIs of Google Docs with my GAE apps' UI.

Likewise I'm wondering if it would be possible to do the same with
Word Processor documents and Presentations.

thanks in advance for any tips! I'll keep hunting in the meantime...

- sal

[sal]

Quick update: I figured part of this out - This HTML lets you imbed
Google Docs into your own webpage - to let users edit/view stuff
inplace: (found by doing lots of 'view source' and poking around)

(some html from your webpage here) <br>

<iframe width=100% height=300 src="https://www.google.com/accounts/
ServiceLoginAuth?
service=wise&continue=DOCURLHERE&Email=LOGINHERE&Passwd=PASSWORDHERE"
>
</iframe><br>
(more of your html here)

DOCURLHERE = url to the spreadsheet, you can get one to test with by
looking in the URL bar of your browser after opening a Google
spreadsheet
LOGINHERE = user's google login
PASSWORDHERE = user's google password

This opens the document in a frame - and gives all the save/etc
options. (I have some other javascript to allow resizing/etc.)

Things I have left to figure out:

- Better way to single-sign in the user from GAE, to avoid having his
password written to the HTML
- I would prefer 'fullscreen' mode, since it hides the header with
extraneous info (ie: google navbar, etc) which is accessible via
shift-f inside the spreadsheet editor, but I need a way to invoke it
by default... would make it look 'truely' seemless in my GAE webpage
- A way to calculate the doc URL programatically (I'm hoping the Docs
APIs have some info - haven't researched there yet)

If anyone has tips / has done this before... info is much appreciated,

Thanks,