🔬 Extract purchase orders from Gmail using Gemini AI and save to Google Sheets
⚡ 783 views · 🔬 Document Extraction & Analysis
Description
🚀 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
- ⚙️ Configure Gmail & Google Sheets credentials in n8n
- 🎯 Adjust the subject filter to match your email rules
- 🔌 Connect Gemini AI with your API credentials
- 📑 Create a Google Sheet with the required headers
- ▶️ Activate the workflow and let it run in the background
🎨 Customizing the Workflow
- 🔍 Email Filters → Change keywords in the filter node to match your purchase order email subjects
- 🏷 Order Fields → Modify Set and Append to Google Sheet nodes if your schema differs
- ✍️ AI Instructions → Adjust the AI Agent’s prompt to fit your company’s email style or product details
- ⏲ Frequency → Update the Cron node if you want to scan emails less often
- 📂 Target Google Sheet → Point to a different sheet or tab depending on your department or customer
🔗 Nodes Used
Cron, Google Sheets, Gmail, Filter, AI Agent, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File