{"id":261,"date":"2024-06-16T06:42:53","date_gmt":"2024-06-16T06:42:53","guid":{"rendered":"https:\/\/www.rajeshkumar.xyz\/blog\/?p=261"},"modified":"2024-06-16T06:46:00","modified_gmt":"2024-06-16T06:46:00","slug":"to-extract-all-email-addresses-from-your-entire-gmail-account","status":"publish","type":"post","link":"https:\/\/www.rajeshkumar.xyz\/blog\/to-extract-all-email-addresses-from-your-entire-gmail-account\/","title":{"rendered":"To extract all email addresses from your entire Gmail account"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Method 1: Using Google Apps Script<\/h3>\n\n\n\n
    \n
  1. Open Google Sheets<\/strong>:\n
      \n
    • Create a new Google Sheet.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
    • Open Script Editor<\/strong>:\n
        \n
      • Go to Extensions<\/code> > Apps Script<\/code>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
      • Copy and Paste the Script<\/strong>:\n
          \n
        • Copy the following script and paste it into the script editor. This script will iterate through all threads in your Gmail account and extract email addresses from the sender and recipients.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
        • Run the Script<\/strong>:<\/li>\n\n\n\n
        • Save the script and click the play button (Run) to execute the function getAllEmails<\/code>. It will start extracting email addresses from all folders in your Gmail account and populating them in the Google Sheet.<\/li>\n<\/ol>\n\n\n
          function<\/span> getAllEmails<\/span>(<\/span>) <\/span>{\n  var<\/span> sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  var<\/span> emailAddresses = [];\n  var<\/span> row = 1<\/span>;\n\n  \/\/ Get all user labels<\/span>\n  var<\/span> labels = GmailApp.getUserLabels();\n  \n  \/\/ Get all inbox threads separately<\/span>\n  var<\/span> inboxThreads = GmailApp.getInboxThreads();\n  \n  \/\/ Function to process threads<\/span>\n  function<\/span> processThreads<\/span>(threads<\/span>) <\/span>{\n    for<\/span> (var<\/span> j = 0<\/span>; j < threads.length; j++) {\n      var<\/span> messages = threads[j].getMessages();\n      for<\/span> (var<\/span> k = 0<\/span>; k < messages.length; k++) {\n        var<\/span> from<\/span> = messages[k].getFrom();\n        var<\/span> to = messages[k].getTo();\n        var<\/span> cc = messages[k].getCc();\n        var<\/span> bcc = messages[k].getBcc();\n\n        var<\/span> emails = extractEmails(from<\/span>).concat(extractEmails(to), extractEmails(cc), extractEmails(bcc));\n        emails.forEach(function<\/span>(email<\/span>) <\/span>{\n          if<\/span> (emailAddresses.indexOf(email) === -1<\/span>) {\n            emailAddresses.push(email);\n            sheet.getRange(row, 1<\/span>).setValue(email);\n            row++;\n          }\n        });\n      }\n    }\n  }\n\n  \/\/ Process inbox threads<\/span>\n  processThreads(inboxThreads);\n  \n  \/\/ Process threads in each user label<\/span>\n  for<\/span> (var<\/span> i = 0<\/span>; i < labels.length; i++) {\n    var<\/span> threads = labels[i].getThreads();\n    processThreads(threads);\n  }\n}\n\nfunction<\/span> extractEmails<\/span>(str<\/span>) <\/span>{\n  var<\/span> emails = [];\n  if<\/span> (str) {\n    var<\/span> matches = str.match(\/[\\w.-]+@[\\w.-]+\\.\\w+\/g<\/span>);\n    if<\/span> (matches) {\n      emails = matches;\n    }\n  }\n  return<\/span> emails;\n}\n<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
          The script exceeding the maximum execution time indicates that it is taking too long to process all the threads and messages in your Gmail account. To handle this, you can modify the script to process the emails in batches and use a script trigger to resume processing where it left off.<\/p>\n\n\n\n
          Modified Script to Process Emails in Batches:<\/h3>\n\n\n\n
            \n
          1. Store Progress<\/strong>:\n
              \n
            • Use the Properties Service to store progress between executions.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
            • Batch Processing<\/strong>:\n
                \n
              • Process a limited number of threads per execution to avoid exceeding the execution time limit.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
              • Reschedule Execution<\/strong>:\n
                  \n
                • Use a trigger to schedule the next batch if there are more threads to process.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n
                  function<\/span> getAllEmails<\/span>(<\/span>) <\/span>{\n  var<\/span> sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  var<\/span> properties = PropertiesService.getScriptProperties();\n  var<\/span> emailAddresses = properties.getProperty('emailAddresses'<\/span>) ? JSON<\/span>.parse(properties.getProperty('emailAddresses'<\/span>)) : [];\n  var<\/span> row = properties.getProperty('row'<\/span>) ? parseInt<\/span>(properties.getProperty('row'<\/span>)) : 1<\/span>;\n  var<\/span> labelIndex = properties.getProperty('labelIndex'<\/span>) ? parseInt<\/span>(properties.getProperty('labelIndex'<\/span>)) : 0<\/span>;\n  var<\/span> threadIndex = properties.getProperty('threadIndex'<\/span>) ? parseInt<\/span>(properties.getProperty('threadIndex'<\/span>)) : 0<\/span>;\n  var<\/span> processedThreads = 0<\/span>;\n  var<\/span> BATCH_SIZE = 100<\/span>; \/\/ Number of threads to process per execution<\/span>\n  \n  \/\/ Get all user labels<\/span>\n  var<\/span> labels = GmailApp.getUserLabels();\n  \n  \/\/ Get all inbox threads separately<\/span>\n  var<\/span> inboxThreads = GmailApp.getInboxThreads();\n  \n  \/\/ Function to process threads<\/span>\n  function<\/span> processThreads<\/span>(threads<\/span>) <\/span>{\n    for<\/span> (var<\/span> j = threadIndex; j < threads.length && processedThreads < BATCH_SIZE; j++, processedThreads++) {\n      var<\/span> messages = threads[j].getMessages();\n      for<\/span> (var<\/span> k = 0<\/span>; k < messages.length; k++) {\n        var<\/span> from<\/span> = messages[k].getFrom();\n        var<\/span> to = messages[k].getTo();\n        var<\/span> cc = messages[k].getCc();\n        var<\/span> bcc = messages[k].getBcc();\n\n        var<\/span> emails = extractEmails(from<\/span>).concat(extractEmails(to), extractEmails(cc), extractEmails(bcc));\n        emails.forEach(function<\/span>(email<\/span>) <\/span>{\n          if<\/span> (emailAddresses.indexOf(email) === -1<\/span>) {\n            emailAddresses.push(email);\n            sheet.getRange(row, 1<\/span>).setValue(email);\n            row++;\n          }\n        });\n      }\n    }\n    threadIndex = j;\n  }\n\n  \/\/ Process inbox threads<\/span>\n  if<\/span> (labelIndex == 0<\/span>) {\n    processThreads(inboxThreads);\n  }\n\n  \/\/ Process threads in each user label<\/span>\n  for<\/span> (; labelIndex < labels.length && processedThreads < BATCH_SIZE; labelIndex++) {\n    var<\/span> threads = labels[labelIndex].getThreads();\n    processThreads(threads);\n    if<\/span> (threadIndex < threads.length) {\n      break<\/span>;\n    } else<\/span> {\n      threadIndex = 0<\/span>;\n    }\n  }\n\n  \/\/ Store progress<\/span>\n  properties.setProperty('emailAddresses'<\/span>, JSON<\/span>.stringify(emailAddresses));\n  properties.setProperty('row'<\/span>, row);\n  properties.setProperty('labelIndex'<\/span>, labelIndex);\n  properties.setProperty('threadIndex'<\/span>, threadIndex);\n\n  \/\/ Reschedule if there are more threads to process<\/span>\n  if<\/span> (labelIndex < labels.length || threadIndex < inboxThreads.length) {\n    ScriptApp.newTrigger('getAllEmails'<\/span>)\n      .timeBased()\n      .after(1<\/span> * 60<\/span> * 1000<\/span>) \/\/ Run after 1 minute<\/span>\n      .create();\n  } else<\/span> {\n    \/\/ Clear properties after completion<\/span>\n    properties.deleteAllProperties();\n  }\n}\n\nfunction<\/span> extractEmails<\/span>(str<\/span>) <\/span>{\n  var<\/span> emails = [];\n  if<\/span> (str) {\n    var<\/span> matches = str.match(\/[\\w.-]+@[\\w.-]+\\.\\w+\/g<\/span>);\n    if<\/span> (matches) {\n      emails = matches;\n    }\n  }\n  return<\/span> emails;\n}\n<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>","protected":false},"excerpt":{"rendered":"
                  Method 1: Using Google Apps Script The script exceeding the maximum execution time indicates that it is taking too long […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-261","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/posts\/261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/comments?post=261"}],"version-history":[{"count":3,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/posts\/261\/revisions"}],"predecessor-version":[{"id":265,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/posts\/261\/revisions\/265"}],"wp:attachment":[{"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/media?parent=261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/categories?post=261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/tags?post=261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}