extract data from gmail

[jacob21]

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

[cereal]

I did not tested with Gmail but check the Mailparse library:

• http://www.php.net/manual/en/book.mailparse.php

[jacob21]

Is there is any tool..as i have less knowledge of php

[cereal]

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:

• https://developers.google.com/gdata/faq

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=[e-mail]&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>[e-mail]</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.