About this workflow

Contracts contain a lot of details, and customers want to filter out relevant information quickly and specifically. Pre-built SQL queries are perfect for this. This workflow makes it possible to conveniently query various contract data via the chat window, based on a central source of information. Real support staff only need to respond in special cases, significantly reducing their workload.

This workflow is particularly secure because n8n prevents SQL injections. These are attacks in which malicious inputs are used to manipulate databases.

‍

How it works

‍

1. User submits a request

A request is made for information from the contract, and the workflow starts.

‍

2. Data from the request is inserted into a pre-built SQL query via webhook.

SQL queries were defined in advance. These are now filled with data from the request.

‍

3. The source is searched using the SQL query.

Files from a predefined source (any database) are searched for specific information based on the query.

‍

4. Relevant information is returned to the user.

The requested information is provided in the chat based on a single specified source, ensuring that the data is correct.