The rest are more complex, time-consuming, and\/or expensive.<\/p>\n
So yeah, we\u2019re going to focus on that first option.<\/p>\n
In this article, I\u2019ll go step-by-step through the process of getting your emails into Google Sheets<\/strong>\u00a0using the Google Apps Script method.<\/p>\n I\u2019ll also briefly touch on the other methods, as well as cover how to automate the process.<\/p>\n And finally, I\u2019ll share the best way to get Google Sheets and Gmail working in sync<\/strong>\u00a0\u2014 so you can create all your email marketing and mail merge mass emails <\/strong>inside<\/strong><\/em>\u00a0Gmail<\/strong>\u00a0using contact lists from Sheets.<\/p>\n By far the easiest way to convert your Gmail to Google Sheets is with Google Apps Script<\/strong>.<\/p>\n The downside: Google Apps Script can look<\/em>\u00a0intimidating to some folks \u2014 like you need to know how to code to use it.<\/p>\n You don\u2019t.<\/p>\n You only need to know how to copy and paste<\/strong>.<\/p>\n Here\u2019s how to set it up.<\/p>\n This sounds basic. But for this all to work as smoothly as possible, you need to be logged into the correct Google account<\/strong>\u00a0in your browser for both Gmail and Google Sheets.<\/p>\n Just to be sure, if you log into multiple Google accounts in one browser, I recommend logging out of all the other ones<\/strong>.<\/p>\n Again, I know this sounds basic. But this step trips up more people than you\u2019d ever believe.<\/p>\n Open up a new sheet in Google Sheets<\/strong>. Name it whatever you want (as you can see, I called mine \u201cImported emails\u201d).<\/p>\n Then type the following in different columns in Row 1 to serve as your column headers: MessageID<\/strong>, Date<\/strong>, Sender<\/strong>, Subject<\/strong>, Body<\/strong>.<\/p>\n Now go to Extensions > Apps Script<\/strong>.<\/p>\n That will open the Apps Script window.<\/p>\n Give your script a name by clicking on \u201cUntitled project.\u201d This name is for your own use only, so it can be whatever you want; I called mine \u201cEmail extractor.\u201d<\/p>\n Now copy everything in this code block below<\/strong> and paste it over the \u201cfunction myFunction() {}\u201d in the main coding area of the screen.<\/p>\n Then click the floppy disk icon to Save<\/strong>.<\/p>\n Now you have to decide which emails you want to convert into Google Sheets.<\/p>\n We set up the Google Apps Script so it pulls all the emails that match a Gmail search<\/strong>. (In the script you pasted, it\u2019s searching by label.)<\/p>\n If you wanted to pull every email, you\u2019d make the search in:all, and you\u2019d change the number \u201c10\u201d to a much larger number to cover all your emails (like 1,000+). But warning: This will take a long time (and might crash).<\/p>\n Instead, I recommend pulling this with smaller searches<\/strong>, like everything in your inbox (in:inbox) or everything starred (is:starred) or all mail that\u2019s come since a certain date (newer_than:6m).<\/p>\n For my example, to keep things tidy, I\u2019ll go with \u201cis:starred\u201d. I set the limit to 100, even though I know I don\u2019t have 100 starred emails, just to give some buffer. Then I\u2019ll Save<\/strong>\u00a0the script.<\/p>\n With everything set, click Run<\/strong>\u00a0to run the script. (Note: You\u2019ll probably get a pop-up where you need to give Google Apps Script the authorization to run.)<\/p>\n And when it\u2019s run successfully, you\u2019ll see that message in the Execution log<\/strong>.<\/p>\n Head back over to the tab with your Google Sheet and you should see all the messages you extracted are now there!<\/p>\n Also note that if you had any threads that came up in your search, all the messages from those threads will be in the Google Sheet on individual rows<\/strong>.<\/p>\n The Apps Script is set up so you can run it again anytime you want and it will add any new messages that match the search to new rows in the Google Sheet.<\/p>\n And that\u2019s something we can even automate<\/strong>\u2026<\/p>\n You can have this Google Apps Script run automatically, in the background, to continue extracting your emails.<\/p>\n For instance, let\u2019s set up the search for in:inbox so the Google Apps Script converts all the emails in our inbox to the Google Sheet.<\/p>\n The first time I save and run that script, it grabs all 13 messages in my inbox.<\/p>\n Now I\u2019ll automate it<\/strong>\u00a0to grab any new messages in my inbox just after midnight every night.<\/p>\n Click on the alarm clock icon on the left sidebar to open the Triggers <\/strong>menu.<\/p>\n Click the + Add Trigger<\/strong>\u00a0button in the bottom right corner.<\/p>\n The settings I went with are:<\/p>\n Then click Save<\/strong>.<\/p>\n Now every day between midnight and 1:00 A.M., this script will run and pull any new messages from my inbox into the Google Sheet<\/strong>. I don\u2019t have to take any action \u2014 it will run automatically.<\/p>\n You\u2019re all set. You can now convert your email to Google Sheets as you need \u2014 and have the conversion continue to run automatically.<\/p>\n And if you want, you can always set up the Apps Script on a different Google Sheet if you want to pull other emails<\/strong>. (For instance, you could have different Google Sheets for your different emails with different people.)<\/p>\n Yes, the Google Apps Script method checked what I considered the most important boxes (free, easy, using native options).<\/p>\n But there are other methods you can use to import your emails into Google Sheets<\/strong>.<\/p>\n I\u2019ll quickly cover those, just so you know what else is out there for you if \u2014 for whatever reason \u2014 you want to make this process more difficult.<\/p>\n I\u2019ll start with this one, though it\u2019s comically inefficient. Yes, you could manually copy and paste your emails from Gmail into Google Sheets<\/strong>.<\/p>\n You shouldn\u2019t\u2026 but you can.<\/p>\n You can set up automations in software like Zapier or Automate.io where every time you receive an email in Gmail, it\u2019s added to your Google Sheet.<\/p>\n I wouldn\u2019t advise this method, though. It will take just as long and be just as complicated<\/strong>\u00a0\u2014 maybe even more so \u2014 as the Google Apps Script method I detailed above.<\/p>\n Plus these services will all cost you money if you exceed your monthly free quota.<\/p>\n There\u2019s no native way inside Gmail to export your emails to a CSV.<\/p>\n You can<\/em>\u00a0export emails as a .mbox file, though. Then you could use an app to convert that file to a CSV and import that into Google Sheets<\/strong>.<\/p>\n Alternatively, you could use a Chrome extension that allows you to export your emails from Gmail as a CSV<\/strong>. I\u2019m not going to recommend any of them. Why? I\u2019ve tested a bunch of these types of extensions and have never found one I particularly like (or that works well, especially with larger volumes).<\/p>\n This is also adding a whole lot of unnecessary steps<\/strong>\u00a0to the emails-to-Sheets process.<\/p>\n The last option is using a Gmail add-on to export your emails<\/strong>\u00a0to a Google Sheet.<\/p>\n These essentially do the same thing as we set up for free in five minutes with the Google Apps Script \u2014 only they want you to pay.<\/p>\n So once again, it really doesn\u2019t make sense to go this route<\/strong>\u00a0when it\u2019s so easy to set up an efficient Gmail-to-Sheets function for free.<\/p>\n Now that you\u2019ve seen how to export your emails from Gmail or Google Workspace into Google Sheets \u2014 let\u2019s make that Gmail + Sheets partnership even stronger<\/strong>.<\/p>\n GMass<\/strong>\u00a0is a Chrome extension that turns Gmail into a full email marketing platform<\/strong>. You can send any type of email \u2014 cold outreach, newsletters, mail merge, and more \u2014 from right inside<\/em>\u00a0Gmail.<\/p>\n And the best part: Rather than needing to hook up a complex and expensive CRM to manage your contact lists, it\u2019s all done inside Google Sheets. (As we know, you can run a great Google Sheets CRM<\/a> \u2014 we even have a free template for GMass users<\/a>.)<\/p>\n GMass has a native <\/strong>Google Sheets mail merge<\/a><\/strong>\u00a0that makes it incredibly<\/em>\u00a0easy to personalize your emails.<\/p>\n Plus, with GMass you get unlimited everything<\/strong>\u00a0(emails, contact, campaigns)…<\/p>\n an incredible suite of unique deliverability tools<\/strong>\u00a0to help you get to the inbox (check out Spam Solver<\/a>)…<\/p>\n free email verification<\/strong>\u2026<\/p>\n and everything else you could want or need<\/strong>, from tracking to automated follow-ups to A\/B testing.<\/p>\n You can try out GMass for free<\/strong>\u00a0with no credit card required<\/strong>. Just install the Chrome extension<\/a><\/strong>, connect your Gmail or Google Workspace account, and you\u2019ll be sending campaigns in a matter of minutes<\/strong>. (Here\u2019s a quickstart guide<\/a>\u00a0as well.)<\/p>\n See why almost 400,000 people<\/strong>\u00a0use GMass and give it an average rating of 4.8 out of 5 stars<\/strong>\u00a0across 10,000+ reviews<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":" There are plenty of ways to convert your Google Workspace\/Gmail email to Google Sheets. One of those ways is free, requires no external app\/add-on, and takes five minutes\u00a0at\u2026<\/p>\n","protected":false},"author":29,"featured_media":24954,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[4254,4261],"tags":[],"class_list":["post-24952","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gmail-tips-and-tricks","category-google-sheets"],"acf":[],"yoast_head":"\r\nEmail to Google Sheets: Table of Contents<\/h2>\n
\n
\n
The Easy Way to Convert Gmail to Google Sheets<\/h2>\n
Log into the Gmail account you want to extract to Google Sheets<\/h3>\n
Create the Google Apps Script in Google Sheets<\/h3>\n
![\"Set](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-setupsheet.png\")
<\/a><\/figure>\n![\"Open](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-appsscriptmenu.png\")
<\/a><\/figure>\n![\"Title](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-appsscripttitle.png\")
<\/a><\/figure>\nfunction getEmailsToSheet() {<\/code>
\nconst sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();<\/code>
\nconst threads = GmailApp.search(\"label:your-label-here\", 0, 10); \/\/ Replace with your search query<\/code>
\nconst messages = threads.map(thread => thread.getMessages()).flat();<\/code><\/p>\n\/\/ Get the last row of the sheet<\/code>
\nconst lastRow = sheet.getLastRow();<\/code><\/p>\n\/\/ Initialize a header row if the sheet is empty<\/code>
\nif (lastRow === 0) {<\/code>
\nsheet.appendRow([\"Message ID\", \"Date\", \"Sender\", \"Subject\", \"Body\"]);<\/code>
\n}<\/code><\/p>\n\/\/ Handle the case where there are no rows (other than the header)<\/code>
\nlet existingIds = [];<\/code>
\nif (lastRow > 1) {<\/code>
\n\/\/ If there are data rows, retrieve Message IDs from Column A<\/code>
\nexistingIds = sheet.getRange(2, 1, lastRow - 1, 1).getValues().flat();<\/code>
\n}<\/code><\/p>\n\/\/ Loop through messages and add new ones<\/code>
\nmessages.forEach(message => {<\/code>
\nconst messageId = message.getId(); \/\/ Unique ID for each email<\/code>
\nconst date = message.getDate();<\/code>
\nconst sender = message.getFrom();<\/code>
\nconst subject = message.getSubject();<\/code>
\nconst body = message.getPlainBody();<\/code><\/p>\n\/\/ Add the email only if its Message ID is not already in the sheet<\/code>
\nif (!existingIds.includes(messageId)) {<\/code>
\nsheet.appendRow([messageId, date, sender, subject, body]);<\/code>
\n}<\/code>
\n});<\/code>
\n}<\/code><\/p>\n![\"Paste](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-scriptcode.png\")
<\/a><\/figure>\n![\"Save](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-savescript.png\")
<\/a><\/figure>\nDeciding what emails you want to extract<\/h3>\n
![\"Changing](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-changesearch.png\")
<\/a><\/figure>\n![\"The](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-isstarredsearch.png\")
<\/a><\/figure>\nRunning the script<\/h3>\n
![\"Run](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-runscript.png\")
<\/a><\/figure>\n![\"Execution](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-executioncomplete.png\")
<\/a><\/figure>\n![\"See](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-emailsinsheet.png\")
<\/a><\/figure>\nAutomating the Google Apps Script to extract emails<\/h3>\n
![\"Searching](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-ininbox.png\")
<\/a><\/figure>\n![\"The](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-triggersmenu.png\")
<\/a><\/figure>\n![\"Add](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-addtrigger.png\")
<\/a><\/figure>\n\n
![\"Trigger](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2025\/01\/emailtosheets-triggersettings.png\")
<\/a><\/figure>\nThe Other Ways to Convert Email Into Google Sheets<\/h2>\n
Manual copy and paste<\/h3>\n
Using Zapier or other automation software<\/h3>\n
Exporting emails to a CSV, then importing<\/h3>\n
Using a Gmail add-on<\/h3>\n
Make Gmail and Google Sheets Work Together Even Better<\/h2>\n
![\"\"](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/12\/htmlspace-gmass.png\")
<\/a><\/p>\n