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

About

🚀 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 inf