Hi Barry, The Sheets API should be able to access the same spreadsheets you can access via Google Drive, regardless of who owns them. As long as you have at least read access on the spreadsheet you should be able to fetch it's data via the API. Please make sure you are using the same Google account in both the Drive UI and the API.
- Eric On Monday, December 31, 2018 at 2:32:51 PM UTC-5, Barry Anderson wrote: > > Hello, > > My name is Barry and I am new to the google sheets API and APIs in general > (sorry in advance). I have successfully been able to access a sheet that I > have created under my personal account following the creating credentials > steps in the API documentation . However, when I go to access another sheet > that I've added to my google drive that has been shared with me from > another user I am unable to access the sheet via the API. This sheet is > updated daily, so creating a copy of the sheet would not work as it would > not update along with the original sheet like I need it to. I have > successfully been able to access the copy of sheet I made for testing > purposes but now I am ready to pull data from the original sheet and I'm > unable to do so. > > The person I am sharing this sheet is across the globe from me is not > technically inclined whatsoever so basically my question is what is the > easiest way to make this happen with the least amount of possible friction? > Any help would be greatly appreciated. thanks and Happy New Year! > > > respectfully, > Barry > > > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
