public CSV(String email, String password, String spreadsheetTitle, String worksheetTitle) throws ServiceException, IOException { SpreadsheetService service = new SpreadsheetService("gsimple-gspreadsheet-1"); service.setUserCredentials(email, password); URL metafeedUrl = new URL("https://spreadsheets.google.com/feeds/spreadsheets/private/full"); SpreadsheetFeed feed = service.getFeed(metafeedUrl, SpreadsheetFeed.class); List<SpreadsheetEntry> spreadsheets = feed.getEntries(); for (SpreadsheetEntry entry : spreadsheets) { if (entry.getTitle().getPlainText().equals(spreadsheetTitle)) { List<WorksheetEntry> worksheets = entry.getWorksheets(); for (WorksheetEntry worksheet : worksheets) { if (worksheet.getTitle().getPlainText().equals(worksheetTitle)) { URL listFeedUrl = worksheet.getListFeedUrl(); entries = service.getFeed(listFeedUrl, ListFeed.class).getEntries().iterator(); } } } } }