Who is this for? This workflow is ideal for: - For freelancers, business owners, and finance teams who receive receipts via Gmail - Automatically logs expenses for tax, - bookkeeping and year-end audits What problem is this workflow solving? When tax season hits, missing receipts create panic. This workflow keeps everything in one place. It uses AI to extract details from Gmail attachments, logs them in a Google Sheet, and stores the PDFs in Google Drive. No digging. No copying. Just everythin

Who is this for? This workflow is ideal for: - For freelancers, business owners, and finance teams who receive receipts via Gmail - Automatically logs expenses for tax, - bookkeeping and year-end audits What problem is this workflow solving? When tax season hits, missing receipts create panic. This workflow keeps everything in one place. It uses AI to extract details from Gmail attachments, logs them in a Google Sheet, and stores the PDFs in Google Drive. No digging. No copying. Just everything where it should be. How it works? 1. Apply the label receipt to any incoming Gmail email. Do not mark it as read. 2. On a schedule (e.g. daily at 8:00 AM), the workflow triggers. 3. It searches for unread emails with the label receipt. 4. For each matching email, it downloads the attached receipt file. 5. It extracts text content from the receipt file. 6. It uploads the original receipt file to a specified folder in Google Drive. 7. It merges the extracted text with email metadata. 8. It sends this combined data to OpenAI. OpenAI extracts structured fields: - date - merchant - category - description - subtotal - tax - total 9. The extracted data is appended as a new row in the specific Google Sheet. 10. Finally, the email is marked as read to prevent it from being processed again. How to set up? 1. Connect these services in your n8n credentials: - Gmail (OAuth2) - Google Drive - Google Sheets - OpenAI 2. Configure the Google Drive upload: - In the “Upload File” node, select the target folder where you want receipt PDFs stored. 3. Set your execution schedule: - Open the “Schedule Trigger” node and choose when it should run (default is once daily at 8:00 AM). 4. Choose your Google Sheet and tab: - In the “Append to Google Sheet” node, select your document and tab - Ensure the sheet contains these columns: Date, Merchant, Category, Description, Subtotal, Tax, Total. How to customize this workflow to your needs? - Change the Gmail label or search filter to match your needs. - Modify the OpenAI schema to extract additional fields like currency, project, or notes.
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.