如何从gmail获取主题并将其放入Google文档或电子表格中 [英] How to get subject from gmail and put into a google doc or spreadsheet

问题描述

我试图自动将主题行提取到Google文档或电子表格。我找到了一个基本的例子，但不知道如何做这个工作。


$ $ p $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $变量线程= GmailApp.getInboxThreads（）;
for（var i = 0; i< threads.length; i ++）{
//获取给定线程中的所有消息
var messages = threads [i] .getMessages（）;
//遍历每条消息
for（var j = 0; j< messages.length; j ++）{
// log message subject
Logger.log（messages [ j]的.getSubject（））;

解决方案

这是Javascript，而不是Java。上面的脚本将所有消息收集到一个列表中，这是第一步，但它不会写入表单。

之后，您需要添加一个额外的功能写出来。如果你在电子表格中，你可以使用这样的东西。我已经修改了上述函数，将主题放入数组中，而不是将它们记录到控制台中，并让它返回该数组。 $ c> function processInbox（）{
var threads = GmailApp.getInboxThreads（）;
var subjects = [[]];

for（var i = 0; i< threads.length; i ++）{

var messages = threads [i] .getMessages（）; （var j = 0; j< message.length; j ++）{

subject [j] = [messages [j] .getSubject（）]的

;
}
}

返回科目;
}

函数writeOutSubjects（）{

var ss = SpreadsheetApp.getActiveSpreadsheet（）;
var sheet = ss.getSheets（）[0];

var subjects = processInbox（）;
var range = sheet.getRange（1,1，subjects.length，1）;

range.setValues（科目）;

};

I am trying to automatically extract subject lines to a Google doc or spreadsheet. I found a basic example but don't know how to make this work.

function processInbox() {
    // get all threads in inbox
    var threads = GmailApp.getInboxThreads();
    for (var i = 0; i < threads.length; i++) {
        // get all messages in a given thread
        var messages = threads[i].getMessages();
        // iterate over each message
        for (var j = 0; j < messages.length; j++) {
            // log message subject
            Logger.log(messages[j].getSubject());
        }
    }
}

解决方案

This is Javascript, not Java. The script above gathers all your messages into a list, which is the right first step, but it won't write it to the sheet.

After that you'll need to add an additional function to write it out. If you're in a spreadsheet, you could use something like this. I've modified the above function to put the subjects into an array instead of logging them into the console, and having it return that array.

function processInbox() {
    var threads = GmailApp.getInboxThreads();
    var subjects = [[]];    

    for (var i = 0; i < threads.length; i++) {

        var messages = threads[i].getMessages();

        for (var j = 0; j < messages.length; j++) {

            subjects[j] = [messages[j].getSubject()];
        }
    }

    return subjects;
}

function writeOutSubjects() {

    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getSheets()[0];

    var subjects = processInbox();
    var range = sheet.getRange(1,1,subjects.length,1);

    range.setValues(subjects);

};

这篇关于如何从gmail获取主题并将其放入Google文档或电子表格中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！