Automatic email invoice archiving & data extraction with Gmail, Drive & AI

n8n template #10923

Summary

Quick overview Automatically collect invoice PDFs from Gmail, archive them in Google Drive or an optional FTP/SFTP server, extract structured invoice data with AI, and record the results in Google Sheets. How it works Scheduled inbox check — A Schedule Trigger periodically checks Gmail for invoice messages matching the configured sender and attachment filters. Invoice download — Gmail nodes retrieve the matching message and download its PDF attachment. Document archiving — The PDF is uploaded to Google Drive and can optionally be copied to an FTP/SFTP server. Text extraction — n8n extracts text from text-based PDFs for AI processing without requiring OCR. AI extraction — An OpenRouter-backed

How to set it up

Open template #10923 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 5 credentials under Credentials → Add credential: Google Sheets, Google Drive, FTP, Gmail, OpenRouter Chat Model. Then open each of those nodes and pick the credential.
Check the model in the AI Agent node. The template may point at a model your account can't use; swap it for one you have access to.
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 "Automatic email invoice archiving & data extraction with Gmail, Drive & AI" (https://n8n.io/workflows/10923). It uses: Google Sheets, HTTP Request, Google Drive, FTP, Gmail, Code, AI Agent, OpenRouter Chat Model. 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

Google Sheets HTTP Request Google DriveFTPGmail Code AI Agent OpenRouter Chat Model

Questions

Yes. Paolo Ronco published it free on n8n.io as a verified creator, and it has 946 views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets, Google Drive, FTP, Gmail, OpenRouter Chat Model. The other 3 nodes are built into n8n.

Similar workflows

NameViews