Member Avatar for 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

  • 2 Contributors
  • 3 Replies
  • 280 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by cereal
Member Avatar for jacob21

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

Member Avatar for 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:

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.