Membuat Cronjob Dengan Google Drive

Pastikan punya email Gmail kemudian Login dan masuk disini


Kemudian klik BUAT
Seperti GAMBAR  ini :

Lalu Pilih SPREADSHEET
Lihat GAMBAR :

Selanjutnya KLIK "Spreadsheet Tidak Berjudul" dan kasih judul, Saya Ambil Contoh disini saya kasih nama CronJob.
Lihat Gambar :

Perhatikan GAMBAR berikut :
Pada anak panah 1 ada "KODE SHEET"yg harus disimpan di notepad
Kemudian klik anak panah nomor 2 "EDITOR SCRIPT"

Setelah Klik editor script akan keluar tampilan berikut :

Klik anak panah 1 kemudian akan muncul anak panah 2 ganti nama misal saya ambil contoh KOMEN lalu perhatikan anak panah nomor 3 ganti dengan script berikut :

Copy Kode Berikut

function cronExecute() {<br /> <br /> var url = "http://www.domaninMU.com/komen.php";<br /> <br /> var options = {<br /> "method" : "get",<br /> "headers" : {'User-Agent' : 'Mozilla Firefox 14.0',<br /> 'Accept-Charset' : 'ISO-8859-1,utf-8;q=0.7,*;q=0.7'<br /> },<br /> "payload" : "",<br /> "contentType" : "application/xml; charset=utf-8"<br /> };<br /> <br /> var request_starttime = new Date();<br /> // fetch the HTTP / HTTPS request and get the response<br /> var response = UrlFetchApp.fetch(url,options);<br /> var request_endtime = new Date();<br /> <br /> // use any spreadsheet, use its key<br /> // var ss = SpreadsheetApp.openById("KEY-SHEET");<br /> // use this script's default spreadsheet<br /> var ss = SpreadsheetApp.getActiveSpreadsheet();<br /> // get the worksheet<br /> var sheet = ss.getSheets()[0];<br /> <br /> // inserting values into the sheet<br /> sheet.insertRowBefore(1);<br /> var colValues = [[ request_starttime, request_endtime,<br /> response.getResponseCode(), response.getHeaders().toSource(),<br /> url, response.getContentText() ]];<br /> sheet.getRange(1, 1, 1, 6).setValues(colValues);<br /> <br /> // if something is not working, use the Logger object/function (uncomment it and modify it)<br /> // Logger.log(ss.getSpreadsheetTimeZone());<br /> <br /> // view the log details from VIEW -> LOGS<br /> <br /> // You can also RUN the script and view its Execution log<br /> // try this VIEW -> EXECUTION TRANSCRIPTS<br /> <br /> // Make sure you MODIFY and then RUN the script and<br /> // verify its working OK by looking at the spreadsheet contents<br /> // try this RUN -> CRONEXECUTE<br /> // check the spreadsheet contents<br /> <br /> // After its working OK, you should setup a TRIGGER to execute it as and when you want (frequency)<br /> // try this TRIGGERS -> ALL YOUR TRIGGERS<br /> <br /> }<br /> <br /> }

Yang perlu diganti adalah yg berwarna merah :
function cronExecute() { var url = "http://www.domaninMU.com/komen.php"; var options = { "method" : "get", "headers" : {'User-Agent' : 'Mozilla Firefox 14.0', 'Accept-Charset' : 'ISO-8859-1,utf-8;q=0.7,*;q=0.7' }, "payload" : "", "contentType" : "application/xml; charset=utf-8" }; var request_starttime = new Date(); // fetch the HTTP / HTTPS request and get the response var response = UrlFetchApp.fetch(url,options); var request_endtime = new Date(); // use any spreadsheet, use its key // var ss = SpreadsheetApp.openById("KEY-SHEET"); // use this script's default spreadsheet var ss = SpreadsheetApp.getActiveSpreadsheet(); // get the worksheet var sheet = ss.getSheets()[0]; // inserting values into the sheet sheet.insertRowBefore(1); var colValues = [[ request_starttime, request_endtime, response.getResponseCode(), response.getHeaders().toSource(), url, response.getContentText() ]]; sheet.getRange(1, 1, 1, 6).setValues(colValues); // if something is not working, use the Logger object/function (uncomment it and modify it) // Logger.log(ss.getSpreadsheetTimeZone()); // view the log details from VIEW -> LOGS // You can also RUN the script and view its Execution log // try this VIEW -> EXECUTION TRANSCRIPTS // Make sure you MODIFY and then RUN the script and // verify its working OK by looking at the spreadsheet contents // try this RUN -> CRONEXECUTE // check the spreadsheet contents // After its working OK, you should setup a TRIGGER to execute it as and when you want (frequency) // try this TRIGGERS -> ALL YOUR TRIGGERS }


Terakhir tinggal save anak panah 1, lalu seting waktunya anak panah 2, kemudian jalankan Cronjob anak panah 3 :

sumber