// creates the label @FOO and logs label: FOO
Logger.log("label: " + GmailApp.createLabel("FOO"));

// have to get the label by name first
var label = GmailApp.getUserLabelByName("FOO");
GmailApp.deleteLabel(label);

// get all chat threads (max of 500)
var threads = GmailApp.getChatThreads();
Logger.log("# of chat threads: " + threads.length);

// get first 50 chat threads
var threads = GmailApp.getChatThreads(0,50);
// will log no more than 50.0
Logger.log(threads.length);
Logger.log(threads[0].getFirstMessageSubject()); 

// Log the subject lines of your inbox
var threads = GmailApp.getInboxThreads();
for (var i = 0; i < threads.length; i++) {
  Logger.log(threads[i].getFirstMessageSubject());
}

// Log the subject lines of up to the first 50 emails in your inbox
var threads = GmailApp.getInboxThreads(0, 50);
for (var i = 0; i < threads.length; i++) {
  Logger.log(threads[i].getFirstMessageSubject());
}

Logger.log("Messages unread in inbox: " + GmailApp.getInboxUnreadCount());

// get the first message in the first thread of your inbox
var message = GmailApp.getInboxThreads(0, 1)[0].getMessages()[0];
// get it's id
var messageId = message.getId();
// now fetch the same message by that id
var messageById = GmailApp.getMessageById(messageId); 
// should always log true as they should be the same message
Logger.log(message.getSubject() == messageById.getSubject());

// Log all the subject lines in the first thread of your inbox
var thread = GmailApp.getInboxThreads(0, 1)[0];
var messages = GmailApp.getMessagesForThread(thread);
for (var i = 0 ; i < messages.length; i++) {
  Logger.log("subject: " + messages[i].getSubject());
}

// Log the subject lines of all messages in the first two threads of your inbox
var thread = GmailApp.getInboxThreads(0, 2);
var messages = GmailApp.getMessagesForThreads(thread);
for (var i = 0 ; i < messages.length; i++) {
  for (var j = 0; j < messages[i].length; j++) {
    Logger.log("subject: " + messages[i][j].getSubject());
  }
}

Logger.log("# of messages in your priority inbox " + GmailApp.getPriorityInboxThreads().length);

// will log some number 2 or less
Logger.log("# of messages in your priority inbox " + GmailApp.getPriorityInboxThreads(0, 2).length);

Logger.log("Number of unread emails in your priority inbox : " + GmailApp.getPriorityInboxUnreadCount());

// logs the number of starred threads
Logger.log("# Starred threads: " + GmailApp.getStarredThreads().length);

// logs the number of starred threads to a maximum of 5
Logger.log("# Starred threads: " + GmailApp.getStarredThreads(0, 5).length);

Logger.log("# unread and starred: " + GmailApp.getStarredUnreadCount());

Logger.log("# of total spam threads: " + GmailApp.getSpamThreads().length);

// will log a number at most 5
Logger.log("# of total spam threads: " + GmailApp.getSpamThreads(0, 5).length);

//実際にスパムフォルダで何かを読んでいない限り、
//これは迷惑メールフォルダ内の＃メッセージと同じです

Logger.log("# unread and spam: " + GmailApp.getStarredUnreadCount());

// thread ids can also be found in the location bar when you have a thread open in gmail
// get first inbox thread
var firstThread = GmailApp.getInboxThreads(0,1)[0];
// get the same thread by id
var threadById = GmailApp.getThreadById(firstThread.getId());
// verify they are the same
Logger.log(firstThread.getFirstMessageSubject() == threadById.getFirstMessageSubject());

Logger.log("# of total trash threads: " + GmailApp.getTrashThreads().length);

// will log a number at most 5
Logger.log("# of total trash threads: " + GmailApp.getTrashThreads(0, 5).length);

var labelObject = GmailApp.getUserLabelByName("myLabel");

// logs all of the names of your labels
var labels = GmailApp.getUserLabels();
for (var i = 0; i < labels.length; i++) {
  Logger.log("label: " + labels[i].getName());
}

// mark the first message in the first thread of your inbox as read
var message = GmailApp.getInboxThreads(0, 1)[0].getMessages()[0];
GmailApp.markMessageRead(message);

// mark the first message in the first thread of your inbox as unread
var message = GmailApp.getInboxThreads(0, 1)[0].getMessages()[0];
GmailApp.markMessageUnread(message);

