Back to Catalog

Book club manager & recommendation engine with Mistral AI and Gemini Vision

Jordan HoyleJordan Hoyle
24 views
2/3/2026
Official Page

πŸ“š The Literary Curator: AI Book Club Manager & Recommendation Engine

Transform your n8n instance into a sophisticated, automated backend for a book club. This "Literary Curator" workflow acts as an all-in-one administrator, archivist, and reading guide. It intelligently analyzes your club's collective reading history to generate personalized recommendations, onboard new members, and manage all your club's data via email, chat, and web forms.

✨ Key Features

Automated Recommendation Engine: A weekly scheduled agent (using Mistral AI) analyzes the club's "Book Archive" to generate 10 fresh, non-duplicate book recommendations with witty, personalized "Why This Read" justifications.

Visual Bookshelf Scanning: Uses Google Gemini Vision to analyze photos of physical bookshelves or Goodreads screenshots and automatically populate the database.

The "Literary Oracle" Chatbot: A conversational AI agent that has full context of the club's history. It can answer questions, add books to the archive, or manage members via chat.

Full Member Management: Automated onboarding flows for new members, including welcome emails and database entry.

Multi-Channel Interaction: Users can interact via Webhooks (API), n8n Forms, or Chat.

Weekly Newsletters: Automatically compiles the AI's "Vibe Check" summary and top 10 recommendations into a beautifully formatted HTML email sent via Gmail.

πŸ€– AI Models Used

Mistral Cloud (Large/Medium): Powers the core reasoning, recommendation logic, and the chat Oracle.

Google Gemini (PaLM/Flash): Used for vision analysis (scanning bookshelf photos) and generating discussion prompts.

πŸ› οΈ Setup Guide

Prerequisites:

n8n version with LangChain support.

Mistral Cloud API Key

Google Gemini API Key

Gmail OAuth2 Credentials

πŸš€ How to Use

Automated Schedule

By default, the workflow runs every Friday at 7:00 PM. It checks the archive, generates a new weekly summary and recommendation list, saves it to the database, and emails all members.

User Forms

The workflow includes built-in n8n Forms for user interaction:

Feedback Form

For members to rate books or request specific genres.

Idea Board: For submitting general reading ideas.

Upload Form

Accepts images of bookshelves or Goodreads exports to bulk-import reading history.

API / App Backend

This workflow exposes several POST webhooks (e.g., /api/ai/chat, /api/archive/add), allowing you to build a custom frontend (React, Glide, etc.) on top of this n8n workflow.

n8n Book Club Manager: Recommendation Engine with Mistral AI and Gemini Vision

This n8n workflow acts as a sophisticated book club manager, leveraging advanced AI models (Mistral AI and Google Gemini Vision) to provide book recommendations and manage the book club's operations. It can be triggered manually or on a schedule, process book data, generate recommendations, and even send out email notifications.

What it does

This workflow automates several key aspects of managing a book club:

  1. Triggering: It can be triggered either manually via a webhook (e.g., from a form submission or an external application) or on a predefined schedule.
  2. Data Initialization: It initializes a data table with book information, potentially including titles, authors, genres, and other relevant details.
  3. Recommendation Generation (Mistral AI): It uses a Mistral AI Chat Model to generate book recommendations based on provided criteria or existing book data. This likely involves analyzing genres, themes, or user preferences.
  4. Image Analysis (Google Gemini Vision): It can process images (e.g., book covers) using Google Gemini Vision to extract visual information, which could further enhance recommendations or provide descriptive summaries.
  5. Conditional Logic: It employs conditional logic (If and Switch nodes) to direct the workflow based on various conditions, such as the type of trigger or the outcome of AI processing.
  6. Data Manipulation: It uses Edit Fields (Set), Loop Over Items (Split in Batches), Aggregate, and Split Out nodes to prepare, process, and structure data for AI models and subsequent actions.
  7. External API Interaction: It can make HTTP requests to external APIs, potentially to fetch additional book data or integrate with other services.
  8. Email Notifications: It can send email notifications via Gmail, likely for sharing recommendations, meeting updates, or other book club communications.
  9. File Handling: It includes nodes for converting data to and extracting data from files, suggesting it can handle various data formats.
  10. Workflow Response: It can respond to the initial webhook trigger, providing feedback or results back to the initiating system.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running instance of n8n.
  • Mistral AI Credentials: API access and credentials for Mistral AI Chat Model.
  • Google Gemini Vision Credentials: API access and credentials for Google Gemini.
  • Gmail Account: Credentials for a Gmail account to send emails.
  • External Services (Optional): Depending on how you configure the HTTP Request node, you might need credentials for other external APIs.

Setup/Usage

  1. Import the workflow: Download the provided JSON and import it into your n8n instance.
  2. Configure Credentials:
    • Set up your Mistral AI credentials in the Mistral Cloud Chat Model node.
    • Set up your Google Gemini credentials in the Google Gemini node.
    • Configure your Gmail credentials in the Gmail node.
  3. Configure Trigger:
    • If using the Webhook trigger, copy the webhook URL and configure your external application or form to send data to it.
    • If using the Schedule Trigger, configure the desired schedule (e.g., daily, weekly).
    • If using the n8n Form Trigger, configure the form fields as needed.
  4. Customize Data Table: Populate the Data table node with your initial book club data.
  5. Adjust AI Prompts: Customize the prompts and parameters in the Mistral Cloud Chat Model and Google Gemini nodes to tailor the recommendations and image analysis to your specific book club needs.
  6. Configure Email Content: Modify the Gmail node to define the subject, body, and recipients of the recommendation emails.
  7. Activate the Workflow: Once configured, activate the workflow to start automating your book club management.

