n8n Automated Workflow for Daily MCQs

I need a fully automated workflow in n8n that will run daily and perform the following steps: Source Material Connect to a single Google Drive folder that contains multiple eBooks (PDF/EPUB/DOCX). Each day, randomly pick one eBook from the folder. Extract text from the selected file (using Apache Tika or similar solution). MCQ Generation From the extracted content, generate exactly 10 multiple-choice questions (MCQs) daily. MCQs should follow this structure: question (short, clear) options (A, B, C, D) correct (answer key) explanation (short, ≤25 words) difficulty (Easy/Medium) The topic for MCQs should be configurable (default: “General Knowledge for Indian Govt Exams”). Ensure questions are in strict JSON format. Video Creation (YouTube Shorts format) Convert the 10 MCQs into a 9:16 “PPT-style” video with two slides per question: Slide 1: Question + Options Slide 2: Correct Answer + Explanation Each question + answer should show for a few seconds (total video length ≤60s). Video must have a plain/gradient background with clear readable text (using ffmpeg or similar). Optional: add a background music track (looped, low volume). YouTube Upload Automatically upload the generated video daily to my YouTube channel as a Short. Add title, description (with topic + #Shorts), category (Education), and tags. Uploads should be set as public by default. Trigger & Config Workflow should run automatically every day at a scheduled time (IST). Should also support manual execution via webhook with a custom prompt (to override topic or ebook folder). Allow environment variables for customization (font, colors, duration per slide, etc.). Requirements for Freelancer: Proven experience with n8n automation. Strong skills in Google Drive API integration, OpenAI (or other LLMs), ffmpeg scripting, YouTube API. Ability to set up Apache Tika or equivalent for text extraction. Deliver a production-ready n8n workflow JSON file that I can import and run. Provide setup instructions (including environment variables, prerequisites, Docker/installation notes). Deliverables: Importable n8n workflow JSON file. Documentation for setup and configuration. Testing to confirm that: 10 MCQs are generated daily. Video is correctly produced in Shorts format (≤60s, vertical). Video uploads automatically to YouTube.

Project ID: 39749880