Help Building Full AI eBook Automation Workflow (Gemini 2.5 + Google Drive/Slides/Sheets + FFmpeg Video)

Help me Build my Workflow
, , , ,
1

Hello n8n Community,

I’m working on an automation project that has become too complex for me to handle alone, and I’d really appreciate expert guidance (or even direct collaboration from someone in this community who can help me build it properly).

:bullseye: Goal:

I want to create a full AI-powered eBook pipeline using Google Gemini 2.5 as the main content + image generator, and n8n as the orchestrator.

Whenever I provide a topic, the workflow should:

  1. Generate a 12–15 page eBook (content + images) styled according to one of 10 predefined Visme templates (hardcoded mapping).

  2. Generate a professional cover image.

  3. Generate 3 mockup images for marketing.

  4. Generate a short promo video using FFmpeg (with Gemini providing the image + text assets).

  5. Automatically create a folder in Google Drive (named after the topic).

  6. Save the Google Slides eBook, images, and video into that folder.

  7. Automatically create (or update) a Google Sheet in Drive called “Ebook Index”, and log:

    • Topic

    • Template Link

    • Sales Description (Gemini-generated)

    • Google Slides Link

    • Cover Image Link

    • Mockup Image Links

    • Video Link

    • Folder Link

:key: Key Requirements:

  • Use Google Gemini 2.5 for:

    • Ebook content generation (12–15 pages max).

    • Image prompts (cover + mockups + video assets).

    • Sales description.

  • Use Google Slides to format the eBook (not PDF).

  • Auto-create Google Drive folder per topic.

  • Auto-create Google Sheet if it doesn’t exist and append results each run.

  • Use FFmpeg for basic video assembly (images + text → 30s promo).

:warning: Challenges I’ve Faced:

  • I tried building this in n8n myself but ran into missing parameters (file names for Drive uploads, disconnected triggers, etc.).

  • I also tried Google Opal, but it only generated text descriptions — no images, no structured Slides, no Drive/Sheets integration, and no video.

  • I have a workflow generated by Claude AI, but I can’t get the setup right in n8n. I’m happy to share that file if it helps.

:folded_hands: What I Need:

  • Guidance (or a working workflow) to tie these pieces together inside n8n.

  • Ideally, someone who can help me structure this workflow so it doesn’t break (and can be reused for multiple topics).

  • If you can help me build this, let me know if we can connect directly (WhatsApp or Telegram) to discuss further.

  • I’m also open to a profit-sharing model after selling the eBooks if someone wants to partner with me on this project.

Thanks in advance for your support!