Read Aloud the Text Content

This audio was created by Woord's Text to Speech service by content creators from all around the world.

Text Content or SSML code:

In this video, we are going to show you how to export Gmail emails to Google Sheets. First, you need to create a blank Google spreadsheet. All these entities mentioned here like time, thread count, from and to email addresses, email subject, and email body is going to be extracted from Gmail inbox. Please ensure that name of the each column is exactly the same as mentioned in this video. For your convenience, we have left a link to a sample spreadsheet in the description box. You can copy it from there. We are going to parse this email inbox. It has both read and unread emails, not that matters because the Apps Script will export all emails. Let’s get back to the sheet we created and select the extensions option from the top menus. Then in the dropdown click on the Apps Script option. This will open a new Apps Script project. Give it an appropriate name. Here’s the script that will get the emails from the Gmail inbox. In this script, you need to change three things. First is spreadsheet ID, you can get it from the address bar when you open the spreadsheet. The second thing to change is the sheet name. Open the spreadsheet and you’ll see the name in the bottom left corner. The third and last change is to create a menu button that will initiate exporting. Under the quotation mark is the name of the button, change it as you please. The rest of the script will remain as it is. We have left a link to the sample Apps Script project in the description box. You can copy it from there. When everything is done, click on the save project icon in the top menu. Open the Google Spreadsheet and hit the refresh button. Just like this, the button will appear alongside the top menus. Click on this button and click on then click on the get email button. A dialog box will prompt and ask for permission to run the script. Click on the continue button. Then choose your Google account and then allow the apps script project to make changes to the spreadsheet. Once authorization is done, click on the get email button again. You will see the script is running and the spreadsheet has started filling with emails. It will keep running until all emails are not exported. You can also abort the export midway and emails that are already exported will remain saved. Let’s see what we have got here. The email receive date, thread count, from and to email addresses, email subject and body. We are going to pick out a random email from the inbox to check if all the emails are exported. Let’s copy the subject of this email and find it in the sheet. As you can see, this email has been exported. Here’s the date on which the email was delivered, the email sender, recipient, email subject, and body. And that’s how simply you can export Gmail emails in just one click.