Related Templates

Track competitor SEO keywords with Decodo + GPT-4.1-mini + Google Sheets

This workflow automates competitor keyword research using OpenAI LLM and Decodo for intelligent web scraping. Who this is for SEO specialists, content strategists, and growth marketers who want to automate keyword research and competitive intelligence. Marketing analysts managing multiple clients or websites who need consistent SEO tracking without manual data pulls. Agencies or automation engineers using Google Sheets as an SEO data dashboard for keyword monitoring and reporting. What problem this workflow solves Tracking competitor keywords manually is slow and inconsistent. Most SEO tools provide limited API access or lack contextual keyword analysis. This workflow solves that by: Automatically scraping any competitor’s webpage with Decodo. Using OpenAI GPT-4.1-mini to interpret keyword intent, density, and semantic focus. Storing structured keyword insights directly in Google Sheets for ongoing tracking and trend analysis. What this workflow does Trigger β€” Manually start the workflow or schedule it to run periodically. Input Setup β€” Define the website URL and target country (e.g., https://dev.to, france). Data Scraping (Decodo) β€” Fetch competitor web content and metadata. Keyword Analysis (OpenAI GPT-4.1-mini) Extract primary and secondary keywords. Identify focus topics and semantic entities. Generate a keyword density summary and SEO strength score. Recommend optimization and internal linking opportunities. Data Structuring β€” Clean and convert GPT output into JSON format. Data Storage (Google Sheets) β€” Append structured keyword data to a Google Sheet for long-term tracking. Setup Prerequisites If you are new to Decode, please signup on this link visit.decodo.com n8n account with workflow editor access Decodo API credentials OpenAI API key Google Sheets account connected via OAuth2 Make sure to install the Decodo Community node. Create a Google Sheet Add columns for: primarykeywords, seostrengthscore, keyworddensity_summary, etc. Share with your n8n Google account. Connect Credentials Add credentials for: Decodo API credentials - You need to register, login and obtain the Basic Authentication Token via Decodo Dashboard OpenAI API (for GPT-4o-mini) Google Sheets OAuth2 Configure Input Fields Edit the β€œSet Input Fields” node to set your target site and region. Run the Workflow Click Execute Workflow in n8n. View structured results in your connected Google Sheet. How to customize this workflow Track Multiple Competitors β†’ Use a Google Sheet or CSV list of URLs; loop through them using the Split In Batches node. Add Language Detection β†’ Add a Gemini or GPT node before keyword analysis to detect content language and adjust prompts. Enhance the SEO Report β†’ Expand the GPT prompt to include backlink insights, metadata optimization, or readability checks. Integrate Visualization β†’ Connect your Google Sheet to Looker Studio for SEO performance dashboards. Schedule Auto-Runs β†’ Use the Cron Node to run weekly or monthly for competitor keyword refreshes. Summary This workflow automates competitor keyword research using: Decodo for intelligent web scraping OpenAI GPT-4.1-mini for keyword and SEO analysis Google Sheets for live tracking and reporting It’s a complete AI-powered SEO intelligence pipeline ideal for teams that want actionable insights on keyword gaps, optimization opportunities, and content focus trends, without relying on expensive SEO SaaS tools.

Ranjan DailataBy Ranjan Dailata
161

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting β€” all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow β€” reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n β€” combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

Automated YouTube video uploads with 12h interval scheduling in JST

This workflow automates a batch upload of multiple videos to YouTube, spacing each upload 12 hours apart in Japan Standard Time (UTC+9) and automatically adding them to a playlist. βš™οΈ Workflow Logic Manual Trigger β€” Starts the workflow manually. List Video Files β€” Uses a shell command to find all .mp4 files under the specified directory (/opt/downloads/单词卑/A1-A2). Sort and Generate Items β€” Sorts videos by day number (dayXX) extracted from filenames and assigns a sequential order value. Calculate Publish Schedule (+12h Interval) β€” Computes the next rounded JST hour plus a configurable buffer (default 30 min). Staggers each video’s scheduled time by order Γ— 12 hours. Converts JST back to UTC for YouTube’s publishAt field. Split in Batches (1 per video) β€” Iterates over each video item. Read Video File β€” Loads the corresponding video from disk. Upload to YouTube (Scheduled) β€” Uploads the video privately with the computed publishAtUtc. Add to Playlist β€” Adds the newly uploaded video to the target playlist. πŸ•’ Highlights Timezone-safe: Pure UTC ↔ JST conversion avoids double-offset errors. Sequential scheduling: Ensures each upload is 12 hours apart to prevent clustering. Customizable: Change SPANHOURS, BUFFERMIN, or directory paths easily. Retry-ready: Each upload and playlist step has retry logic to handle transient errors. πŸ’‘ Typical Use Cases Multi-part educational video series (e.g., A1–A2 English learning). Regular content release cadence without manual scheduling. Automated YouTube publishing pipelines for pre-produced content. --- Author: Zane Category: Automation / YouTube / Scheduler Timezone: JST (UTC+09:00)

ZaneBy Zane
226