osama goda
Workflows by osama goda
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. 1. Connect your Google Drive credentials. 2. Replace the input folder ID and archive folder ID with your own. 3. Connect your OpenAI account for embeddings. 4. Connect your Pinecone API key and select your index. The workflow is ready to run once credentials and folder paths are configured.
Auto-post YouTube Shorts from Google Drive with OpenRouter AI titles & descriptions
## How it works This workflow automatically uploads YouTube Shorts from a Google Drive folder. It picks one video at each run, generates a YouTube-optimized title, description, and hashtags using an AI model, uploads the video through YouTube’s resumable upload API, and finally moves the processed video to a “Posted” folder. ## Key steps Run on a schedule (daily/hourly/custom CRON) Fetch one video from a selected Google Drive folder Generate title + description + hashtags using an LLM Prepare YouTube metadata Upload the video via resumable upload Move the file to a “posted” folder to avoid duplicates ## Setup instructions Connect your Google Drive credentials Connect your YouTube OAuth2 credentials Update the Drive folder IDs (input + posted folders) Edit the “Set variables” node to change store name, country, coupon code, and tone Review the prompt in the AI node if you want to customize content style All technical details are documented inside the sticky notes within the workflow.
Create an AI-powered Telegram customer support bot with lead management
🧠 AI Telegram Customer Support Assistant + Lead Manager This n8n workflow provides a fully automated AI-driven customer support assistant connected to Telegram, with built-in lead management, knowledge-base querying, and context-aware answers. ⭐ What this workflow does Receives user messages from Telegram Logs all incoming/outgoing messages into a Data Table Checks if a lead exists for the user (via chat_id) Creates new leads automatically if needed Builds an AI-ready context (user info + lead info + latest message) Uses the AI Agent to answer questions using: FAQ database Services table (programs, prices, descriptions) Settings table (agency info) Lead update tool Sends a natural, friendly reply back to Telegram Updates leads in real time (name, phone, email, notes…) 📦 Required Data Tables (to be created by the user) leads Stores all user information (full_name, phone, email, etc.) services List of available programs/services with prices, duration, category. faq Frequently asked questions with answers and optional tags. settings Company/agency details used by the assistant. chat_logs Logs all messages exchanged with users (user + bot). 🔧 Required Credentials Telegram Bot API Key AI Model Credential (OpenAI, OpenRouter, Groq…) No other credentials required. 🚀 How to use it Import the workflow into your n8n instance Create the required Data Tables as defined inside the Sticky Notes Add your credentials (Telegram + AI Model) Customize the prompt to match your business Activate the workflow — you're ready to go! 💡 Suitable for: Travel agencies Customer support chatbots Lead qualification + automation AI knowledge-based assistants Telegram-first businesses