Extract purchase orders from Gmail using Gemini AI and save to Google Sheets

🚀 AI-Powered Email to Purchase Order Workflow

Automatically scan your inbox for new purchase order requests, extract order details using Gemini AI, and log them into Google Sheets — all without manual effort.

---

✨ Core Capabilities - ⏱ Runs every minute to check unread emails - 📧 Filters emails by subject - 🤖 Uses Gemini AI to summarize email content & extract structured order details - 📅 Formats dates into ISO calendar weeks - 📊 Adds product data from Google Sheets to complete order info - ✅ Appends final purchase order records into a Google Sheet (without replacing previous ones)

---

🛠 Setup Essentials - 📩 Gmail account for fetching unread emails - 🔑 Google Gemini (PaLM) API credentials - 📒 Google Sheet with predefined purchase order headers

---

📖 Activation Guide 1. ⚙️ Configure Gmail & Google Sheets credentials in n8n 2. 🎯 Adjust the subject filter to match your email rules 3. 🔌 Connect Gemini AI with your API credentials 4. 📑 Create a Google Sheet with the required headers 5. ▶️ Activate the workflow and let it run in the background