(5/5)

Translate questions about e-mails into SQL queries and run them

Automated workflow: Translate questions about e-mails into SQL queries and run them. This workflow integrates 14 different services: convertToFile, stickyNote, agent, readWriteFile, merge. It contains 30 nodes and follows best practices for error handling and security.

Integrations Used (3)

Readwritefile

Postgres

Executeworkflow

Workflow Structure (24 nodes)

100%

Manual Trigger

When clicking "Test workflow"

Postgres

List all tables in a database

Postgres

List all columns in a table

Set

Add table name to output

Stop And Error

Error Handler

Convert To File

Convert data to binary

Read Write File

Save file locally

If ran manually

Postgres

Set

Format query results

No Op

Chat Trigger

Execute Workflow Trigger

WorkflowTrigger

Read Write File

Load the schema from the local file

If file exists or already retried generating it

Extract From File

Extract data from file

Set

Combine schema data and chat input

No Op

AI Agent

No Op

Ollama Chat Model

Set

Extract SQL query

Check for trailing semicolon

Set

Add trailing semicolon

Check if query exists

Set

Format empty output

Merge

Combine query result and chat answer

Node Types:

transform

default

trigger

logic

action

Requires credentials

Prerequisites

No credentials required!

This workflow can be imported and used immediately.

Complexity

Complex

Advanced features used. Requires n8n experience.

Setup time: ~25 min

Score: 50/100

Conditional Logic

8 Integrations

When to Use This Workflow

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Time Savings

Replace repetitive manual tasks with reliable automation.

Reclaim hours every week for higher-value work.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "id": "AC4paL1SXMFURgmc",
  "meta": {
    "instanceId": "workflow-df722e0b",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:51.394267",
    "updatedAt": "2025-09-29T07:07:51.394281",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "Translate questions about e-mails into SQL queries and run them",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...