LINEã§äœæž©ð¡ãèšé²ããããäœã
LINEïŒå
¬åŒã¢ã«ãŠã³ãïŒã䜿ã£ãŠãæ¯æ¥ã®äœæž©ãèšé²ãããããã°ã©ã ãäœããŸããã
ããããããã£ãããããããšåŒã°ããŠãã代ç©ã
ãããªæã â
ããã°ã©ã ãšèšã£ãŠãããããªå€§ä»°ãªãã®ã§ã¯ãªããGoogle ã¹ãã¬ããã·ãŒãã§äœã£ãã ããªãã§ããã©ãã
Google ã¹ãã¬ããã·ãŒãã«ä»éããŠãã¹ã¯ãªãããGoogle Apps Script â»ã䜿ã£ãŠã
ã»
äœæž©èšé² LINE ã®æ©èœã¯ã
â äœæž©ãå
¥åãããèšé²ãã
â 2é±éåïŒ14æ¥åïŒã®ããŒã¿ã衚瀺ãã
â ã¢ã©ãŒã ãèšå®ããæå»ã«éç¥ãæ¥ã
ã ãã§ããã·ã³ãã«ã€ãºãã¹ãã
èšé²ããäœæž©ããŒã¿ã®å€æŽã»åé€ã«ã€ããŠã¯ã
å
垳㮠Google ã¹ãã¬ããã·ãŒãã§ãã£ãŠãâ¡âŠâŠãšèšãæãã§ã
åŠçãç
©éã«ãªãã®ã§åãå
¥ããŸããã§ããã
ïŒâ» Google Apps ScriptïŒãGoogleã®ãµãŒãã¹ãèªååããã¹ã¯ãªããèšèªãã ããã§ããç¥ç§° GASãïŒ
ãã ãã䜿ãã®ïŒã
ãåºã家æã§äœ¿ããããšæã£ãŠã
äœæž©èšé²ããŠããã°ãäœãã®ãšãã«ãåŠæ ¡ãæ©é¢ãžããæåºã§ããŸãããã
ãµããšç¢ºèªã§ããããã«ããŸããããããªãµãã« â
èšå®ããæéïŒæïŒïŒã«ãªããš LINE ã«éç¥ãæ¥ãã¢ã©ãŒã æ©èœããã£ã€ããã®ã§ãèšé²æŒããæžãã§ãããã
ã»
å®ã¯ãããããšããšã売äžãèšé²ããããã°ã©ã ãã ã£ããã§ããã
æ¯æ¥ãExcel ã«ããŒã¿ïŒå£²äžã客æ°ïŒãå ¥åããã®ãã¡ã³ãããããšãã声ããã£ãŠã
PCèµ·ã¡äžã â Excel èµ·ã¡äžã â ãã¡ã€ã«éã㊠â ä»æ¥ã®æ¥ä»ãæ¢ããŠããŒã¿å
¥åã
確ãã«é¢åãããã
ãªãã
LINE ã§ãä»æ¥ã®å£²äžããŒã¿ããå
¥åããã°è¯ããããïŒâŠâŠãšã
ããŒã¿ã¯ Google ã¹ãã¬ããã·ãŒãã«èç©ãããŠããã®ã§ãèšé²ã®ã³ãããã°ã©ãåãç°¡åããã¡ãâª
ãšãããçµå±ããã®å£²äžèšé² LINE ã¯ããã«ãªããŸããŠããHaHaHa
æšãŠãŠããŸãã®ããªãã ããäœæž©èšé² LINE ã«æžãæãã次第ã
ããŠã
ãLINE å ¬åŒã¢ã«ãŠã³ãã»ãªããã¡ãã¥ãŒã®èšå®ã
ãŸãã¯ãLINE å ¬åŒã¢ã«ãŠã³ããã®äœæã
⌠LINEå
¬åŒã¢ã«ãŠã³ãã®éèš
https://www.linebiz.com/jp/entry/
ããéèšã§ããã
ããããâ
ãLINE Official Account Managerãã«ãã°ã€ã³ããç¶æ ã§ããªããã¡ãã¥ãŒã®ç·šéç»é¢ãžã
ããããŒã > ããŒã¯ã«ãŒã 管ç > ãªããã¡ãã¥ãŒ
â ã¿ã€ãã«ãã¯ãªãã¯ãïŒæ°èŠã®å Žåã¯ãäœæããã¯ãªãã¯ïŒ
â¡ ããã³ãã¬ãŒããéžæãã§ãå°ã»3ã€ãã¿ã³ãéžæã
⢠ãèæ¯ç»åãã¢ããããŒããã§ãã¡ãã¥ãŒãã¿ã³ã®ç»åãã¢ããããŒãã
ã¡ãã¥ãŒç»åã®ãã¶ã€ã³ã¯ã奜ã¿ã§ãããããäœã£ããã¿ã³ã¯ãããªæãâ
ïŒç»åãµã€ãºïŒ1200 à 405pxïŒ
â£ãã¢ã¯ã·ã§ã³ãã«ããã¿ã³ãã¿ããããæã®ã¢ã¯ã·ã§ã³ãç»é²ã
ãã¿ã³ABCã®ã¿ã€ãã¯ãã¹ãŠãããã¹ããã«ããŠã
ãAã/menuã
ãBã/alarmã
ãCã/contactã
ãå
¥åããŠãããŸãã
ïŒãããã¯ã¹ã¯ãªããã«æž¡ãã³ãã³ãã§ãïŒ
ãä¿åããã¯ãªãã¯ããŠå®äºã
ãªããã¡ãã¥ãŒã®ã§ããããã
ãLINE ã® Messaging APIã
LINE å
¬åŒã¢ã«ãŠã³ãã§ãã¡ãã»ãŒãžã®ãããšããããã«ã¯ãã¢ã¯ã»ã¹ããŒã¯ã³ããšåŒã°ãã IDïŒã®ãããªãã®ïŒãå¿
èŠã§ãã
â» ååŸããã®ã¯ããã£ãã«ã¢ã¯ã»ã¹ããŒã¯ã³ïŒé·æïŒãã
管çè åãããŒãžã§ååŸããŸãããããã¡ãâ
詳ãã㯠@njn0te ããã®åç»ãåèã«ã
ãã£ã¡ãæåŸãŸã§èŠèŽããããã§ã¯ãªãã§ããïŒ2æéãããŸããããïŒããããäžå¯§ã«èª¬æãããŠããŸãããããã§ãããåç»ã§åŠã¹ãã£ãŠã
ãGoogle ã¹ãã¬ããã·ãŒãã®åæèšå®ã
ããŠãã次ã¯ã¹ãã¬ããã·ãŒãã®äœæã§ãã
ãã¡ã€ã«ãæ°èŠäœæåŸãã·ãŒãã4ã€æºåãããããããtotalããrecordããfaqããlogããšããŠãã ãâŠâŠ
âŠâŠãšèª¬æãããããããµã³ãã«ãè€è£œããŠããã£ãã»ããæ©ãã§ããã
ãã¡ããããã¡ã€ã«ãã³ããŒããŠãã ãããâ
ãð¡ äœæž©èšé²ãã³ãã¬ãŒãïŒã³ããŒããŠå©çšããŠãã ããïŒã
â» èŠ Google ã¢ã«ãŠã³ãã§ãã°ã€ã³ã
ãGAS ( Google Apps Script ) ã®ã³ãŒãã
ã€ã¥ããŠããã¹ã¯ãªãã ãšãã£ã¿ããèµ·åãããŸãã
ã§ãããã«ããã°ã©ã ïŒã¹ã¯ãªããïŒãèšè¿°ããããã§ããããªãã®ããã®ãš 1500 è¡ããããã£ãã®ã§æžãå§ãã®éšåã ãå ¬éããŠãããŸãã
note ã«å
šææ²èŒããŠã鬱é¶ããã§ãããããã
ïŒæ¬²ããïŒãšãã人ãããããã©ããã«æ²èŒããŸãð ïŒ
æåã® 100 è¡ã¯ãããªæã â
const BOTNAME="\ð¡ äœæž©èšé²åž³";
const CONTACT_URL="http://lin.ee/p0zqFRP";// é£çµ¡å
ã¢ãã¬ã¹
const MAILTO="xxxxxxx@xxxxxxx.jp";// éç¥å
ã¢ãã¬ã¹èšå®
// ================;
// LINE API ã¢ã¯ã»ã¹ããŒã¯ã³èšå®
const LINE_TOKEN="xxxxxxxxxxxxxxxxxxxxxxxxxxxx";
// Google ã¹ãã¬ããã·ãŒãèšå®ãã·ãŒãã¯ãããããã¯äœã£ãŠããããš
// https://docs.google.com/spreadsheets/d/<SS_ID>/
const SS_ID="xxxxxxxxxxxxxxxxxxxxxxxxxxxx";
const SHEET_RECORD="record";
const SHEET_TOTAL="total";
const SHEET_FAQ="faq";
const SHEET_LOG="log";
// éç¥èšå®
const NOTIFICATION_MAIL=0;// ã¡ãŒã«éç¥ãåããå Žåã¯1ã« (default: 0)
const NOTIFICATION_LINE=1;// LINE éç¥ãåããå Žåã¯1ã« (default: 0)
// 確èªæã®è¡šç€ºæ¥æ°
const VIEW_DAYS=14;
// ãã¿ã³ã®èšå®
var actKwd={};
actKwd.A="/menu";//ãªããã¡ãã¥ãŒAïŒã¡ãã¥ãŒ
actKwd.B="/alarm";//ãªããã¡ãã¥ãŒBïŒéç¥
actKwd.C="/contact";//ãªããã¡ãã¥ãŒCïŒé£çµ¡
actKwd.A1="/input";//å
¥å
actKwd.A2="/check";//確èª
actKwd.A3="/edit";//å€æŽ
actKwd.B1="/activate";//ã¢ã©ãŒã ïŒæå¹
actKwd.B2="/disable";//ã¢ã©ãŒã ïŒè§£é€
const btnColor="#554466";
// éžæãã¿ã³èšå®
var btnWords={};
btnWords.menuA=[
["ããŒã¿å
¥å \âïž",actKwd.A1],
["èšé²ã®ç¢ºèª \ð",actKwd.A2],
["å€æŽã»åé€ \ð",actKwd.A3],
];
btnWords.menuB=[
["éç¥ïŒã¢ã©ãŒã ïŒãèšå® \ð",actKwd.B1],
["éç¥ã®è§£é€ \ð",actKwd.B2],
//["No","thx"],
];
btnWords.confirm=[
["OKã確å®ãã","/ok"],
["ãã£ã³ã»ã«","/cxl"],//åå
¥å
];
btnWords.confirmB=[
["ãã£ã³ã»ã«ãã","/cxl"],
["ãããããã®ãŸãŸã§","/keep"],
];
//================================//
// !â åŠçã®æ¬é
//================================//
function doGet(e){
return ContentService.createTextOutput("Hello!");
}
function doPost(e){
if(typeof e==undefined)return;
try{
main(e);
}
catch(error){
logging(JSON.stringify(e));
logging(JSON.stringify(error));
var replyToken=JSON.parse(e.postData.contents).events[0].replyToken;
return replyMess(replyToken,{"type":"text","text":error.message});
}
}
function main(e){
// Google ã¹ãã¬ããã·ãŒãèšå®
var SSfile=SpreadsheetApp.openById(SS_ID);
var SSl=SSfile.getSheetByName(SHEET_LOG);
// LINE ããã®ããŒã¿æŽç
var json=JSON.parse(e.postData.contents);
var event=json.events[0];
var repToken=event.replyToken;
var type=event.type;
var chatId=getChatId(json);
var displayName=getDisplayName(chatId);
if(type==="message"){
var message=event.message.text;
var pbParams=null;
}
else if(type==="postback"){
var message=event.postback.data;
var pbParams=event.postback.params;
}
// ================;
// æé(d)ã»ãã©ã³ã¶ã¯ã·ã§ã³IDçæ
var d=new Date();
var dt=Utilities.formatDate(d,"JST","yyyy/MM/dd HH:mm:ss");
var ts=~~(d/1000);
var QID=MD5(chatId+ts);
// ãã£ãã·ã¥èšå®
var cache=makeCache(600);
// ãã©ã°èšå®
var FLG=(cache.get(chatId+".FLG"))?cache.get(chatId+".FLG"):cache.put(chatId+".FLG",null);// ãã©ã°
var SID=(cache.get(chatId+".SID"))?cache.get(chatId+".SID"):cache.put(chatId+".SID",null);// ã»ãã·ã§ã³ID
if(!SID)cache.put(chatId+".SID",QID);
var RID=(cache.get(chatId+".RID"))?cache.get(chatId+".RID"):cache.put(chatId+".RID",null);// 泚æID
var SEQa=(cache.get(chatId+".SEQa"))?cache.get(chatId+".SEQa"):cache.put(chatId+".SEQa",0);// ã·ãŒã±ã³ã¹çªå·(Aã©ã€ã³)
var SEQb=(cache.get(chatId+".SEQb"))?cache.get(chatId+".SEQb"):cache.put(chatId+".SEQb",0);// ã·ãŒã±ã³ã¹çªå·(Bã©ã€ã³)
// ãã°
SSl.appendRow(["'"+QID,dt,chatId,displayName,"'"+message,FLG,SID,RID,SEQa,SEQb,"EOR"]);
// LINEéç¥ïŒãããå Žåã¯ã³ã¡ã³ãã¢ãŠããå€ããŠïŒ
// notifyMess(LINE_NOTIFY_TOKEN,QID+"\n\n"+displayName+"\n"+message+"\n\n"+FLG+", "+SID+", "+RID+", "+SEQa+", "+SEQb);
// ã¡ãã¥ãŒæèšèšå®
var strM="[MENU]\nã³ãã³ããéžæããŠãã ãã";
var strA1="ããŒã¿ãéä¿¡ããŠãã ãã\n\nâ»æ°åã®ã¿ã§ãå°æ°ç¹äžèŠ";//\nâ»èšå·ã¯èªååé€ããŸãã\nâ»å
šè§åè§ã¯åããŸããã
var strB1="éç¥ïŒã¢ã©ãŒã ïŒãèšå®ããŸã";
/*
*
* //!âœã¡ã€ã³ã·ãŒã±ã³ã¹ââââââââ
*
*/
var messArr=[];
ããããã»
ããããã»
ããããã»
ããããã»
ããããã»
ããããã»
ãLINE éç¥ã®ããã«ããªã¬ãŒèšå®ãã
ã¹ã¯ãªããã®èšçœ®ãçµãããã
LINE éç¥ïŒã¢ã©ãŒã ïŒã®ããã«ãGAS ã®ããªã¬ãŒèšå®ãããŸãã
èšå®ã¯ä»¥äžã®ããã«ã
1åããã«ã¹ã¯ãªãããèµ·åãããŸãã
GAS ã®ããªã¬ãŒèšå®ã«ã€ããŠè©³ããã¯ã@ntakahashi0505ããã®ããã°èšäºãåèã«ã
â https://tonari-it.com/gas-trigger-set/
LINE ã§ã®ã¢ã©ãŒã èšå®ç»é¢ã¯ãããªæãâ
ãæåã®èšå®ã¯ãããããã£ãŠå€§å€ã ãã©ã
åæèšå®ã¯ä»¥äžã§ãã
解説ãéã«ãªã£ã¡ãããŸããã
ã©ãããã詳ãã説æããã°ããã®ããããŸãèããã«æžãå§ããŠããŸã£ãããã«ããåãããªããªã£ãŠãéäžã§æãæããŸãããð
LINE å
¬åŒã¢ã«ãŠã³ãã®éèšã«å§ãŸã ããã Google Apps Script ã®ã³ãŒãã£ã³ã°ïŒèšå®âŠâŠ
æåã®èšå®ããã£ãããããããã£ãŠãã¡ãã£ãšé¢åã
ä»ããã§ãããnote ã«æžãããšãããªãã£ããªããšãQiita ãã¿ã§ãããããããŸããããªæ¥ãããããã
ã»
ãã£ãã皌åãå§ããããããšã¯ã©ã¯ã§ãã
ä»ãŸã§äœæž©ãçŽã«èšé²ããŠãŸããããèšé²æŒããå€ããç©Žã ããã§ããã
ãã©ãLINE äœæž©èšé²ã䜿ãå§ããŠããã¯æ¯æ¥ã¡ãããšèšé²ã§ããŠãŸããã¢ã©ãŒã æ©èœãäœã£ãŠãããŠããã£ããŒã
â
ãã€ããã±ïŒä»ããèããªãã¢ã€ãã£è¬åº§ãã¯ãã¡ããã
http://fb.com/imakike