Extract Purchase Orders from Gmail using Gemini AI and Save to Google Sheets

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. An n8n automation workflow template by SayOne Technologies.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• gmail
• code
• ai-agent
• google-gemini-chat-model

Capabilities

• 5 nodes
• 29 views

Information