Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // aggiungi menù
- function onOpen() {
- var ui = SpreadsheetApp.getUi();
- ui.createMenu('Estrai Email')
- .addItem('Estrai Indirizzi...', 'estraiIndirizzi')
- .addToUi();
- }
- function estraiIndirizzi() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = ss.getActiveSheet();
- var search = "subject:AH IT Rimozione mailing list";
- // analizza le ultime 50 email per evitare che esploda tutto
- var threads = GmailApp.search(search, 0, 50);
- var row, messages, from, email;
- for (var i=0; i<threads.length; i++) {
- from = threads[i].getMessages()[0].getFrom();
- if (from.length) {
- email = from[0];
- email = email.replace(">", "");
- email = email.replace("<", "");
- row = sheet.getLastRow() + 1;
- // se trova un indirizzo, aggiungilo alla lista
- sheet.getRange(row,1).setValue(email);
- }
- }
- var date = new Date()
- sheet.getRange(1,6).setValue(date)
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement