I'm receiving some kinds of automated job completion notification by email. Thus it is hard to manage hundreds of email, so I'd like to automate it.

So, is it possible to save all or unread emails' subjects in a text, CSV, or Excel file?

  • 1
    What operating systems can you use? Is Perl or Python or Ruby available?
    – user1686
    Commented Oct 30, 2016 at 9:55
  • @grawity Windows 10. I wondered if there is a simple solution and I don't want to use complex programming language.
    – user67275
    Commented Oct 31, 2016 at 6:48
  • Using a programming language doesn't have to be complex. You certainly aren't going to find anything simpler. You can use Google Apps Script with the Gmail API from your Google Drive.
    – Moshe Katz
    Commented Oct 31, 2016 at 17:42

2 Answers 2


You can probably do something with If This Then That.

  1. Create a Gmail trigger, either all new messages or new messages that meet some search criteria
  2. Create an action to add a line to a Google Sheet. You would probably want the date/time, sender, and the subject

This recipe should give you an idea of what you can do (or you can simply modify this recipe for your own purposes).


Maybe you can use web scraping and Windows task scheduler.

First, write a code to do the following.

  1. Log in to your Gmail account.
  2. Collect your e-mail subjects using Python Selenium library

Do the above tasks repeatedly using Windows Task Scheduler.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.