// mark first three messages in the first inbox thread as read
// assumes that the first inbox thread has 3 messages in it
var threadMessages = GmailApp.getInboxThreads(0, 1)[0].getMessages();
var messages = [threadMessages[0], threadMessages[1], threadMessages[2]];
GmailApp.markMessagesRead(thread.getMessages());

// mark first three messages in the first inbox thread as unread
// assumes that the first inbox thread has 3 messages in it
var threadMessages = GmailApp.getInboxThreads(0, 1)[0].getMessages();
var messages = [threadMessages[0], threadMessages[1], threadMessages[2]];
GmailApp.markMessagesUnread(thread.getMessages());

// Marks first two threads in inbox as important
var threads = GmailApp.getInboxThreads(0, 2);
GmailApp.markThreadsImportant(threads);

// Marks first two threads in inbox as unimportant
var threads = GmailApp.getInboxThreads(0, 2);
GmailApp.markThreadsUnimportant(threads);

// marks first inbox thread as read
var thread = GmailApp.getInboxThreads(0, 1)[0];
GmailApp.markThreadRead(thread);

// marks first inbox thread as unread
var thread = GmailApp.getInboxThreads(0, 1)[0];
GmailApp.markThreadUnread(thread);

// Marks first two threads in inbox as important
var threads = GmailApp.getInboxThreads(0, 2);
GmailApp.markThreadsImportant(threads);

// Marks first two threads in inbox as unimportant
var threads = GmailApp.getInboxThreads(0, 2);
GmailApp.markThreadsUnimportant(threads);

// Marks first two threads in inbox as read
var threads = GmailApp.getInboxThreads(0, 2);
GmailApp.markThreadsRead(threads);

// Marks first two threads in inbox as unread
var threads = GmailApp.getInboxThreads(0, 2);
GmailApp.markThreadsUnread(threads);

// move the first message in your inbox to trash
var firstThread = GmailApp.getInboxThreads(0,1)[0];
var firstMessage = firstThread.getMessages()[0];
GmailApp.moveMessageToTrash(firstMessage);

// move first two messages in your inbox to trash
var firstThread = GmailApp.getInboxThreads(0,1)[0];
var messages = firstThread.getMessages();
var toDelete = [messages[0], messages[1]];
GmailApp.moveMessagesToTrash(toDelete);

// archive first inbox thread
var firstThread = GmailApp.getInboxThreads(0,1)[0];
GmailApp.moveThreadToArchive(firstThread);

// find a thread not already in your inbox
var thread = GmailApp.search("-in:inbox")[0]; // get the first one
GmailApp.moveThreadToInbox(thread);

// tag first thread in inbox as spam
var firstThread = GmailApp.getInboxThreads(0,1)[0];
GmailApp.moveThreadToSpam(firstThread);

// move first thread in inbox to trash
var firstThread = GmailApp.getInboxThreads(0,1)[0];
GmailApp.moveThreadToTrash(firstThread);

// archive first two threads in your inbox
var firstTwoThreads = GmailApp.getInboxThreads(0,2);
GmailApp.moveThreadsToArchive(firstTwoThreads);

// find two threads not already in your inbox
var threads = GmailApp.search("-in:inbox", 0, 2)[0]; // get the first ones
GmailApp.moveThreadsToInbox(thread);

// mark first two threads in your inbox as spam
var firstTwoThreads = GmailApp.getInboxThreads(0,2);
GmailApp.moveThreadsToSpam(firstTwoThreads);

// move first two threads in your inbox to trash
var firstTwoThreads = GmailApp.getInboxThreads(0,2);
GmailApp.moveThreadsToTrash(firstTwoThreads);

var firstThread = GmailApp.getInboxThreads(0,1)[0];
var firstMessage = firstThread.getMessages()[0];
// ...do something that may take a while here....
GmailApp.refreshMessage(firstMessage);
// ...do more stuff with firstMessage...

var firstThread = GmailApp.getInboxThreads(0,1)[0];
var coupleOfMessages = firstThread.getMessages().slice(0, 2);
// ...do something that may take a while here....
GmailApp.refreshMessages(coupleOfMessages);
// ...do more stuff with coupleOfMessages...

var firstThread = GmailApp.getInboxThreads(0,1)[0];
// ...do something that may take a while here....
GmailApp.refreshThread(firstThread);
// ... do more stuff with the thread ...

