Yes, so long as they have shared the document with you, and your application logs in as you, it will be be able to read the document using the Google Spreadsheet API. Just like they can share a document with you now, and you can access it, even though your account is not from their domain.
cheers, David. On Wed, Apr 6, 2011 at 11:07 PM, David Miller <[email protected]> wrote: > 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? > > > >
