Google Script Programming tricks Useful

Export Your Gmails into Spreadsheet With Their Labels

Just two weeks ago I had written an article about how to Export Your Emails From Gmail into Excel or CSV. It was really an unique apps script which requires a little effort to export emails into spreadsheet. Many people have already implemented it and got benefited.

Now I have slightly modified the previous script, added a new column for Gmail label. I am done with it and the newer version is available.

Comparison among different versions:

Version Title Price Action
1.0 Export emails from Gmail to Excel or CSV $ 8.99 Visit
2.0 Export emails from Gmail to Excel or CSV with labels $ 9.99
3.0 Export emails from Gmail to Excel or CSV with labels & attachments $ 10.99 Visit
4.0 Export all emails from Gmail to Excel or CSV
(With advanced features, recommended for business users)
$38(Offer) Visit

If you still need to ask something urgently, then call us at +919778188086

Changes we did in our previous script

  • Our previous script was not able to export Gmail labels into a different column in the spreadsheet. But now it has been modified accordingly.
  • You can not export Emails present under a particular label (with Export last N emails option) in the old script, but our new script can do it easily.
  • Some other enhancements have been done in GUI to make it more attractive.

How to use it

  • First purchase the product from above.
  • Open the Email Exporter Spreadsheet.
  • After it is completely loaded you will get a new menu option in the menubar called "Export Emails"
  • You will get two options to export, (a) Export last N emails (b) Export selected emails
  • In-case of Export last N emails you will get the following dialog

Export options

  • Simple choose the required label from the drop down  and provide a number between 1-200 to export. To export more than 200 emails go for Export selected emails option, where you can use Gmail search queries so that you can export unlimited emails in a batch of 200.
  • The functionality almost remains the same in our new script so you can obviously refer the previous article for any instruction you need