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