Process OCR documents from Google Drive into searchable knowledge base with OpenAI & Pinecone
How it works This workflow automates a full RAG ingestion pipeline. When a new OCR JSON file is added to a Google Drive folder, the workflow extracts lesson metadata, parses and cleans the Arabic text, generates semantic chunks, creates AI embeddings, and stores them in a Pinecone vector index. After processing, the file is automatically moved to an archive folder to prevent duplicates. Set up steps Follow the sticky notes inside the workflow for detailed instructions. Connect your Google Drive credentials. Replace the input folder ID and archive folder ID with your own. Connect your OpenAI account for embeddings. Connect your Pinecone API key and select your index. The workflow is ready to run once credentials and folder paths are configured.
By osama godaRecover no-show appointments with Calendly, Telegram & email alerts
Description: Recover missed opportunities automatically with this n8n automation template. The workflow connects with Calendly, identifies no-show meetings, and instantly sends personalized Telegram messages encouraging leads to reschedule. It then notifies the assigned sales representative via email, ensuring timely human follow-up. Perfect for sales teams, consultants, and customer success managers who want to minimize no-shows, improve conversion rates, and keep pipelines warm — all without manual tracking. What This Template Does (Step-by-Step) ⏰ Runs Every Hour Automatically triggers every hour to check your Calendly events for recently missed meetings. 📥 Fetch Active Calendly Appointments Retrieves all scheduled events from Calendly using your user URI and event metadata. 🔍 Filter for No-Shows (30+ Minutes Past) Uses a built-in logic block to detect appointments that ended over 30 minutes ago and were not attended. 🎯 Check Lead Intent Processes only leads tagged as “High Intent” in metadata to focus recovery efforts on qualified prospects. 💬 Send Telegram Message to Lead Sends a personalized message to the lead’s Telegram ID, including a direct reschedule link and friendly tone from your sales team. 📧 Notify Assigned Sales Rep via Email Alerts the relevant rep (from metadata) that the lead missed a meeting and has received an automated Telegram follow-up. Includes contact name, status update, and meeting link for manual re-engagement. 🔁 Continuous Follow-Up Automation Repeats hourly, ensuring no missed appointment goes unnoticed — even outside working hours. Key Features 🤖 Smart detection of no-shows via Calendly API 💬 Telegram message automation with personalization 📧 Sales rep email alerts with complete context 🎯 Filters by “High Intent” tag to focus efforts ⚙️ Easy setup with environment variables and credentials Use Cases 📞 Automatically re-engage missed sales calls 📅 Reduce no-show rates for Calendly meetings 💬 Keep your sales pipeline active and responsive 📢 Notify sales reps in real time about recovery actions Required Integrations Calendly API – to fetch scheduled events and meeting details Telegram API – to send automated reschedule messages SMTP or Gmail – to alert the assigned sales representative Why Use This Template? ✅ Saves hours of manual follow-up effort ✅ Boosts reschedule rate for missed meetings ✅ Keeps high-value leads warm and engaged ✅ Ensures your sales reps never miss a no-show
By Rahul Joshi