BatchUpdateSpreadsheetResponse createSheetsResponse = service.spreadsheets() .batchUpdate(spreadsheetId, createSheetsBody).execute(); int sourceSheetId = createSheetsResponse.getReplies().get(0).getAddSheet().getProperties() .getSheetId(); int targetSheetId = createSheetsResponse.getReplies().get(1).getAddSheet().getProperties() .getSheetId();