Book club manager & recommendation engine with Mistral AI and Gemini Vision
π 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:
- 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.
- Data Initialization: It initializes a data table with book information, potentially including titles, authors, genres, and other relevant details.
- 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.
- 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.
- Conditional Logic: It employs conditional logic (
IfandSwitchnodes) to direct the workflow based on various conditions, such as the type of trigger or the outcome of AI processing. - Data Manipulation: It uses
Edit Fields (Set),Loop Over Items (Split in Batches),Aggregate, andSplit Outnodes to prepare, process, and structure data for AI models and subsequent actions. - External API Interaction: It can make HTTP requests to external APIs, potentially to fetch additional book data or integrate with other services.
- Email Notifications: It can send email notifications via Gmail, likely for sharing recommendations, meeting updates, or other book club communications.
- File Handling: It includes nodes for converting data to and extracting data from files, suggesting it can handle various data formats.
- 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 Requestnode, you might need credentials for other external APIs.
Setup/Usage
- Import the workflow: Download the provided JSON and import it into your n8n instance.
- Configure Credentials:
- Set up your Mistral AI credentials in the
Mistral Cloud Chat Modelnode. - Set up your Google Gemini credentials in the
Google Gemininode. - Configure your Gmail credentials in the
Gmailnode.
- Set up your Mistral AI credentials in the
- Configure Trigger:
- If using the
Webhooktrigger, 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.
- If using the
- Customize Data Table: Populate the
Data tablenode with your initial book club data. - Adjust AI Prompts: Customize the prompts and parameters in the
Mistral Cloud Chat ModelandGoogle Gemininodes to tailor the recommendations and image analysis to your specific book club needs. - Configure Email Content: Modify the
Gmailnode to define the subject, body, and recipients of the recommendation emails. - 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.
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.
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)