Invoices from Gmail to Drive and Google Sheets

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 1. Active Gmail, Google Drive, and Google Sheets accounts 2. OpenAI API key (GPT-4o model access) 3. n8n instance with credentials manager

Steps 1. 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

2. 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