Harvest data from email into an Excel table

Python Help
1

Hi, I am from India. Is there a way to harvest all the 80G forms that charitable institutions send, from my inbox, for 2025-26 financial year, for income tax deduction. I looked up claude and it has given a python solution. Just don’t know how to action it.

2

The problem is you don’t know how to run Python on your computer, or something else?

3

Yes I don’t know how to run python on the computer. Have downloaded python 3.12. I am very good in Excel. This is the error

image
image1184×398 87.9 KB

4

well that seems like it explains itself. Probably your email or password is incorrect?

Try extracting just

mail=???
GMAIL_EMAIL=...
APP_PASSWORD=...
mail.login(GMAIL_EMAIL, APP_PASSWORD)

into a python program. You might not want to share your password online, but that’s where the core of your probably probably lies.

You’re already running python successfully if you’ve got this error message.

I don’t know where your mail comes from (import or definition).

5

I have mail forwarding, necessary for harvesting the 80G forms, from yahoomail to Gmail on my mobile phone and the python running on my mac. Forwarding not possible on mac. Can you guide the entire process step by step?

6

No.

That is actually the kind of task I have found AI very useful for. If AI can’t do it, neither can I.

7

Ok. Thank you.