freks blog

function saveGoogleWorkspaceReceipt() {
  var searchQuery = 'from:[email protected] subject:Google Workspace: is:unread';  // unreadで未開封のもの
  var threads = GmailApp.search(searchQuery);
  var folderId = '<folder id>'; // https://drive.google.com/drive/folders/<folder id>
  var folder = DriveApp.getFolderById(folderId);

  var now = new Date();
  var year = now.getFullYear();
  var month = now.getMonth();
  if (month == 0) {
    month = 12;
    year--;
  }
  var filename = year.toString() + ('0' + month).slice(-2) + '.pdf'; // 先月の年月.pdf

  for (var i = 0; i < threads.length; i++) {
    var messages = threads[i].getMessages();

    for (var j = 0; j < messages.length; j++) {
      var attachments = messages[j].getAttachments();

      for (var k = 0; k < attachments.length; k++) {
        var blob = attachments[k].copyBlob();
        blob.setName(filename);
        var file = folder.createFile(blob);
        Logger.log('Created File: ' + file.getUrl());
      }
    }
  }
}