AI Workflows
Artificial Intelligence tools and workflows
Automate AI-Powered Newsletter Drafts from Google Sheets to Notion
Transform Google Sheets entries into polished newsletter drafts in Notion using AI. This workflow automates the drafting process, leveraging GPT-3.5 for content creation and updating statuses in Google Sheets.
n8n$9.99Automate Social Media Content Creation and Approval with WhatsApp and GPT-4
Streamline your social media content creation by sending a single WhatsApp message to generate AI-optimized posts for multiple platforms, complete with an approval workflow.
n8n$19.99Automate AI-Generated Tweets Mimicking Any Twitter User's Style
This workflow automates the creation of tweets that mimic the style of any public Twitter user using AI. Ideal for content creators and marketers, it analyzes a user's tweet style and generates new content in that style.
n8n$4.99Automate Startup Idea Generation from Reddit Discussions
This workflow automates the discovery of startup ideas by scraping Reddit posts for unmet needs, analyzing them with Gemini AI, and storing insights in Google Sheets.
n8n$9.99AI-Powered Chatbot Workflow with MySQL Database Integration
# AI-Powered Chatbot Workflow with MySQL Integration This guide shows you how to deploy a chatbot that lets you query your database using natural language. You will build a system that accepts chat messages, retains conversation history, constructs dynamic SQL queries, and returns responses generated by an AI model. By following these instructions, you will have a working solution that integrates n8n's AI Agent capabilities with MySQL. --- ## Prerequisites Before you begin, ensure that you have the following: 1. An active n8n instance (self-hosted or cloud) running version 1.50.0 or later. 2. Valid MySQL credentials configured in n8n. 3. API credentials for the Groq Chat Model (or your preferred AI language model). 4. Basic familiarity with SQL and n8n node concepts such as chat triggers and memory buffers. 5. Access to the [n8n Docs on AI Agents](https://docs.n8n.io/advanced-ai/) for further reference. --- ## Workflow Setup ### 1. Chat Interface & Trigger - **When Chat Message Received**: This node listens for incoming chat messages via a webhook. When a message arrives, it triggers the workflow immediately. ### 2. Conversation Memory - **Chat History**: This memory buffer node stores the last 10 interactions. It supplies conversation context to the AI Agent, ensuring that responses consider previous messages. ### 3. AI Agent Core - **AI Agent (Tools Agent)**: The AI Agent node orchestrates the conversation by receiving the chat input and conversation history. It dynamically generates SQL queries based on your requests and coordinates calls to external tools (such as MySQL nodes). ### 4. Database Interactions - **MySQL Node**: This node executes the SQL query generated by the AI Agent. You reference the query using an expression (e.g., `{{$node["AI Agent"].json["sql_query"]}}`), allowing the agent's output to control data retrieval. - **MySQL Schema Node**: This node retrieves a list of base tables from your MySQL database (excluding system schemas). The agent uses this information to understand the available tables. - **MySQL Definition Node**: This node fetches detailed metadata (such as column names, data types, and relationships) for a specific table. The table and schema names are supplied dynamically by the AI Agent. ### 5. Language Model Processing - **Groq Chat Model**: This node connects to the Groq Chat API to generate text completions. It processes the combined input (chat message, context, and data fetched from MySQL) and produces the final response. ### 6. Guidance & Customization - **Sticky Notes**: These nodes provide guidance on: - Switching the chat model if you wish to use another provider (e.g., OpenAI or Anthropic). - Adjusting the maximum token count per interaction. - Customizing the SQL queries and the context window size. They help you modify the workflow to suit your environment and requirements. ### Workflow Connections - The **Chat Trigger** passes the incoming message to the **AI Agent**. - The **Chat History** node supplies conversation context to the AI Agent. - The **AI Agent** calls the MySQL nodes as external tools, generating and sending dynamic SQL queries. - The **Groq Chat Model** processes the consolidated input from the agent and outputs the natural language response delivered to the user. ### Testing the Workflow 1. Send a chat message using the chat interface. 2. Observe how the AI Agent processes the input and generates a corresponding SQL query. 3. Verify that the MySQL nodes execute the query and return data. 4. Confirm that the Groq Chat Model produces a coherent natural language response. 5. Refer to the sticky notes for guidance if you need to fine-tune any node settings. --- ## Next Steps and References - **Customize Your AI Model**: Replace the Groq Chat Model with another language model (such as the OpenAI Chat Model) by updating the node credentials and configuration. - **Enhance Memory Settings**: Adjust the Chat History node's context window to retain more or fewer messages based on your needs. - **Modify SQL Queries**: Update the SQL queries in the MySQL nodes to match your specific database schema and desired data. - **Further Reading**: Consult the [n8n Docs on AI Agents](https://docs.n8n.io/advanced-ai/) for additional details and examples to expand your workflow's capabilities. - **Set Up a Website Chatbot**: Copy & Paste and replace the placeholders in the following code to embed the chatbot into your personal or company's website: [View in CodePen](https://codepen.io/olemai/pen/RNwPdVp) --- By following these steps, you will deploy a robust AI chatbot workflow that integrates with your MySQL database, allowing you to query data using natural language.
n8n$9.99Automate YouTube Video Repurposing into Diverse Content Formats with AI and Airtable
This workflow enables content creators to automatically transform YouTube videos into various content formats using AI and Airtable, maximizing content reach and efficiency.
n8n$19.99Streamline RFP Responses with Automated OpenAI Integration
Automate the RFP process by extracting questions from documents and generating responses using OpenAI, enhancing efficiency and competitiveness.
n8n$14.99Automate Product Development with AI-Driven CPO and Specialized Agents
Enhance your product development process with an AI-powered Chief Product Officer (CPO) and a team of specialized agents, streamlining tasks from strategy to execution using OpenAI models.
n8n$14.99Notion AI Summary & Tags
**What This Workflow Does:** This n8n workflow automatically generates an AI-powered summary and relevant tags whenever a new row is added to your Notion database. Simply save any URL to your Notion database using the [Notion Web Clipper] Chrome extension or [Save to Notion] on both desktop and mobile. This keeps all your saved content organized in one place instead of scattered across different platforms. **How it works:** 1. The workflow is triggered when a new row is added to your Notion database (it checks for updates every minute). 2. It retrieves the content from the saved URL. 3. An AI agent analyzes the content to generate a summary and relevant tags. 4. The AI output is then formatted properly. 5. Finally, the formatted summary and tags are saved into the appropriate columns in your Notion database. **Notes:** Make sure your Notion database includes the following columns: - URL - Stores the content URL you want to summarize. - AI Summary - Where the AI-generated summary will be added. - Tags - Where the AI-generated tags will be saved.
n8n$4.99Chat with OpenAI Assistant by Adding a Memory
OpenAI Assistant is a powerful tool, but at the time of writing, it doesn't automatically remember past messages from a conversation. This workflow demonstrates how to get around this, by managing the chat history in n8n and passing it to the assistant when required. This makes it possible to use OpenAI Assistant for chatbot use cases. Note that to use this template, you need to be on n8n version 1.28.0 or later.
n8n$4.99Develop AI Agents with Custom Reasoning Using GraphRAG and Ontologies
This workflow enables the creation of AI agents in n8n that utilize custom reasoning patterns defined by a knowledge ontology. It leverages InfraNodus and GraphRAG to provide AI agents with a unique way of thinking, applicable to various problem-solving scenarios.
n8n$4.99Create a Counseling Chatbot on LINE with Azure OpenAI for Mental Health Support
Develop a counseling chatbot on the LINE platform using Azure OpenAI to provide 24/7 emotional support and mental health resources. This workflow integrates LINE's webhook with AI language models to offer conversational therapy.
n8n$9.99Chat with AI Models via OpenRouter Using Mistral
This n8n workflow demonstrates how to build an automated AI chat system using OpenRouter.ai. It includes a manual trigger, sets a model and user message, sends a POST request to the OpenRouter chat API, and summarizes the response. Workflow Steps: 1. Manual Trigger - Starts the workflow when executed manually. 2. Set Node - Defines: - Model: mistralai/mistral-small-3.2-24b-instruct:free - Message: What is the meaning of life? 3. HTTP Request - Sends a POST request to https://openrouter.ai/api/v1/chat/completions using Bearer Token Authentication with the model and message as JSON. 4. Summarize - Extracts and summarizes the AI's response (choices[0].message.content). Use Cases: - AI chatbot automation - Content summarization - Testing AI prompts in real-time - Educational demos using OpenRouter.ai - Lightweight conversational tools with no external server
n8n$4.99Automated File Summarization with Local AI Using Ollama's Gemma 3
This workflow automatically processes and summarizes files placed in a monitored folder using Ollama's Gemma 3 AI model. It supports images, documents, and spreadsheets, providing concise summaries for each file type.
n8n$14.99Create a Conversational AI Chatbot with Real-Time Web Search and Advanced Reasoning
This workflow builds a sophisticated AI chatbot using the Claude 3.7 Sonnet model, enhanced with real-time web search and advanced reasoning capabilities. It maintains conversation history and adheres to ethical guidelines for safe interactions.
n8n$4.99Integrate Flowise Multi-Agent Chatflows into a Custom-Branded n8n Chatbot
Create a custom-branded n8n chatbot that integrates Flowise Multi-Agent Chatflows for real-time user interaction with AI agents powered by large language models.
n8n$4.99Automate AI Image Creation and Storage with OpenAI and Azure Blob
This workflow automates the generation of AI images using OpenAI's DALL-E and stores them in Azure Blob Storage, providing a seamless no-code solution for managing cloud-based image storage.
n8n$14.99Automate ArXiv Paper Trend Analysis and Newsletter Distribution
This workflow automates the process of gathering ArXiv papers based on user-defined categories and keywords, summarizes them using AI, and sends a newsletter to subscribers via Gmail.
n8n$19.99Transform Telegram Messages into AI-Generated Images with DALL·E and GPT
This n8n workflow automates the conversion of text prompts sent via Telegram into high-quality AI-generated images using OpenAI's DALL·E and GPT models.
n8n$9.99Build a Multi-Model AI Chatbot with Telegram, AIMLAPI, and Google Sheets
This n8n workflow allows Telegram users to interact with multiple AI models dynamically. Users can select models using #model_id commands and track their daily usage via Google Sheets.
n8n$14.99Automate LINE Chatbot Responses with Google Sheets and Google Gemini AI
This workflow automates AI-assisted replies for LINE Official Account messages, using Google Sheets to store and reference chat history, ensuring contextual and personalized interactions.
n8n$14.99Self-Learning AI Assistant with Permanent Memory | GPT, Telegram & Pinecone RAG
## Your AI secretary that self-learns every day and remembers everything you said (text, audio, image). **Imagine having a personal AI secretary accessible right from your Telegram, ready to assist you with information and remember everything you discuss.** This n8n workflow transforms Telegram into your intelligent assistant, capable of understanding text, audio, and images, and continuously learning from your interactions. **It integrates RAG's offline data ingestion and online querying functionalities, letting you save inspiration and key information permanently in real-time, and giving you an AI assistant that remembers all your dialogues and information.** It builds and queries a powerful vector database in real-time, ensuring relevant and accurate responses. **Video guidance on how to set up Telegram integration is also included.** **Who is this for?** This template is ideal for: - Individuals seeking a personal AI assistant for quick information retrieval and note-taking. - Professionals who need to keep track of important conversations and insights. - Anyone interested in leveraging the power of Retrieval-Augmented Generation (RAG) and vector databases for personal knowledge management. - Users who want a self-learning AI that improves over time based on their interactions. **What problem is this workflow solving?** **This workflow integrates RAG's offline data ingestion and online querying functionalities, letting you save inspiration and key information permanently in real-time, and giving you an AI assistant that remembers all your dialogues and information.** This workflow addresses the challenge of information overload and the need for an easily accessible, personalized knowledge base. It eliminates the need to manually organize notes and search through past conversations. By automatically storing and retrieving information from a vector database, this workflow makes it effortless to access the knowledge you need, when you need it. It also provides a way to retain information from various media types like voice notes and images. **What this workflow does:** This workflow automates the following steps: - **Instant Information Capture:** Receives text messages, audio notes (transcribed), and images (with content analysis) directly from your Telegram. - **Intelligent Question Answering:** When you ask a question, the AI searches its knowledge base (Pinecone vector store) for relevant information and provides a comprehensive answer. It even considers your recent conversations for context. - **Automatic Knowledge Storage:** When you make a statement or provide information, the AI extracts key details and saves them in a Google Docs memory palace. - **Daily Self-Learning:** Every day, the workflow automatically takes all the information stored in the Google Docs, converts it into a vector representation, and adds it to its knowledge base (Pinecone vector store). This ensures the AI continuously learns and remembers everything you've shared. - **Image Understanding:** Extracts text and information from images you send. - **Audio Transcription:** Automatically transcribes your voice notes into text for processing and storage. - **Short-term Memory:** Remembers recent interactions within a session for more context-aware conversations. **Setup:** To get started, you'll need to connect the following services to your n8n instance: 1. **Telegram:** Connect your Telegram bot API credentials. A video guidance is included for Telegram integration setup. 2. **OpenAI:** Provide your OpenAI API key for audio transcription and image analysis. 3. **Pinecone:** Set up a Pinecone account and provide your API key and environment. Create a namespace in Pinecone. 4. **Google Docs:** Connect your Google account with access to Google Docs. You'll need to create a Google Doc that will serve as the daily memory palace and provide its ID in the workflow. **How to customize this workflow:** - **Adjust the AI Agent's Personality:** Modify the system prompt in the AI Agent node to tailor the AI's tone and behavior. - **Expand Knowledge Sources:** Integrate other data sources into the daily learning process, such as emails or other documents, by adding more nodes to the scheduled trigger workflow. - **Add More Tools for the AI Agent:** Integrate additional tools into the AI Agent, such as web search or other APIs, to further enhance its capabilities. - **Modify the Daily Schedule:** Adjust the schedule trigger to run at a different time or interval.
n8n$24.99TechCrunch AI Article Scraper & Classifier with GPT-4.1-nano to Sheets & Telegram
## How it works This workflow scrapes the latest Artificial Intelligence articles from TechCrunch, then processes and classifies the content using OpenAI and LangChain nodes. The final result is saved to Google Sheets and sent as a summary to a Telegram group. Workflow Logic: - Trigger: Schedules daily at 6 AM Bangkok time. - Scraper: Extracts URLs and publish dates from TechCrunch's AI category. - Filter: Only continues if the article is from yesterday (to avoid duplication). - Content Fetch: Downloads and extracts article body text. - AI Agent: - Summarizes the article in Thai. - Scores it using strict journalism criteria (max 100). - Categorizes the news into one of 9 predefined categories. - Output: - Saves all structured data to Google Sheets. - Sends a summary to a Telegram group. ## Set up steps **Estimated setup time:** 10-15 minutes Connect your credentials: - Google Sheets (OAuth2) - Telegram - OpenAI account (via LangChain model) Update the Telegram chatId and Google Sheets documentId/sheetName values. Deploy and activate the workflow. It runs daily without manual intervention.
n8n$14.99Create Personal Data Vector Store from Google Sheets with OpenAI & Gemini AI
This workflow integrates **Google Sheets** with **Supabase Vector Store** for storing personal data as vectors. It utilizes **OpenAI** and **Google Gemini** AI models for enhanced data processing and querying. The workflow performs the following tasks: - **Extracts personal data** from Google Sheets. - Processes the data using **AI tools** like OpenAI and Google Gemini for intelligent insights. - **Inserts the data** into **Supabase** as vectors, enabling efficient storage and fast querying. - Includes seamless integration with **Postgres** for memory management. - Supports data **loading**, **embedding**, and **management**. This template is ideal for: - Personal data storage with AI-driven **querying** and **analysis**. - Building **intelligent agents** that interact with your data. - Efficient vector-based storage for **personal information**. Perfect for those looking to integrate AI into their personal data workflows.
n8n$9.99
Related categories
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work