Automate the fetching of e-mail (Gmail) body to an Excel file

Question

0.00/5 (No votes)

See more:

Is it possible to automate the fetching of part of the e-mail body from my Gmail inbox to an Excel file? I want to get the data from my inbox which is in a table form to an Excel file. I tried to run the WebQuery on my inbox but it is giving me the following error message.

"Unable to open https://mail.google.com/mail.... Cannot download the information you requested"

Does Google provide any API to achieve this? Or is it possible to achieve this programmatically(C#) or using Macro? Any help or suggestion will be appreciated. Thank you

Posted 29-May-13 20:23pm

waris kantroo

Updated 30-May-13 0:12am

walterhevedeich

v2

Add a Solution

Comments

ZurdoDev 30-May-13 7:50am

Is it possible? Yes, everything is possible. Does Google provide an api? Yes, https://developers.google.com/

waris kantroo 31-May-13 1:31am

WOULD YOU PLEASE PROVIDE ME THE SPECIFIC LINK FOR THE API.I TRIED BUT COULDN'T FIND ANYTHING SPECIFIC. THANK YOU

ZurdoDev 31-May-13 7:33am

No. First off, don't yell. Stop using all CAPS. Secondly, if you can't find the API then I don't think you'll be able to write code for this anyway.

waris kantroo 1-Jun-13 1:14am

That was very helpful. You are so cool..

waris kantroo 1-Jun-13 1:22am

Anyway I got the answer from "Stackoverflow"

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-07-01T09:34:00

Here is a question on Stack Overflow[^]. And the answer is:

Jon Fournier May 31 at 16:23 wrote:
If I were you I would instead set up outlook to sync your gmail account, and use the outlook API. It is probably at least 10x easier that way.

Posted to remove above question from "Unanswered Question" collection.