spreadsheet to json android

public void cekupdate(){
        String bariskebawah = "https://docs.google.com/spreadsheets/d/1f3n662M9-gKBt41mcwkdjO0qykryvyCj0wug2CCz2yA/gviz/tq?tqx=out:json&sheet=Splash&range=A3:A31";
        String kolomkekanan = "https://docs.google.com/spreadsheets/d/1f3n662M9-gKBt41mcwkdjO0qykryvyCj0wug2CCz2yA/gviz/tq?tqx=out:json&sheet=Splash&range=B3:Z3";
        AndroidNetworking.get(bariskebawah)
                .doNotCacheResponse()
                .setUserAgent("Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:47.0) Gecko/20100101 Firefox/47.0")
                .build()
                .getAsString(new StringRequestListener() {
                    @Override
                    public void onResponse(String result) {
                        int start = result.indexOf("{", result.indexOf("{") + 1);
                        int end = result.lastIndexOf("}");
                        String jsonResponse = result.substring(start, end);
                        try {
                            JSONObject table = new JSONObject(jsonResponse);
                            JSONArray jsonArray;
                            JSONObject jsonObject = new JSONObject(String.valueOf(table));
                            jsonArray = jsonObject.getJSONArray("rows");
                            if (!jsonArray.isNull(0)) {
                                String baris1 = jsonArray.getJSONObject(0).getJSONArray("c").getJSONObject(0).getString("v");
                                String baris2 = jsonArray.getJSONObject(1).getJSONArray("c").getJSONObject(0).getString("v");
                                String baris3 = jsonArray.getJSONObject(2).getJSONArray("c").getJSONObject(0).getString("v");
                                String baris4 = jsonArray.getJSONObject(3).getJSONArray("c").getJSONObject(0).getString("v");
                                String baris5 = jsonArray.getJSONObject(4).getJSONArray("c").getJSONObject(0).getString("v");
                                String baris6 = jsonArray.getJSONObject(5).getJSONArray("c").getJSONObject(0).getString("v");

                                preff = new Preff(getApplicationContext(),"splashconf");
                                preff.savesplash(baris1,baris2,baris3,baris4,baris5,baris6);
                                if (baris6.equals("dismis")) {
                                    new AlertDialog.Builder(splash.this)
                                            .setTitle("Update App")
                                            .setMessage("Anda masih menggunakan Versi\n\n"+
                                                    "A. "+baris1+"\n\n"+
                                                    "B. "+baris2+"\n\n"+
                                                    "C. "+baris3+"\n\n"+
                                                    "D. "+baris4+"\n\n")
                                            .setPositiveButton("Yes Sir..", new DialogInterface.OnClickListener() {
                                                @Override
                                                public void onClick(DialogInterface dialog, int which) {
                                                    dialog.dismiss();
                                                }
                                            })
                                            .setCancelable(true)
                                            .show();
                                    }else goMain();
//
//                                //contoh untuk kolom kekanan
//                                //https://docs.google.com/spreadsheets/d/1f3n662M9-gKBt41mcwkdjO0qykryvyCj0wug2CCz2yA/gviz/tq?tqx=out:json&sheet=Splash&range=A3:Z3
//                                for (int i = 0; i < jsonArray.length(); i++) {
//                                    JSONObject row = jsonArray.getJSONObject(i);
//                                    JSONArray columns = row.getJSONArray("c");
//                                    String versiapp = columns.getJSONObject(0).getString("v");
//                                    String ketupdate = columns.getJSONObject(1).getString("v");
//                                    String linkupdate = columns.getJSONObject(2).getString("v");
//                                    String statsikln = columns.getJSONObject(3).getString("v");
//                                    String ketikln = columns.getJSONObject(4).getString("v");
//                                    String lingps = columns.getJSONObject(5).getString("v");
//                                    String linmenulog = columns.getJSONObject(6).getString("v");
//                                    String aboutapp = columns.getJSONObject(7).getString("v");
//                                    String tiap = columns.getJSONObject(8).getString("v");
////                                    splashPreferences.savesplash(statsikln,ketikln,lingps,linmenulog,aboutapp,tiap);
//                                    if (versiapp.equals("yes")) {
//                                        new AlertDialog.Builder(splash.this)
//                                                .setTitle("Update App")
//                                                .setMessage("Anda masih menggunakan Versi\n\n"+
//                                                        "A. "+versiapp+"\n\n"+
//                                                        "B. "+ketupdate+"\n\n"+
//                                                        "C. "+linkupdate+"\n\n"+
//                                                        "D. "+statsikln+"\n\n"+
//                                                        "E. "+ketikln+"\n\n"+
//                                                        "F. "+lingps+"\n\n"+
//                                                        "G. "+linmenulog+"\n\n"+
//                                                        "H. "+aboutapp+"\n\n"+
//                                                        "I. "+tiap+"\n\n")
//                                                .setNeutralButton("Update Nanti", new DialogInterface.OnClickListener() {
//                                                    @Override
//                                                    public void onClick(DialogInterface dialog, int which) {
//                                                        dialog.dismiss();
//                                                    }
//                                                })
//                                                .setCancelable(true)
//                                                .show();
//                                    }
//                                }
                            }
                        } catch (JSONException e) {
                            e.printStackTrace();
                        }
                    }
                    @Override
                    public void onError(ANError anError) {
                    }
                });
    }