var threads = GmailApp.getInboxThreads(0, 3);
// ...do something that may take a while here....
GmailApp.refreshThreads(threads);
// ... do more stuff with threads ...

// find starred messages with subject IMPORTANT
var threads = GmailApp.search('is:starred subject:"IMPORTANT"');

// find starred messages with subject IMPORTANT and return second batch of 10
// assumes there are at least 11 of them, otherwise this will return an empty array.
var threads = GmailApp.search('is:starred subject:"IMPORTANT"', 10, 10);

// The code below will email the topleft cell in the active range to another user
var value = SpreadsheetApp.getActiveRange().getValue();
MailApp.sendEmail("mikemike@gmail.com", "value of a cell", "here it is: " + value);

var myFiles = [{fileName:"my_document.html", content:"Insert any HTML content here"}]
MailApp.sendEmail("mikemike@gmail.com", "Attachment example", "Here is my document", {attachments: myFiles});

//メール配信が成功した場合はC列に書き込まれる
var EMAIL_SENT = "送信完了";

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2;  // 処理すべき最初の行データ
  var numRows = 3;   // 処理すべき行数

  // A2:B4のセル範囲を取得
  var dataRange = sheet.getRange(startRow, 1, numRows, 3)

     // 範囲の各行から値を取得
  var data = dataRange.getValues();
  
  for (var i = 0; i < data.length; ++i) {
    var row = data[i];
    var emailAddress = row[0];  // １番目の列 メールアドレス
    var message = row[1];       // ２番目の列 メッセージ
    var emailSent = row[2];     // ３番目の列 送信済コメント

    if (emailSent != EMAIL_SENT) {  // 重複を防ぐ
      var subject = "sendEmailsテスト";
      MailApp.sendEmail(emailAddress, subject, message);
      sheet.getRange(startRow + i, 3).setValue(EMAIL_SENT);
      // スクリプトが中断された場合、直ちにセルの更新を確認
      SpreadsheetApp.flush();  
    }
  }
}

function sendValue(){

//アクティブにしたセル内の値が送信される
var value = SpreadsheetApp.getActiveRange().getValue();
MailApp.sendEmail("sample@gmail.com", "値の送信", "これが値です: " + value);
}

//HTMLファイルを添付する
function Attachment(){
var myFiles = [{fileName:"my_document.html", content:"ここにHTMLにしたい内容を書き込みます"}]
MailApp.sendEmail("sample@gmail.com", "添付ファイルの見本", "添付ファルです", {attachments: myFiles});

function inlineImage() {
  var googleLogoBlob = UrlFetchApp.fetch(
  "http://www.google.com/intl/en_com/images/srpr/logo3w.png").getBlob().setName("googleLogoBlob");
  var youtTubeLogoBlob = UrlFetchApp.fetch(
  "http://s.ytimg.com/yt/img/logos/youtube_logo_standard_againstwhite-vflKoO81_.png").getBlob().setName("youtTubeLogoBlob");

  MailApp.sendEmail(
    "sg.appsscript@gmail.com",
    "Logos",
    "", 
    { htmlBody: 
         "inline Google Logo images! 
 inline YouTube Logo ",
     inlineImages: 
         { googleLogo: googleLogoBlob,
           youTubeLogo:youtTubeLogoBlob
          }
    }
    
    );
}

// Stars the first message in the first thread in your inbox
var firstThread = GmailApp.getInboxThreads(0,1)[0];
var message = firstThread.getMessages()[0];
GmailApp.starMessage(message);

// Stars the first three messages in the first thread in your inbox
var firstThread = GmailApp.getInboxThreads(0,1)[0];
var coupleOfMessages = firstThread.getMessages().slice(0, 3);
GmailApp.starMessages(coupleOfMessages);

// Stars the first three messages in the first thread in your inbox
var firstThread = GmailApp.getInboxThreads(0,1)[0];
var coupleOfMessages = firstThread.getMessages().slice(0, 3);
GmailApp.starMessages(coupleOfMessages);

// unstars the first three messages in the first thread in your inbox
var firstThread = GmailApp.getInboxThreads(0,1)[0];
var coupleOfMessages = firstThread.getMessages().slice(0, 3);
GmailApp.unstarMessages(coupleOfMessages);