Automate PDF Attachment Management from Gmail to Google Drive and Sheets

• Automatically save PDF invoices from Gmail to Google Drive.
• Log invoice details into Google Sheets for easy tracking.
• Extract key data from PDF invoices using AI.
• Organize invoices into specific folders in Google Drive.

Triggers on new unread emails in Gmail with attachments. Checks if the email contains invoice-related content. Downloads the PDF attachment and uploads it to Google Drive. Extracts relevant data from the PDF using OpenAI's model. Appends the extracted data to a Google Sheets document.

1. 1
   Import the workflow template into n8n.
2. 2
   Set up Gmail and Google Drive credentials.
3. 3
   Configure Google Sheets credentials.
4. 4
   Specify the Google Drive folder for storing invoices.
5. 5
   Test the workflow to ensure proper functionality.