Legal Case Research Extractor, Data Miner with Bright Data MCP & Google Gemini
Notice Community nodes can only be installed on self-hosted instances of n8n. Who this is for The Legal Case Research Extractor is a powerful automated workflow designed for legal tech teams, researchers, law firms, and data scientists focused on transforming unstructured legal case data into actionable, structured insights. This workflow is tailored for: Legal Researchers automating case law data mining Litigation Support Teams handling large volumes of case records LawTech Startups building AI-powered legal research assistants Compliance Analysts extracting case-specific insights AI Developers working on legal NLP, summarization, and search engines What problem is this workflow solving? Legal case data is often locked in semi-structured or raw HTML formats, scattered across jurisdiction-specific websites. Manually extracting and processing this data is tedious and inefficient. This workflow automates: Extraction of legal case data via Bright Data's powerful MCP infrastructure Parsing of HTML into clean, readable text using Google Gemini LLM Structuring and delivering the output through webhook and file storage What this workflow does Input Set the Legal Case Research URL node is responsible for setting the legal case URL for the data extraction. Bright Data MCP Data Extractor Bright Data MCP Client For Legal Case Research node is responsible for the legal case extraction via the Bright Data MCP tool - scrapeashtml Case Extractor Google Gemini based Case Extractor is responsible for producing a paginated list of cases Loop through Legal Case URLs Receives a collection of legal case links to process Each URL represents a different case from a target legal website Bright Data MCP Scraping Utilizes Bright Dataβs scrapeashtml MCP mode Retrieves raw HTML content of each legal case Google Gemini LLM Extraction Transforms raw HTML into clean, structured text Performs additional information extraction if required (e.g., case summary, court, jurisdiction etc.) Webhook Notification Sends extracted legal case content to a configurable webhook URL Enables downstream processing or storage in legal databases Binary Conversion & File Persistence Converts the structured text to binary format Saves the final response to disk for archival or further processing Pre-conditions Knowledge of Model Context Protocol (MCP) is highly essential. Please read this blog post - model-context-protocol You need to have the Bright Data account and do the necessary setup as mentioned in the Setup section below. You need to have the Google Gemini API Key. Visit Google AI Studio You need to install the Bright Data MCP Server @brightdata/mcp You need to install the n8n-nodes-mcp Setup Please make sure to setup n8n locally with MCP Servers by navigating to n8n-nodes-mcp Please make sure to install the Bright Data MCP Server @brightdata/mcp on your local machine. Sign up at Bright Data. Create a Web Unlocker proxy zone called mcp_unlocker on Bright Data control panel. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. In n8n, configure the Google Gemini(PaLM) Api account with the Google Gemini API key (or access through Vertex AI or proxy). In n8n, configure the credentials to connect with MCP Client (STDIO) account with the Bright Data MCP Server as shown below. Make sure to copy the Bright Data APITOKEN within the Environments textbox above as APITOKEN=<your-token> How to customize this workflow to your needs Target New Legal Portals Modify the legal case input URLs to scrape from different state or federal case databases Customize LLM Extraction Modify the prompt to extract specific fields: case number, plaintiff, case summary, outcome, legal precedents etc. Add a summarization step if needed Enhance Loop Handling Integrate with a Google Sheet or API to dynamically fetch case URLs Add error handling logic to skip failed cases and log them Improve Security & Compliance Redact sensitive information before sending via webhook Store processed case data in encrypted cloud storage Output Formats Save as PDF, JSON, or Markdown Enable output to cloud storage (S3, Google Drive) or legal document management systems
Turn any Youtube video into VIRAL shorts
For Who? Content Creators Youtube Automation Marketing Team --- How it works? 1 - Enter the video ID (in Edit Field Node) you want to use as a base to create Short Form videos 2 - Use yt-transcript-api (self-hosted on docker) to retrieve the transcript of the video 3 - Format the transcript to be usable by an LLM 4 - LLM select clips based on specific rules (prompt customizable) 5 - Split out the selected Clips and perform a loop for each Clip 6 - Use yt-clip-api (self-hosted on docker) to edit the video in ready-to-use Short Form videos --- What you get? π§© Copy-Paste Setup β Youβll get a straightforward, easy-to-follow system with clear instructions, even with minimal technical skills. ποΈ Built-in Customization Guide β The documentation includes a dedicated section to help you easily adjust the system to your own channel, video style, or workflow needs. π¬ Full Personalized Support β Iβll personally help you until the workflow is fully running on your side. ++System Cost to run++: $0 ++Time to Setup++: 20-40min (depending on your experience) --- β οΈ PRE-REQUISITES Before purchasing, please make sure you meet the following requirements: The YouTube channel you want to clip includes face-cam + screen recording (like on my videos). You have basic knowledge of code (enough to follow simple setup instructions). You can also use AI to help you π --- π¨βπ»Β More Workflows : https://n8n.io/creators/nasser/
Create a Witty Telegram Bot with AI-Powered Humor, Roasts & Stats using OpenRouter
GiggleGPTBot β Witty Telegram Bot with AI & Postgres π Overview GiggleGPTBot is a witty Telegram bot built with n8n, OpenRouter, and Postgres. It delivers short jokes, motivational one-liners, and playful roasts, responds to mentions, and posts scheduled witty content. The workflow also tracks user activity and provides lightweight statistics and leaderboards. --- β¨ Features π€ AI-powered humor engine β replies with jokes, motivation, random witty lines, or sarcastic roasts. π¬ Command support β /joke, /inspire, /random, /roast, /help, /stats, /top. π― Mention detection β replies when users tag @GiggleGPTBot. β° Scheduled posts β morning jokes, daily motivation, and random wisdom at configured times. π User analytics β counts messages, commands, reactions, and generates leaderboards. ποΈ Postgres persistence β robust schema with tables for messages, responses, stats, and schedules. --- π οΈ How It Works Triggers Telegram Trigger β receives all messages and commands from a chat. Schedule Trigger β runs hourly to check for planned posts. Processing Switch routes commands (/joke, /inspire, /random, /roast, /help, /stats, /top). Chat history fetches the latest context. Mention Analysis determines if the bot was mentioned. Generating an information response builds replies for /help, /stats, /top. AI nodes (AI response to command, AI response to mention, AI post generation) craft witty content via OpenRouter. Persistence Init Database ensures tables exist (usermessages, botresponses, botcommands, messagereactions, scheduledposts, userstats). Logging nodes update stats and store every bot/user interaction. Delivery Replies are sent back via Telegram Send nodes (Send AI response, Send info reply, Reply to Mention, Submit scheduled post). --- βοΈ Setup Instructions Create a Telegram Bot with @BotFather and get your API token. Add credentials in n8n: Telegram API (your bot token) OpenRouter (API key from openrouter.ai) Postgres (use your DB, Supabase works well). Run the Init Database node once to create all required tables. (Optional) Seed schedule with the Adding a schedule node β it inserts: Morning joke at 06:00 Daily motivation at 09:00 Random wisdom at 17:00 (Adjust chat_id to your group/channel ID.) Activate workflow and connect Telegram Webhook or Polling. --- π Database Schema user\_messages β stores user chat messages. bot\_responses β saves bot replies. bot\_commands β logs command usage. message\_reactions β tracks reactions. scheduled\_posts β holds scheduled jokes/wisdom/motivation. user\_stats β aggregates per-user message/command counts and activity. --- π Example Commands /joke β witty one-liner with light irony. /inspire β short motivational phrase. /random β unexpected witty remark. /roast β sarcastic roast (no offensive targeting). /stats β shows your personal stats. /top β displays leaderboard. /help β lists available commands. @GiggleGPTBot + message β bot replies in context. --- π Customization Ideas Add new command categories (/quote, /fact, /news). Expand analytics with reaction counts or streaks. Localize prompts into multiple languages. Adjust CRON schedules for posts. --- β Requirements Telegram Bot token OpenRouter API key Postgres database --- π¦ Import this workflow, configure credentials, run the DB initializer β and your witty AI-powered Telegram companion is ready!
Let AI agents manage clients, tasks π οΈ Clockify tool MCP server πͺ all operations
Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community Complete MCP server exposing all Clockify Tool operations to AI agents. Zero configuration needed - all 25 operations pre-built. β‘ Quick Setup Import this workflow into your n8n instance Activate the workflow to start your MCP server Copy the webhook URL from the MCP trigger node Connect AI agents using the MCP URL π§ How it Works β’ MCP Trigger: Serves as your server endpoint for AI agent requests β’ Tool Nodes: Pre-configured for every Clockify Tool operation β’ AI Expressions: Automatically populate parameters via $fromAI() placeholders β’ Native Integration: Uses official n8n Clockify Tool tool with full error handling π Available Operations (25 total) Every possible Clockify Tool operation is included: π§ Client (5 operations) β’ Create a client β’ Delete a client β’ Get a client β’ Get many clients β’ Update a client π§ Project (5 operations) β’ Create a project β’ Delete a project β’ Get a project β’ Get many projects β’ Update a project π·οΈ Tag (4 operations) β’ Create a tag β’ Delete a tag β’ Get many tags β’ Update a tag π§ Task (5 operations) β’ Create a task β’ Delete a task β’ Get a task β’ Get many tasks β’ Update a task π§ Timeentry (4 operations) β’ Create a time entry β’ Delete a time entry β’ Get a time entry β’ Update a time entry π€ User (1 operations) β’ Get many users π§ Workspace (1 operations) β’ Get many workspaces π€ AI Integration Parameter Handling: AI agents automatically provide values for: β’ Resource IDs and identifiers β’ Search queries and filters β’ Content and data payloads β’ Configuration options Response Format: Native Clockify Tool API responses with full data structure Error Handling: Built-in n8n error management and retry logic π‘ Usage Examples Connect this MCP server to any AI agent or workflow: β’ Claude Desktop: Add MCP server URL to configuration β’ Custom AI Apps: Use MCP URL as tool endpoint β’ Other n8n Workflows: Call MCP tools from any workflow β’ API Integration: Direct HTTP calls to MCP endpoints β¨ Benefits β’ Complete Coverage: Every Clockify Tool operation available β’ Zero Setup: No parameter mapping or configuration needed β’ AI-Ready: Built-in $fromAI() expressions for all parameters β’ Production Ready: Native n8n error handling and logging β’ Extensible: Easily modify or add custom logic > π Free for community use! Ready to deploy in under 2 minutes.
π οΈ Bitwarden tool MCP server πͺ all 19 operations
Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community Complete MCP server exposing all Bitwarden Tool operations to AI agents. Zero configuration needed - all 19 operations pre-built. β‘ Quick Setup Import this workflow into your n8n instance Activate the workflow to start your MCP server Copy the webhook URL from the MCP trigger node Connect AI agents using the MCP URL π§ How it Works β’ MCP Trigger: Serves as your server endpoint for AI agent requests β’ Tool Nodes: Pre-configured for every Bitwarden Tool operation β’ AI Expressions: Automatically populate parameters via $fromAI() placeholders β’ Native Integration: Uses official n8n Bitwarden Tool tool with full error handling π Available Operations (19 total) Every possible Bitwarden Tool operation is included: π§ Collection (4 operations) β’ Delete a collection β’ Get a collection β’ Get many collections β’ Update a collection π Event (1 operations) β’ Get many events π§ Group (7 operations) β’ Create a group β’ Delete a group β’ Get a group β’ Get many groups β’ Get group members β’ Update a group β’ Update group members π§ Member (7 operations) β’ Create a member β’ Delete a member β’ Get a member β’ Get groups for a member β’ Get many members β’ Update a member β’ Update groups for a member π€ AI Integration Parameter Handling: AI agents automatically provide values for: β’ Resource IDs and identifiers β’ Search queries and filters β’ Content and data payloads β’ Configuration options Response Format: Native Bitwarden Tool API responses with full data structure Error Handling: Built-in n8n error management and retry logic π‘ Usage Examples Connect this MCP server to any AI agent or workflow: β’ Claude Desktop: Add MCP server URL to configuration β’ Custom AI Apps: Use MCP URL as tool endpoint β’ Other n8n Workflows: Call MCP tools from any workflow β’ API Integration: Direct HTTP calls to MCP endpoints β¨ Benefits β’ Complete Coverage: Every Bitwarden Tool operation available β’ Zero Setup: No parameter mapping or configuration needed β’ AI-Ready: Built-in $fromAI() expressions for all parameters β’ Production Ready: Native n8n error handling and logging β’ Extensible: Easily modify or add custom logic > π Free for community use! Ready to deploy in under 2 minutes.