AI auto-save Gmail receipts to Google Sheets + Google Drive
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
At a glance
AI auto-save Gmail receipts to Google Sheets + Google Drive is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, OpenAI, Google Drive
- Modules
- 12
- Price
- Free
- Version
- v1.0

About this workflow
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.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create OpenAI-compatible API using GitHub models for free AI access
Generate content with ChatGPT from Google Sheets range values and update the row
Create workflow inventory dashboard with n8n API and Google Sheets
Generate LinkedIn posts and AI images from web pages with Airtop and GPT-4
Create ClickUp tasks from new emails in Gmail
Create & approve POV videos with AI, ElevenLabs & multi-posting (TikTok/IG/YT)
Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack
Convert HTML to PDF and return via webhook using CustomJS API
Reviews
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.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you