Google docs import with oauth2. In Google Oauth2 VBA authentication I covered how to use oauth2 from VBA.
Elsewhere on this site you'll see other ways to get data out of google Spreadsheets such as Promises in VBA and Google Visualization. Neither of those used oAuth2 so they were limited to public facing spreadsheets. Now here is how to get private data into Excel. Mobile Web App And Apps Script (GDL-Israel) Programming.
Java. Google I/O 2012 - Putting Together the Pieces: Building Apps with Google Apps Script. Quantum computing. Programming. Linux. Android.