{"id":56598,"date":"2024-07-31T09:00:58","date_gmt":"2024-07-31T09:00:58","guid":{"rendered":"https:\/\/dev.outrightcrm.in\/dev\/store\/?p=56598"},"modified":"2024-07-31T09:01:05","modified_gmt":"2024-07-31T09:01:05","slug":"automate-email-extraction-into-google-sheets","status":"publish","type":"post","link":"https:\/\/dev.outrightcrm.in\/dev\/store\/blog\/automate-email-extraction-into-google-sheets\/","title":{"rendered":"Automate Email Extraction into Google Sheets with Advanced Features"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">An Overview<\/h2>\n\n\n\n<\/br>\n\n\n\n<p>In this blog post, we will explore \u201c How to Extract Data from Email into Google Sheets in a more advanced and efficient way using Free Google Apps Script and Google Spreadsheet. Additionally, the advanced features of this automation include trigger-creation on the sidebar, built-in button functionality, time-automation functionality, and more.<\/p>\n\n\n\n<\/br>\n\n\n\n<p>This guide is perfect for those who are looking to streamline their email management process and want to keep all important details organized in a Google Sheet. Let\u2019s have a direct jump into the main automation, without any further ado!<\/p>\n\n\n\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\">Email Parsing Automation? | A Step-by-Step Guide<\/h2>\n\n\n\n<\/br>\n\n\n\n<h3 class=\"wp-block-heading\">1. Open Your Google Sheet<\/h3>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To intimate this automated email extraction into the Google Sheet procedure, open up a Google Sheet where you want to fetch email details such as subject, body, attachments, and more.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<h3 class=\"wp-block-heading\">2. Access Apps Script<\/h3>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Next, you need to click on the &#8220;Extensions&#8221; button and select the &#8220;Apps Script&#8221; option from the drop-down menu showing at the top of the page. This will bring you right in the coding section of the sheet.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<h3 class=\"wp-block-heading\">3. Paste the Code<\/h3>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once, the coding section of the Google spreadsheet has been opened to you then you have to copy a well-working code there.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<h3 class=\"wp-block-heading\">4. Create HTML File<\/h3>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Now, you need to create an HTML file to get your Triggering adding an option on the front of the Google Sheet. For this, click on the plus (+) button next to \u201cFiles\u201d in the top left corner and select the HTML option.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Here, you have to give an appropriate name to your file, as we have given \u201csidebar.html\u201d and press Enter.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<h3 class=\"wp-block-heading\">5. Run the Code<\/h3>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Now, take a step back to the previous and click on the \u201cRun\u201d button in the Apps Script editor. Next to this, you have to authorize the permission for further execution. For this, click on the \u201cReview Permissions\u201d then select a valid email account, and finally, click on the \u201cAllow\u201d button.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<h3 class=\"wp-block-heading\">6. Verify Execution<\/h3>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once you have done the authorization, then you will see that the execution has been started and completed as well within a few seconds. You can also rename your coding page if required.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<figure class=\"wp-block-image aligncenter is-resized\"><a href=\"https:\/\/youtu.be\/VFjYlfXvXK0?si=5UypnN0htsLP5NmZ\" target=\"_blank\" rel=\"nofollow noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/dev.outrightcrm.in\/dev\/store\/dev\/store\/wp-content\/uploads\/2024\/07\/Comp-1_1-3.gif\" alt=\"\" class=\"wp-image-54320\" width=\"414\" height=\"232\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<br>\n\n\n\n<h3 class=\"wp-block-heading\">7. Use the Google Sheet Buttons: \u201cExport Emails\u201d<\/h3>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After the execution, you will see that there are two new buttons appearing on the Google sheet at the top, one with the name \u201cExport Emails\u201d and another with \u201cSet Triggers\u201d.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Utilizing the \u201cExtract Emails\u201d button will automate your email extracting procedure from your inbox into the Google Sheet including all details like To email, subject, body, email URL, thread count, and timestamp.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For confirmation, you can click on the email URL, mentioned in the sheet which will redirect you to the original email thread.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<h3 class=\"wp-block-heading\">8. Automate the Process: \u201cSet Triggers\u201d<\/h3>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>There is no doubt that you can use this process for auto-extraction of the email. However, to automate the process on a set-up time periodically, you have to click on the \u201cSet Trigger\u201d button at the top of the sheet. This will open up a set trigger side panel on the Google Sheets.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Here, you need to select the \u201cExport Emails\u201d option from the function dropdown and have to choose a time interval (e.g., one minute) before clicking the \u201cSet Trigger\u201d button. This keeps your sheet updated with new emails periodically.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<h3 class=\"wp-block-heading\">9. Verify Automated Process<\/h3>\n\n\n\n<\/br>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For verification, we will send a few test emails and observe the updates in your Google Sheet, as you can see in this video. As a consequence, you can see that all newly received emails are appearing in the Google Sheet with their proper format such as date, and details, and ensure that the URL links along with automation are working correctly.<\/li>\n<\/ul>\n\n\n\n<\/br>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<\/br>\n\n\n\n<p>In this article, we will introduce you to \u201cHow to Extract Data from Email into Google Sheets\u201d in a more advanced and efficient way using Free Google Apps Script and Google Spreadsheet. Additionally, the advanced features of this automation include trigger-creation on the sidebar, built-in button functionality, time-automation functionality, and more. Therefore, using our following steps, you can automate your email parsing process effectively and can be updated.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Also Check<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/dev.outrightcrm.in\/dev\/store\/blog\/parse-email-body-data-and-save-it-into-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Parse Email Body Data and Save it into (Google Sheets) | Apps script | Email Labels<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>An Overview In this blog post, we will explore \u201c How to Extract Data from Email into Google Sheets in [&hellip;]<\/p>\n","protected":false},"author":17769,"featured_media":56601,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[399],"tags":[],"class_list":["post-56598","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-apps-script"],"acf":[],"_links":{"self":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts\/56598","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/users\/17769"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/comments?post=56598"}],"version-history":[{"count":0,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/posts\/56598\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/media\/56601"}],"wp:attachment":[{"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/media?parent=56598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/categories?post=56598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.outrightcrm.in\/dev\/store\/wp-json\/wp\/v2\/tags?post=56598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}