Extract receipt data from Gmail to Google Sheets and Dr

This automation streamlines the process of collecting and processing digital receipts from email, making it ideal for expense tracking, tax reporting, and reimbursement workflows. It’s designed for users who regularly receive receipts as PDF attachments and want to eliminate manual data entry.

## Who it´s for
- Freelancers tracking expenses for tax reporting
- Small businesses automating employee receipt collection
- Remote workers claiming business travel reimbursements
- Accountants consolidating financial data
- Personal users organizing spending via email

## What the automation does
- Runs daily on a cron schedule at 8 AM
- Checks Gmail for unread messages with attachments
- Downloads PDF receipt files
- Extracts text from PDFs using document parsing
- Sends data to a LangChain agent powered by GPT-4 to extract structured fields: date, merchant, category, subtotal, tax, total
- Saves parsed data into a new row in Google Sheets
- Uploads the original PDF to a designated folder in Google Drive
- Marks processed emails as read

## What´s included
- Ready-to-use n8n workflow
- Trigger logic based on email read status and schedule
- Integrations with Gmail, Google Drive, Google Sheets, and OpenAI via API
- Basic setup and adaptation guide

## Requirements for setup
- n8n instance with workflow editing access
- Gmail account with API enabled
- Google Drive folder for storing original receipts
- Google Sheets spreadsheet with predefined column structure
- OpenAI API key with access to GPT-4

## Benefits and outcomes
- Eliminates manual data entry from receipts
- Ensures high accuracy through AI-powered parsing
- Centralizes receipt storage and metadata
- Speeds up preparation for financial reporting and tax filing
- Saves several hours per week on administrative tasks
- Scales seamlessly across dozens of receipts daily

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.