Invoices from Gmail to Drive and Google Sheets

Go to Workflow
27,090 views
Built by Juan Carlos Cavero Gracia Juan Carlos Cavero Gracia
Created on June 06, 2026

Description

Attachments 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**: Eliminate manual data entry for invoice processing

Resources
Gmail account
Google Drive account
Google Sheets account
OpenAI API key

Setup instructions

Prerequisites
Active Gmail, Google Drive, and Google Sheets accounts
OpenAI API key (GPT-4o model access)
n8n instance with credentials manager

Steps
Gmail and Google Drive Setup:
Connect your Gmail account in n8n credentials
Connect your Google Drive account with appropriate permissions
Create a destination folder in Google Drive for invoice storage

Google Sheets Setup:
Connect your Google Sheets account
Create a spreadsheet with columns: Invoice date, Invoice Description, Total price, and Fichero
Copy your spreadsheet ID for configuration

OpenAI Setup:
Add your OpenAI API key to n8n credentials

Configure Email Filter:
Update the email filter node to match your specific sender requirements

Benefits
Time Saving**: Eliminates manual downloading, filing, and data entry
Accuracy**: AI-powered data extraction reduces human error
Organization**: Consistent file naming and storage structure
Searchability**: Creates a searchable database of all invoice information
Automation**: Runs every minute to process new emails as they arrive

Related templates
Email Parser to CRM
Document Processing Workflow
Financial Data Automation

Nodes Used (7)

Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
Gmail
n8n-nodes-base.gmail
Google Drive
n8n-nodes-base.googleDrive
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
OpenAI Model
@n8n/n8n-nodes-langchain.lmOpenAi
Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured