Ask HN: Extracting Data from Gmail into Spreadsheet

1 pointbrudgers3 comments

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.

One way to do this, but before the mails arrive, is to use a service like IFTTT or Zapier that can both read your mails that match a search and write to Google Sheets. Then you can configure them to save any mails that match the criteria automatically. However, that would be for future mails only.

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.

Thanks, the emails already arrived.

I wrote a script in .net3 for outlook once, so I could probably do it again.

But I suspect someone already has something.

"How to export gmail to google sheets or excel without code or appscript" : http://www.youtube.com/watch?v=CjH_rv6nujg

Reply on news.ycombinator.com