Invoices from Gmail to Drive and Google Sheets
n8n template #3016Summary
Use templateAttachments Gmail to Drive and Google Sheets Description Automatically process invoice emails by saving attachments to Google Drive and extracting key invoice data to Google Sheets using AI. This workflow monitors your Gmail for unread emails with attachments, saves PDFs to a specified Google Drive folder, and uses OpenAI's GPT-4o to extract invoice details (date, description, amount) into a structured spreadsheet. Use cases Invoice Management: Automatically organize and track invoices received via email Financial Record Keeping: Maintain a structured database of all invoice information Document Organization: Keep digital copies of invoices organized in Google Drive Automated Data Entry: Eli
How to set it up
- Open template #3016 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
- Create 4 credentials under Credentials → Add credential: Google Sheets, Google Drive, Gmail, OpenAI Model. Then open each of those nodes and pick the credential.
- Click Execute workflow and step through each node's output to confirm the data looks right.
- Toggle the workflow to Active so its trigger runs on its own.
Hand off to your agent
Prompt
Help me set up the n8n workflow "Invoices from Gmail to Drive and Google Sheets" (https://n8n.io/workflows/3016). It uses: Google Sheets, HTTP Request, Google Drive, Gmail, Basic LLM Chain, OpenAI Model, Structured Output Parser. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Questions
Yes. Juan Carlos Cavero Gracia published it free on n8n.io as a verified creator, and it has 27K views. It runs on n8n Cloud or a self-hosted n8n instance.
Google Sheets, Google Drive, Gmail, OpenAI Model. The other 3 nodes are built into n8n.
Similar workflows
NameViews
- Invoice data extraction with LlamaParse and OpenAI37K
- 🎨 AI Design Team - Generate and Review AI Images with Ideogram and OpenAI9,990
- Automate social media content with AI for Instagram, Facebook, LinkedIn & X16K
- ✨🔪 Advanced AI Powered Document Parsing & Text Extraction with Llama Parse16K
- Automate SEO blog creation + social media with GPT-4, Perplexity and WordPress5,798
- Explore n8n Nodes in a Visual Reference Library5,197
- Resume Screening & Behavioral Interviews with Gemini, Elevenlabs, & Notion ATS5,127
- Automated Research Report Generation with AI, Wiki, Search & Gmail/Telegram4,632