Automated Receipt Processing and Record Keeping

This n8n workflow automates the process of extracting receipt data from Gmail emails, parsing the information, and storing it systematically in Google Sheets and Google Drive. It is designed to save time and enhance accuracy in expense tracking and record management. The workflow triggers daily at 8 am, retrieves unread emails with attachments from a specified Gmail label, downloads the receipts, and uses AI (GPT-4) to extract key details such as date, merchant, amount, and category. Extracted data is then formatted, combined, and appended to a Google Sheet for easy access. The original receipt PDFs are saved to Google Drive with a structured naming convention, and the emails are marked as read to prevent reprocessing.