Template description
This n8n workflow is a fun way to query and search over your credentials on your n8n instance.
Good to know
Your credentials should remain safe as this workflow does not decrypt or use any decrypted data.
Example Usage
- "Which workflows are using Slack and Google Calendar?"
- "Which workflows have AI in their name but are not using openAI?"
How it works
- Using the n8n API, it fetches all workflow data on the instance. Workflow data contains references to credentials used so this will be extracted.
- With some necessary reformatting, the workflows and their credentials metadata are stored to a SQLite database.
- Next, an AI agent is used with a custom SQL tool that reads the SQLite database created in the previous step.
- The AI agent is instructed to perform SQL queries against our workflow credential table when asked about credentials by the user.
Requirements
- You'll need an n8n API key. Please note that only workflows will be scoped to your API key.
Customising the workflow
Add extra table fields to the SQLite database to answer even more complex queries such as:
- workflow status to differentiate between active and inactive workflows.
Share Template
More AI workflow templates
AI agent chat
This workflow employs OpenAI's language models and SerpAPI to create a responsive, intelligent conversational agent. It comes equipped with manual chat triggers and memory buffer capabilities to ensure seamless interactions.
To use this template, you need to be on n8n version 1.50.0 or later.
n8n Team
+7
Scrape and summarize webpages with AI
This workflow integrates both web scraping and NLP functionalities. It uses HTML parsing to extract links, HTTP requests to fetch essay content, and AI-based summarization using GPT-4o. It's an excellent example of an end-to-end automated task that is not only efficient but also provides real value by summarizing valuable content.
Note that to use this template, you need to be on n8n version 1.50.0 or later.
n8n Team
+5
AI agent that can scrape webpages
⚙️🛠️🚀🤖🦾
This template is a PoC of a ReAct AI Agent capable of fetching random pages (not only Wikipedia or Google search results).
On the top part there's a manual chat node connected to a LangChain ReAct Agent. The agent has access to a workflow tool for getting page content.
The page content extraction starts with converting query parameters into a JSON object. There are 3 pre-defined parameters:
url** – an address of the page to fetch
method** = full / simplified
maxlimit** - maximum length for the final page. For longer pages an error message is returned back to the agent
Page content fetching is a multistep process:
An HTTP Request mode tries to get the page content.
If the page content was successfuly retrieved, a series of post-processing begin:
Extract HTML BODY; content
Remove all unnecessary tags to recude the page size
Further eliminate external URLs and IMG scr values (based on the method query parameter)
Remaining HTML is converted to Markdown, thus recuding the page lengh even more while preserving the basic page structure
The remaining content is sent back to an Agent if it's not too long (maxlimit = 70000 by default, see CONFIG node).
NB:
You can isolate the HTTP Request part into a separate workflow.
Check the Workflow Tool description, it guides the agent to provide a query string with several parameters instead of a JSON object.
Please reach out to Eduard is you need further assistance with you n8n workflows and automations!
Note that to use this template, you need to be on n8n version 1.19.4 or later.
Eduard
