Download emails from Gmail to Excel

Question

gmail

Friends,

Gmail receives orders every day, all letters are in the same format. Until now, the manager manually transfers all orders to the report at the end of the month. Tell me how to optimize the process of transferring to Excel with little bloodshed.

Thanks in advance!

Answer 1

I would write a simple program that would download emails by pop3 and parse them with a regular expression. I would throw off the necessary ones in an xml file. And excel reads and updates them very well. This is done quite quickly.

Answer 2

Turn on "Gmail Offline" - this will install GoogleGears, and the mail will be automatically saved on the local computer in the database (like the SQLite format).
And pulling data out of this database is quite simple. There is software that can make selections from SQLite and export to Excel.

Answer 3

You can view the contents of the SQLite database and export the results of queries with these programs: www.sqlite.org/cvstrac/wiki?p=ManagementTools

Answer 4

fetchmail + a script on anything using cron to generate a csv file or a .net program that does the same at the click of a button, whichever is more convenient.
There are probably no ready-made solutions.

Answer 5

Enable the php imap module
Use our script (there may be bugs, since it was originally written to handle honeypots and forward spammers)
pastie.org/1418341
in do_msg to generate the necessary work with the message.
If you have any questions, please contact.
you can generate through Excel_Writer
pear.php.net/package/Spreadsheet_Excel_Writer/
www.phpclub.ru/detail/article/Excel_Writer

Answer 6

Did the following:
1. Cling to the mailbox in Microsoft Office Outlook via IMAP.
2. Connected an Outlook box as a data source in Access (he can do that).
3. And from Access already at least in Excel, at least anywhere :)

Answer 7

don't invent bikes https://ifttt.com/applets/55592786d-automatically-...