计算每个发件人的 Gmail 电子邮件数量 [英] Count number of Gmail emails per sender
问题描述
我正在尝试对我的 Gmail 进行大规模清理,因为搜索速度太慢了.我想统计一下我从每个发件人那里收到了多少封电子邮件.我找到的最接近的解决方案是:https://webapps.stackexchange.com/questions/102162/can-i-get-a-list-of-the-senders-of-all-of-the-messages-in-my-inbox 但是,它只记录收件箱中的电子邮件,而不是所有邮件.我什至尝试将我所有的 10 万封电子邮件从所有邮件移动到收件箱以便我可以使用它,但 Gmail 似乎不允许您将超过 3,500 封邮件移入.
I'm trying to do a mass cleanout of my Gmail because search has gotten so slow. I would like to tally how many emails i've received from each sender. The closest solution I've found is this: https://webapps.stackexchange.com/questions/102162/can-i-get-a-list-of-the-senders-of-all-of-the-messages-in-my-inbox however that only tallies emails in Inbox, not in All Mail. I even tried moving all my 100k emails from All Mail to Inbox so that I could use it, but Gmail doesn't appear to let you move more than 3,500 messages in.
如何调整 Google Apps 脚本以分析所有邮件而不仅仅是收件箱?或者任何其他方式也欢迎
How do I adjust the Google Apps script to analyze All Mail instead of just Inbox? Or any other way of doing this welcomed too
function sender_list() {
var inbox_threads = GmailApp.getInboxThreads();
var sender_array = [];
for (var i = 0; i < inbox_threads.length; i++) {
var message = inbox_threads[i].getMessages();
for (var x = 0; x < message.length; x++) {
var sender = message[x].getFrom();
sender_array.push([sender]);
}
}
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = spreadsheet.getSheetByName('sheet1');
sheet.clear();
sheet.appendRow(['Email Address']);
sender_array.sort();
sheet.getRange(sheet.getLastRow()+1, 1, sender_array.length,1).setValues(sender_array);
}
推荐答案
这将为您提供一个唯一的发件人列表
This will get you a unique sender list
function sender_list() {
var inbox_threads=GmailApp.search('in:anywhere');
var sender_array=[];
var uA=[];
for(var i=0;i<inbox_threads.length;i++) {
var message=inbox_threads[i].getMessages();
for(var x=0;x<message.length; x++) {
var sender=message[x].getFrom();
//prevent duplicates
if(uA.indexOf(sender)==-1) {
uA.push(sender);
sender_array.push([sender]);
}
}
}
var ss=SpreadsheetApp.getActive();
var sh=ss.getActiveSheet()
sh.clear();
sh.appendRow(['Email Address']);
sh.getRange(2, 1,sender_array.length,1).setValues(sender_array).sort({column:1,ascending:true});
}
这个版本增加了每个发件人的电子邮件数量:
and this version adds the number of emails per sender:
function sender_list() {
var inbox_threads=GmailApp.search('in:anywhere');
var sender_array=[];
var uA=[];
var cObj={};
for(var i=0;i<inbox_threads.length;i++) {
var message=inbox_threads[i].getMessages();
for(var x=0;x<message.length; x++) {
var sender=message[x].getFrom();
if(uA.indexOf(sender)==-1) {
uA.push(sender);
sender_array.push([sender]);
cObj[sender]=1;
}else{
cObj[sender]+=1;
}
}
}
sender_array.forEach(function(r){
r.splice(1,0,cObj[r[0]]);
});
var ss=SpreadsheetApp.getActive();
var sh=ss.getActiveSheet()
sh.clear();
sh.appendRow(['Email Address','Count']);
sh.getRange(2, 1,sender_array.length,2).setValues(sender_array).sort({column:1,ascending:true});
}
我总共有大约 500 封电子邮件.我不存储很多电子邮件,并且在它们到达时丢弃了很多不需要的电子邮件.运行大约需要 20 秒.所以我想 10 万封电子邮件需要你分批运行.
I have about 500 emails total. I don't store a lot of emails and I discard a lot of unwanted emails when they arrive. It took about 20 seconds to run. So I would imagine 100K emails will require you to run this in batches.
以下代码要求启用该 Gmail API.
The following code requires that that Gmail API be enabled.
要进行批处理,您可以先运行此函数:
To do a batch you could run this function to start with:
function sender_list_paged(token) {
var token=token||null;
var query="in:anywhere";
var sender_array=[];
var uA=[]
var cObj={};
do{
var result=Gmail.Users.Messages.list("your gmail address", {maxResults:100,pageToken:token,q:query});
var list=result;
Logger.log(list);
for(var i=0;i<list.messages.length;i++) {
var sender=GmailApp.getMessageById(list.messages[i].id).getFrom();
if(uA.indexOf(sender)==-1) {
uA.push(sender);
sender_array.push([sender]);
cObj[sender]=1;
}else{
cObj[sender]+=1;
}
}
token=list.nextPageToken
PropertiesService.getUserProperties().setProperty("lastpagetoken", token);
}while(token);
sender_array.forEach(function(r){
r.splice(1,0,cObj[r[0]]);
});
var ss=SpreadsheetApp.getActive();
var sh=ss.getActiveSheet()
sh.clear();
sh.appendRow(['Email Address','Count']);
sh.getRange(2, 1,sender_array.length,2).setValues(sender_array).sort({column:1,ascending:true});
}
然后像这样再次运行该函数:
And then run the function again like this:
sender_list_paged(getLastPageToken());
sender_list_paged(getLastPageToken());
function getLastPageToken() {
return PropertiesService.getUserProperties().getProperty("lastpagetoken")
}
我认为这会奏效.但你可能不得不玩它,因为我从来没有这样做过.
And I think that will work. But you may have to play with it as I haven't ever had to do that.
这篇关于计算每个发件人的 Gmail 电子邮件数量的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!