0

Hi,

Is there any tool that extract below from gmail and save in to csv.

Name of Person
to: Email id
cc: Email id
Time stamp - DD/MM/YYYY
URL's in the email

2
Contributors
3
Replies
19
Views
3 Years
Discussion Span
Last Post by cereal
0

I'm sorry, I don't know if there is a tool that can do exactly this, search on Google, maybe you can find something that exports the messages to XML and then from there you can create your CSV files.

An alternative is to check their Data API:

By accessing the feed:

GET https://mail.google.com/mail/feed/atom/ 

You can get the unread messages in XML format, it looks like this:

<entry>
    <title>Subject of the Email</title>
    <summary>First line of the email message...</summary>
    <link rel="alternate" href="http://mail.google.com/mail?account_id=yourmail@gmail.tld&amp;message_id=random_alnum&amp;view=conv&amp;extsrc=atom" type="text/html" />
    <modified>2014-01-18T13:01:02Z</modified>
    <issued>2014-01-18T13:01:02Z</issued>
    <id>tag:gmail.google.com,2004:random_integer</id>
    <author>
        <name>Sender Name</name>
        <email>email@domain.tld</email>
    </author>
</entry>

From the feed you can get some of the needed information, but you still do not get the full message body, so if you want to extract links from there you need an IMAP or POP access and a parser, as suggested in my previous post.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.