HACKER Q&A
📣 brudgers

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.

  👤 stuartcw Accepted Answer ✓
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.