ManualTrigger Automate

ManualTrigger Automate enables users to effortlessly query and manage workflow credentials through an AI-driven interface. By integrating with Sticky Note and LangChain, it simplifies the process of storing and retrieving credentials from a local database, allowing for quick insights into workflow usage. Users can easily ask questions like "Which workflows are using Slack and Google Calendar?" to enhance operational efficiency and streamline workflow management.

7/8/2025
13 nodes
Medium
manualmediumsticky notelangchainn8nadvanced
Categories:
Manual TriggeredMedium Workflow
Integrations:
Sticky NoteLangChainN8n

Target Audience

Target Audience


- Developers: Those who want to automate workflow credential management in n8n.
- Data Analysts: Individuals needing to query workflow credentials for analysis without exposing sensitive information.
- Project Managers: Professionals overseeing multiple workflows who need a clear overview of credentials used across projects.
- AI Enthusiasts: Users interested in leveraging AI tools to interact with and query databases effectively.

Problem Solved

Problem Solved


This workflow addresses the challenge of managing and querying workflow credentials in n8n. It allows users to:
- Store credentials securely in a SQLite database.
- Query the database using natural language through an AI agent, making it easier to find relevant workflows based on specific applications or services used.

Workflow Steps

Workflow Steps


1. Manual Trigger: The workflow begins when the user clicks "Test workflow".
2. Map Workflows & Credentials: Extracts workflow ID, name, and credentials from the current n8n workflows.
3. Save to Database: Stores the extracted information in a SQLite database, ensuring that the credentials are kept secure and structured.
4. Chat Trigger: Sets up a chat interface for users to interact with the AI agent.
5. OpenAI Chat Model: Utilizes OpenAI's language model to process user queries.
6. Window Buffer Memory: Keeps track of the context during conversations with the AI agent.
7. Workflow Credentials Helper Agent: The AI agent that assists users in querying the database using natural language.
8. Query Workflow Credentials Database: Executes user queries against the SQLite database to retrieve relevant workflow credentials.

Customization Guide

Customization Guide


- Adjust Database Connection: Modify the SQLite connection string in the Save to Database node to point to a different database if needed.
- Change AI Model: Users can switch the OpenAI model in the OpenAI Chat Model node to use a different language model if desired.
- Modify Chat Agent Behavior: Customize the Workflow Credentials Helper Agent parameters to change how the AI responds to user queries.
- Add Additional Nodes: Users can integrate additional nodes to expand functionality, such as sending notifications or logging queries.