AI auto-save Gmail receipts to Google Sheets + Google Drive
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every day at 08:00). Along the way it connects OpenAI Chat Model, Gmail, Google Sheets and Google Drive.
How it runs
Trigger: On a schedule (every day at 08:00).
- Get Emails with Receipts (Gmail): get many
- Download Attachment (Gmail): get
- Upload File (Google Drive): uses Google Drive
- Get Required Fields (Edit Fields (Set)): sets 5 fields: id, threadId, textAsHtml…
- Extract Data from Invoice (Extract from File): extracts data from a file (pdf)
- Merge: merges the data from its input branches
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Append to Google Sheet (Google Sheets): append
- Mark Email as Read (Gmail): mark as read
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile
From the author
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…