AI-Powered n8n Workflow Credential Search
detail.loadingPreview
This workflow allows you to search your n8n workflow credentials using an AI SQL agent. It maps workflow credentials to a database and then uses a Chat Trigger and an OpenAI agent to query this data.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow automates the process of searching through your n8n workflow credentials. It addresses the challenge of efficiently finding which workflows utilize specific credentials, especially in large n8n instances.
The workflow first uses the n8n node to fetch all available workflows and their associated credentials. These mappings are then processed by the Map Workflows & Credentials node to extract relevant information like workflow_id, workflow_name, and a structured list of credentials. This processed data is then stored in a SQLite database using the Save to Database code node.
Subsequently, a Chat Trigger initiates the AI interaction. The Workflow Credentials Helper Agent, powered by OpenAI Chat Model and Window Buffer Memory, acts as an intelligent interface. It's equipped with a Query Workflow Credentials Database tool, enabling it to understand natural language queries and translate them into SQL commands to retrieve specific credential information from the database. This allows users to ask questions like "Which workflows are using Slack and Google Calendar?" in a conversational manner.
Key Features
- Automatically maps n8n workflow IDs, names, and credentials.
- Stores credential mappings in a local SQLite database.
- Utilizes an AI agent (OpenAI) for natural language querying of workflow credentials.
- Provides a
Query Workflow Credentials Databasetool for the AI agent to interact with the data.
How To Use
- Populate the Database: Execute the first part of the workflow by clicking "Test workflow" on the
When clicking "Test workflow"node. This will query your n8n instance and store the workflow credential mappings in a local SQLite database (n8n_workflow_credentials.db). - Engage the AI Agent: Activate the
Chat Triggernode. You can then interact with the AI agent by asking questions about your workflow credentials in natural language. - Query Credentials: Formulate questions such as "Which workflows use Slack and Google Sheets?" or "Show me workflows that have 'API' in their name but don't use the OpenAI credential." The agent will use the
Query Workflow Credentials Databasetool to find the answers.
Apps Used
Workflow JSON
{
"id": "4ce9d962-48ad-4b4e-99e3-73d5665c81fe",
"name": "AI-Powered n8n Workflow Credential Search",
"nodes": 0,
"category": "AI & LLMs",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 4ce9d962-48ad...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
AI-Powered Conversational Agent with Tools
This n8n workflow creates an AI conversational agent that leverages multiple tools, including Wikipedia and a weather API, to answer complex user queries. It utilizes a buffer memory to maintain conversation context.
RAG Workflow for Stock Earnings Report Analysis
Analyze stock earnings reports using Retrieval Augmented Generation (RAG). This workflow leverages Pinecone for vector storage and Google Gemini for embeddings and chat, enabling detailed trend and outlier analysis from financial documents.
Build a Voice RAG Chatbot with ElevenLabs and OpenAI
Create an interactive voice-enabled RAG chatbot using ElevenLabs for speech synthesis and OpenAI for AI agent capabilities. This workflow integrates with Qdrant Vector Store and Google Drive for knowledge retrieval, enabling intelligent responses to user queries.