week6.md

function myFunction() {
  var url = 'https://docs.google.com/spreadsheets/d/11SMQaAogdTzr4AzyAyqa7H1kjEXhp286KRFOFQ_XOzA/edit#gid=0';
  var spredSheet = SpreadsheetApp.openByUrl(url);
  var baseSheet = spredSheet.getSheetByName("base");
  baseSheet.getRange('a1:e1').setValue("안녕하세요");
  baseSheet.getRange('a2:e2').setValue("안녕히가세요");
  var targetSiteUrl = 'http://www.r114.com/z/real/m_detail.asp?only=0&m_=5&g_=&type_m=m&addr1=%BC%AD%BF%EF%C6%AF%BA%B0%BD%C3&addr2=%B0%AD%B3%B2%B1%B8&addr3=%BF%AA%BB%EF%B5%BF&type_g=A&type_cd=03%5E05%5E&mpl=15000&mph=16000&SF_PKVal=6&SF_Size=0&rNumber=8051&lst=ml&mkind=30&aptcode=G01011350800030&mulcode=30BB0F25607876&housingtype=77.77&areasize=00023&sizetype=D';
  baseSheet.getRange('a3:e3').setValue(targetSiteUrl);
  
  var statement = '=IMPORTXML("http://www.r114.com/z/real/m_detail.asp?only=0&m_=5&g_=&type_m=m&addr1=%BC%AD%BF%EF%C6%AF%BA%B0%BD%C3&addr2=%B0%AD%B3%B2%B1%B8&addr3=%BF%AA%BB%EF%B5%BF&type_g=A&type_cd=03%5E05%5E&mpl=15000&mph=16000&SF_PKVal=6&SF_Size=0&rNumber=8051&lst=ml&mkind=30&aptcode=G01011350800030&mulcode=30BB0F25607876&housingtype=77.77&areasize=00023&sizetype=D", "//*[@id=\'wrap\']/div[5]/div[3]/div[1]/div[2]/div[3]/dl[1]/dd/span")';
  baseSheet.getRange('a4').setValue(statement);
  
  var statement2 = '=IMPORTXML("http://www.r114.com/z/real/m_detail.asp?only=0&m_=5&g_=&type_m=m&addr1=%BC%AD%BF%EF%C6%AF%BA%B0%BD%C3&addr2=%B0%AD%B3%B2%B1%B8&addr3=%BF%AA%BB%EF%B5%BF&type_g=A&type_cd=03%5E05%5E&mpl=15000&mph=16000&SF_PKVal=6&SF_Size=0&rNumber=8051&lst=ml&mkind=30&aptcode=G01011350800030&mulcode=30BB0F25607876&housingtype=77.77&areasize=00023&sizetype=D", "//*[@id=\'obj_AreaTypeChg_Title\']/text()")';
  baseSheet.getRange('a5').setValue(statement2);

}