Hi there, we are back with a new version of Email Exporter. This is our 3rd attempt to modify the script. Those who do not know what the Email Exporter is for them, this is a small program code written with Google Script by FunButLearn, using which you can export your Emails from Gmail to Spreadsheet. We generally try to modify a script when any of our visitors request us a new feature to add. You can have a look on our previous versions.
On 5th May 2013, we got a request from one of our beloved visitor Muthukumar Sakthivel regrading a new feature, exporting attachmemetms to Spreadsheet. Afterwards we did have some personal conversations regarding the new feature. And finally his request is accepted and we decided to modify the script so that it can even export attachments to the Spreadsheet. Here is a brief snippet of our conversations.
In our previous version, you can export upto 200 emails at a time. But in our latest version, this number has been shrunk to 100. This happened because exporting emails and saving it in Google drive takes a little time. So, if you are exporting more than 100, then it might cause time-out error. So it is better to export emails in a batch of 100. For example if you are going to export 1000 emails then export it in a batch of 100, it will never cause time-out as we have expected.
Secondly our previous versions could not export attachments to Spreadsheet, where as in the new version you can avail this new feature.
Lets everything be crystal clear and let me explain what exactly the script does.
To export your emails just do as per the instructions
:)
Read more
- Export Your Emails From Gmail into Excel or CSV
- Export Your Gmails into Spreadsheet With Their Labels
On 5th May 2013, we got a request from one of our beloved visitor Muthukumar Sakthivel regrading a new feature, exporting attachmemetms to Spreadsheet. Afterwards we did have some personal conversations regarding the new feature. And finally his request is accepted and we decided to modify the script so that it can even export attachments to the Spreadsheet. Here is a brief snippet of our conversations.
![]() |
| This conversation has been published after the permission of the sender |
So, what's the pros and cons in the latest version
In our previous version, you can export upto 200 emails at a time. But in our latest version, this number has been shrunk to 100. This happened because exporting emails and saving it in Google drive takes a little time. So, if you are exporting more than 100, then it might cause time-out error. So it is better to export emails in a batch of 100. For example if you are going to export 1000 emails then export it in a batch of 100, it will never cause time-out as we have expected.
Secondly our previous versions could not export attachments to Spreadsheet, where as in the new version you can avail this new feature.
How does it work
Lets everything be crystal clear and let me explain what exactly the script does.
- When you press the export button, the script starts reading your inbox
- While reading emails it also checks for attachments associated with them
- If any attachment found it makes a copy of it in a folder in your Google Drive
- Then it fetches the URL, name of the file and store it in the Spreadsheet
- If multiple attachments are associated with an email, the script copies all the files to Google drive and store their name and URL in a single cell.
How to do it
To export your emails just do as per the instructions
- Make a new copy of this spreadsheet in your Google Drive
- Just give 3 secs to load the Spreadsheet completely
- After the Spreadsheet loads, you can export the emails from the menu bar
- There will be two options for you. Choose the option as per your requirement
- You can look other instructions on our previus articles
- After the emails are exported, you will get a separate column in the spreadsheet for the attachments which contains the name and URL to the files
- To access the exported files publicly, just change the visibility option of their parent folder to public.
:)



