Last active
February 26, 2024 10:00
-
-
Save regonn/6221786 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function sendToEvernote() { | |
var evernote_email = "xxxxxxxxx@m.evernote.com"; | |
var note_title = "お問い合わせ @ギルド問い合わせ" //「AAAAAA @BBBBBB」"@BBBBBB"で指定したノートに"AAAAA"というタイトルで追加されます | |
var range = SpreadsheetApp.getActiveRange(); //変更されたセルを取得 | |
var col = range.getColumnIndex(); //変更のあったセルの列を取得 | |
var row = range.getRowIndex(); //変更のあったセルの行を取得 | |
if(col == 7){ | |
reply = range.getValue(); //変更されたステータスの値 | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
var dataRange = sheet.getRange(row,1,1,8); | |
var data = dataRange.getValues(); | |
var message = "タイムスタンプ:" + data[0][0] + "\n" + "お名前:" +data[0][1]+"\n"+"会社名:"+data[0][2]+"\n"+"メールアドレス:"+data[0][3]+"\n"+"電話番号:"+data[0][4]+"\n\n"+"内容:"+data[0][5]+"\n\n"+"返信:"+data[0][6]+"\n\n"+"お客さまの個人情報取り扱い:"+data[0][7]; | |
MailApp.sendEmail(evernote_email, note_title, message); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment