AI-Powered n8n Workflow Credential Search
detail.loadingPreview
Query your n8n workflow credentials using an AI agent and a local SQLite database.
About This Workflow
This workflow leverages n8n's capabilities to create a powerful search interface for your workflow credentials. It first stores mappings of workflow IDs, names, and associated credentials into a local SQLite database. Then, it utilizes an AI agent, powered by OpenAI, to act as an intelligent search engine, allowing you to query this database using natural language.
Key Features
- Stores n8n workflow and credential mappings in a local SQLite database.
- Utilizes n8n's API to fetch workflow and credential information.
- Employs an AI agent (Langchain with OpenAI) for natural language querying.
- Allows complex queries like 'Which workflows use Slack and Google Calendar?'
- Provides a mechanism to link back to specific workflows via generated URLs.
How To Use
Step 1. Store Workflows Credential Mappings to Database
- Manual Trigger: Click "Test workflow" to initiate the process.
- n8n Node: This node queries your n8n instance using its API to retrieve all workflows.
- Map Workflows & Credentials: This node processes the data from the n8n node, extracting the
workflow_id,workflow_name, and a structured list ofcredentialsfrom each workflow's nodes. - Save to Database: This Python code node creates and populates a SQLite database named
n8n_workflow_credentials.dbwith the extracted information.
Step 2. Use Agent as Search Interface
- Chat Trigger: This node is where you'll interact with the AI agent. It listens for incoming messages.
- OpenAI Chat Model: Configured with your OpenAI API credentials, this node provides the language model for the agent.
- Window Buffer Memory: Manages the conversation history for the AI agent.
- Query Workflow Credentials Database: This
toolCodenode provides the AI agent with access to query the SQLite database created in Step 1. It's configured with the database schema and instructions on how to use it. - Workflow Credentials Helper Agent: This
agentnode orchestrates the interaction between the user's input, the OpenAI model, and theQuery Workflow Credentials Databasetool. It interprets your natural language queries and translates them into SQL queries to retrieve the relevant information. It can also generate links to workflows if requested.
Example Queries:
- "Which workflows are using Slack and Google Calendar?"
- "Show me workflows that use Airtable."
- "List workflows that have 'notification' in their name."
Apps Used
Workflow JSON
{
"id": "4d956d65-2d2f-4ba9-a332-d8604061d546",
"name": "AI-Powered n8n Workflow Credential Search",
"nodes": 8,
"category": "Utilities",
"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: 4d956d65-2d2f...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Check Website Availability and Extract Metadata
This workflow checks if a given URL is available using Peekalink and then extracts its metadata. It branches based on availability.
AI-Powered Multilingual Telegram Translator
Translate Telegram audio messages between languages using AI.