Ask HN: Extracting Data from Gmail into Spreadsheet
I have a some emails that look like receipts for online purchases…think “Your eBay Purchase” type emails.
I want to extract things like date and price and order number from them and stick that data in a spreadsheet.
I am using gMail.
Maybe a chrome extension you recommend or an AI tool?
For scale it less than 1000 emails.
(
3 comments
| on HN
)
You can definitely make a Python script do this using the Gmail and Sheets API libraries to do this or use Google Apps Script to do it. ChatGTP and/or Claude can probably write the code for you to do it if you know enough programming to understand and debug it.
I wrote a script in .net3 for outlook once, so I could probably do it again.
But I suspect someone already has something.