Here's the setup: I'm building a simple App Engine application that will live on my domain. It's designed to be a data-store that aggregates data across a number of my key customers. I want to automate how I collect the data from the customers and here's what I have in mind.
I'll create a Google Spreadsheet formatted a specific way that each Customer can copy into their Google Docs domain. Each customer will "share" the Spreadsheet with me and give me view-only rights to it. Every month, the customers will populate the Spreadsheet with new data. I'll store the DocID of each customers's instance of the Spreadsheet within my application. My application will then use the Google Doc and Spreadsheet API's to read the data from *their* Spreadsheet on their domain and copy certain cells to* my*Spreadsheet on my domain. Is that possible? If I have read-only rights over a spreadsheet on another domain, will I be able to use the API's to connect to and read data from that spreadsheet? Is there a way for my application to authenticate to a document on another domain without the customer having to create a user (that represents me) on their domain? It seems that this would be a common use-case and way to collaborate across domains using the API's. I can't figure out whether it's supported or how to do it. Any ideas?
