function getMailToiawase(){
var sheet = SpreadsheetApp.getActiveSheet();
var search = '("subject:(【・・・・】お問い合わせがありました)")';
var start = 0;
var max = 500;
var thds = GmailApp.search(search,start,max);
var row = 3;
for(var n in thds){
var thd = thds[n];
var msgs = thd.getMessages();
for(m in msgs){
var msg = msgs[m];
var date = msg.getDate();
var body = msg.getBody();
var bodys= body.replace('会社名:','')
.replace('担当者名:','')
.replace('部署:','')
.replace('役職:','')
.replace('メールアドレス:','')
.replace('電話番号:','')
.replace('住所(本社):','')
.replace('業種:','')
.replace('従業員数:','')
.replace('売上高:','')
.replace('ホームページURL:','')
.replace('当サイトを知ったきっかけ:','')
.replace('ご紹介者/ご紹介企業:','')
.replace('ご紹介者/ご紹介企業に・・・?:','')
.replace('・・・・・?:','')
.replace('項目1','')
.replace('項目2','')
.replace('項目3','')
.replace('項目4','')
.replace('項目5','')
.replace('項目6','')
.replace('項目7','')
.replace('項目8','')
.replace('項目9','')
.replace('項目10','')
.replace('項目11','')
.replace('項目12','')
.replace('項目13','')
.replace('項目14','')
.replace('項目15','')
.replace('項目16','')
.replace('項目17','')
.replace('項目18','')
.replace('項目19','')
.replace('項目20','')
.replace('項目21','')
.replace('項目22','')
.replace('項目23','')
.replace('項目24','')
.replace('項目25','')
.replace('項目26','')
.replace('項目27','')
.replace('項目28','')
.replace('項目29','')
.replace('項目30','')
.replace('項目31','')
.replace('項目32','')
.replace('項目33','')
.replace('項目34','')
.replace('項目35','')
.replace('項目36','')
.replace('項目37','')
.replace('項目38','')
.replace('項目39','')
.replace('項目40','')
.replace('項目41','')
.replace('項目42','')
.replace('項目43','')
.replace('項目44','')
.replace('項目45','')
.replace('項目46','')
.replace('項目47','')
.replace('項目48','')
.replace('項目49','')
.replace('項目50','')
.replace('項目51','')
.replace('項目52','')
.replace('項目53','')
.replace('項目54','')
.replace('項目55','')
.replace('項目56','')
.replace('項目57','')
.replace('項目58','')
.replace('項目59','')
.replace('項目60','')
.replace('項目61','')
.replace('項目62','')
.replace('項目63','')
.replace('項目64','')
.replace('項目65','')
.replace('項目66','')
.replace('項目67','')
.replace('項目68','')
.replace('項目69','')
.replace('項目70','')
;
// 改行を使って配列化する
var ary = bodys.split("\n");
// ご用件の行を取得し文字を抽出
var kaisyamei = ary[3].substring(0).replace('\r','');
var tantou = ary[4].substring(0).replace('\r','');
var busyo = ary[5].substring(0).replace('\r','');
var yakusyoku = ary[6].substring(0).replace('\r','');
var mail = ary[7].substring(0).replace('\r','');
var tel = ary[8].substring(0).replace('\r','');
var zyusyo = ary[9].substring(0).replace('\r','');
var gyousyu = ary[10].substring(0).replace('\r','');
var zyugyoin = ary[11].substring(0).replace('\r','');
var uriage = ary[12].substring(0).replace('\r','');
var url = ary[13].substring(0).replace('\r','');
var kikkake = ary[14].substring(0).replace('\r','');
var syoukai = ary[15].substring(0).replace('\r','');
var kyouyuu = ary[16].substring(0).replace('\r','');
var award = ary[17].substring(0).replace('\r','');
var k1 = ary[21].substring(0).replace('\r','');
var k2 = ary[22].substring(0).replace('\r','');
var k3 = ary[23].substring(0).replace('\r','');
var k4 = ary[24].substring(0).replace('\r','');
var k5 = ary[25].substring(0).replace('\r','');
var k6 = ary[26].substring(0).replace('\r','');
var k7 = ary[27].substring(0).replace('\r','');
var k8 = ary[28].substring(0).replace('\r','');
var k9 = ary[29].substring(0).replace('\r','');
var k10 = ary[30].substring(0).replace('\r','');
var k11 = ary[31].substring(0).replace('\r','');
var k12 = ary[32].substring(0).replace('\r','');
var k13 = ary[33].substring(0).replace('\r','');
var k14 = ary[34].substring(0).replace('\r','');
var k15 = ary[35].substring(0).replace('\r','');
var k16 = ary[36].substring(0).replace('\r','');
var k17 = ary[37].substring(0).replace('\r','');
var k18 = ary[38].substring(0).replace('\r','');
var k19 = ary[39].substring(0).replace('\r','');
var k20 = ary[40].substring(0).replace('\r','');
var k21 = ary[41].substring(0).replace('\r','');
var k22 = ary[42].substring(0).replace('\r','');
var k23 = ary[43].substring(0).replace('\r','');
var k24 = ary[44].substring(0).replace('\r','');
var k25 = ary[45].substring(0).replace('\r','');
var k26 = ary[46].substring(0).replace('\r','');
var k27 = ary[47].substring(0).replace('\r','');
var k28 = ary[48].substring(0).replace('\r','');
var k29 = ary[49].substring(0).replace('\r','');
var k30 = ary[50].substring(0).replace('\r','');
var k31 = ary[51].substring(0).replace('\r','');
var k32 = ary[52].substring(0).replace('\r','');
var k33 = ary[53].substring(0).replace('\r','');
var k34 = ary[54].substring(0).replace('\r','');
var k35 = ary[55].substring(0).replace('\r','');
var k36 = ary[56].substring(0).replace('\r','');
var k37 = ary[57].substring(0).replace('\r','');
var k38 = ary[58].substring(0).replace('\r','');
var k39 = ary[59].substring(0).replace('\r','');
var k40 = ary[60].substring(0).replace('\r','');
var k41 = ary[61].substring(0).replace('\r','');
var k42 = ary[62].substring(0).replace('\r','');
var k43 = ary[63].substring(0).replace('\r','');
var k44 = ary[64].substring(0).replace('\r','');
var k45 = ary[65].substring(0).replace('\r','');
var k46 = ary[66].substring(0).replace('\r','');
var k47 = ary[67].substring(0).replace('\r','');
var k48 = ary[68].substring(0).replace('\r','');
var k49 = ary[69].substring(0).replace('\r','');
var k50 = ary[70].substring(0).replace('\r','');
var k51 = ary[71].substring(0).replace('\r','');
var k52 = ary[72].substring(0).replace('\r','');
var k53 = ary[73].substring(0).replace('\r','');
var k54 = ary[74].substring(0).replace('\r','');
var k55 = ary[75].substring(0).replace('\r','');
var k56 = ary[76].substring(0).replace('\r','');
var k57 = ary[77].substring(0).replace('\r','');
var k58 = ary[78].substring(0).replace('\r','');
var k59 = ary[79].substring(0).replace('\r','');
var k60 = ary[80].substring(0).replace('\r','');
var k61 = ary[81].substring(0).replace('\r','');
var k62 = ary[82].substring(0).replace('\r','');
var k63 = ary[82].substring(0).replace('\r','');
var k64 = ary[84].substring(0).replace('\r','');
var k65 = ary[85].substring(0).replace('\r','');
var k66 = ary[86].substring(0).replace('\r','');
var k67 = ary[87].substring(0).replace('\r','');
var k68 = ary[88].substring(0).replace('\r','');
var k69 = ary[89].substring(0).replace('\r','');
var k70 = ary[90].substring(0).replace('\r','');
sheet.getRange(row,1).setValue(date);
sheet.getRange(row,2).setValue(kaisyamei);
sheet.getRange(row,3).setValue(tantou);
sheet.getRange(row,4).setValue(busyo);
sheet.getRange(row,5).setValue(yakusyoku);
sheet.getRange(row,6).setValue(mail);
sheet.getRange(row,7).setValue(tel);
sheet.getRange(row,8).setValue(zyusyo);
sheet.getRange(row,9).setValue(gyousyu);
sheet.getRange(row,10).setValue(zyugyoin);
sheet.getRange(row,11).setValue(uriage);
sheet.getRange(row,12).setValue(url);
sheet.getRange(row,13).setValue(kikkake);
sheet.getRange(row,14).setValue(syoukai);
sheet.getRange(row,15).setValue(kyouyuu);
sheet.getRange(row,16).setValue(award);
sheet.getRange(row,17).setValue(k1);
sheet.getRange(row,18).setValue(k2);
sheet.getRange(row,19).setValue(k3);
sheet.getRange(row,20).setValue(k4);
sheet.getRange(row,21).setValue(k5);
sheet.getRange(row,22).setValue(k6);
sheet.getRange(row,23).setValue(k7);
sheet.getRange(row,24).setValue(k8);
sheet.getRange(row,25).setValue(k9);
sheet.getRange(row,26).setValue(k10);
sheet.getRange(row,27).setValue(k11);
sheet.getRange(row,28).setValue(k12);
sheet.getRange(row,29).setValue(k13);
sheet.getRange(row,30).setValue(k14);
sheet.getRange(row,31).setValue(k15);
sheet.getRange(row,32).setValue(k16);
sheet.getRange(row,33).setValue(k17);
sheet.getRange(row,34).setValue(k18);
sheet.getRange(row,35).setValue(k19);
sheet.getRange(row,36).setValue(k20);
sheet.getRange(row,37).setValue(k21);
sheet.getRange(row,38).setValue(k22);
sheet.getRange(row,39).setValue(k23);
sheet.getRange(row,40).setValue(k24);
sheet.getRange(row,41).setValue(k25);
sheet.getRange(row,42).setValue(k26);
sheet.getRange(row,43).setValue(k27);
sheet.getRange(row,44).setValue(k28);
sheet.getRange(row,45).setValue(k29);
sheet.getRange(row,46).setValue(k30);
sheet.getRange(row,47).setValue(k31);
sheet.getRange(row,48).setValue(k32);
sheet.getRange(row,49).setValue(k33);
sheet.getRange(row,50).setValue(k34);
sheet.getRange(row,51).setValue(k35);
sheet.getRange(row,52).setValue(k36);
sheet.getRange(row,53).setValue(k37);
sheet.getRange(row,54).setValue(k38);
sheet.getRange(row,55).setValue(k39);
sheet.getRange(row,56).setValue(k40);
sheet.getRange(row,57).setValue(k41);
sheet.getRange(row,58).setValue(k42);
sheet.getRange(row,59).setValue(k43);
sheet.getRange(row,60).setValue(k44);
sheet.getRange(row,61).setValue(k45);
sheet.getRange(row,62).setValue(k46);
sheet.getRange(row,63).setValue(k47);
sheet.getRange(row,64).setValue(k48);
sheet.getRange(row,65).setValue(k49);
sheet.getRange(row,66).setValue(k50);
sheet.getRange(row,67).setValue(k51);
sheet.getRange(row,68).setValue(k52);
sheet.getRange(row,69).setValue(k53);
sheet.getRange(row,70).setValue(k54);
sheet.getRange(row,71).setValue(k55);
sheet.getRange(row,72).setValue(k56);
sheet.getRange(row,73).setValue(k57);
sheet.getRange(row,74).setValue(k58);
sheet.getRange(row,75).setValue(k59);
sheet.getRange(row,76).setValue(k60);
sheet.getRange(row,77).setValue(k61);
sheet.getRange(row,78).setValue(k62);
sheet.getRange(row,79).setValue(k63);
sheet.getRange(row,80).setValue(k64);
sheet.getRange(row,81).setValue(k65);
sheet.getRange(row,82).setValue(k66);
sheet.getRange(row,83).setValue(k67);
sheet.getRange(row,84).setValue(k68);
sheet.getRange(row,85).setValue(k69);
sheet.getRange(row,86).setValue(k70);
row++;
}
}
var range = sheet.getRange("A:CG");
range.sort({column: 1, ascending: true});
}