OpenRuna
Sign in
← Workflows

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

26 nodes · convertToFile, readWriteFile, extractFromFile, chat, manual, postgres

Engine
n8n
Nodes
26
Trigger
scheduled/triggered
Source file
1245_Postgres_Extractfromfile_Automation_Triggered.json

Workflow flow

IntegrationsConvertToFileReadWriteFileExtractFromFileChatManualPostgreSQLLmChatOllamaExecuteWorkflowAgentSet@n8n/n8n-nodes-langchain.chatIF+3 more
100%
TRIGGER

Chat Trigger

@n8n/n8n-nodes-langchain.chat

TRIGGER

When clicking "Test workflow"

Manual

Ollama Chat Model

@n8n/n8n-nodes-langchain.lmChatOllama

TRIGGER

WorkflowTrigger

ExecuteWorkflow

Load the schema from the local file

ReadWriteFile

Postgres

PostgreSQL

If file exists or already retried generating it

IF

Format empty output

Set

Extract data from file

ExtractFromFile

Format query results

Set

List all tables in a database

PostgreSQL

Combine schema data and chat input

Set

Combine query result and chat answer

Merge

List all columns in a table

PostgreSQL

Add table name to output

Set

Save file locally

ReadWriteFile

Check for trailing semicolon

IF

AI Agent

@n8n/n8n-nodes-langchain.agent

Convert data to binary

ConvertToFile

Extract SQL query

Set

Check if query exists

IF

Add trailing semicolon

Set

If ran manually

IF

23 steps · flows top to bottom, branches left to right

Browse by integration

convertToFilereadWriteFileextractFromFilechatmanualpostgreslmChatOllamaexecuteWorkflowagent
Browse all integrations →
Download n8n JSONDownload sanitized JSONDownload flow graph

Import into n8n

  1. Download the n8n JSON file (full or sanitized).
  2. In n8n: Workflows → Import from file.
  3. Open each node and reconnect credentials to your accounts.
  4. Test with manual execution before enabling triggers.

Sanitized JSON removes credential IDs — safer for sharing. Flow graph JSON is OpenRuna's lightweight format for diagrams and other tools, not n8n import.

View source corpus ↗

Overview

Free n8n workflow: Translate questions about e-mails into SQL queries and run them. 26 nodes across convertToFile, readWriteFile, extractFromFile, chat, manual, postgres, lmChatOllama, executeWorkflow, with a downloadable JSON and a visual flow diagram on OpenRuna.

What this workflow does

"Translate questions about e-mails into SQL queries and run them" automates a convertToFile-to-readWriteFile flow in n8n across 26 nodes. 26 nodes · convertToFile, readWriteFile, extractFromFile, chat, manual, postgres It starts from a scheduled/triggered trigger and routes data through every node in order. OpenRuna renders the node graph and offers the JSON export so you can import and adapt it in minutes. Use it to learn integration patterns, fork it for your own use case, or deploy it quickly after reconnecting credentials.

Use cases

  • Share it with your team as a documented reference for scheduled/triggered automations in the convertToFile stack.
  • Study how data moves from convertToFile to readWriteFile before building your own variant.
  • Use it as a starting template when wiring convertToFile, readWriteFile, extractFromFile, chat, manual, postgres, lmChatOllama, executeWorkflow — adjust node parameters to your accounts and record IDs.
  • Import "Translate questions about e-mails into SQL queries and run them" into n8n, reconnect credentials for convertToFile, readWriteFile, extractFromFile, chat, manual, postgres, lmChatOllama, executeWorkflow, and run the same automation in your own workspace.

Example output

Imported into n8n, "Translate questions about e-mails into SQL queries and run them" exposes 26 configured nodes. Trigger type: scheduled/triggered. Integrations: convertToFile, readWriteFile, extractFromFile, chat, manual, postgres, lmChatOllama, executeWorkflow. Reconnect the convertToFile credential first, then walk the remaining nodes top to bottom. Run it once in test mode to verify any branch logic (Switch/IF nodes) before enabling production triggers.

Tips by platform

Claude

Paste the exported JSON for "Translate questions about e-mails into SQL queries and run them" into Claude and ask it to explain each of the 26 nodes. Claude is good at suggesting credential mappings for convertToFile, readWriteFile, extractFromFile, chat, manual, postgres, lmChatOllama, executeWorkflow, plus error-handling and idempotency improvements before you run it in production.

ChatGPT

Have ChatGPT generate a checklist for adapting "Translate questions about e-mails into SQL queries and run them" to your accounts — which convertToFile, readWriteFile, extractFromFile, chat, manual, postgres, lmChatOllama, executeWorkflow credentials to create and which node parameters to change first.

Cursor

Open the downloaded JSON in Cursor and use Agent mode to refactor hard-coded URLs into env vars, or to generate tests for any Code nodes. Keep the OpenRuna flow diagram open so you do not break connection order across the 26 nodes.

Frequently asked questions

How do I import "Translate questions about e-mails into SQL queries and run them" into n8n?
Click Download n8n JSON on this page, then in n8n choose Workflows → Import from file and select the downloaded file. Reconnect credentials on each node — the export carries credential IDs from the original author's instance, not working secrets.
Which integrations does "Translate questions about e-mails into SQL queries and run them" use?
It uses: convertToFile, readWriteFile, extractFromFile, chat, manual, postgres, lmChatOllama, executeWorkflow. The flow diagram above shows how each service connects across the 26 nodes. Filter OpenRuna by integration to find related workflows and tools.
Can I import a sanitized export without credentials?
Yes. Use "Download sanitized JSON" to strip credential references before sharing internally. You will still add your own convertToFile and readWriteFile credentials in n8n after import.
What trigger type does "Translate questions about e-mails into SQL queries and run them" use?
Trigger type: scheduled/triggered. After import, confirm the trigger node (webhook, schedule, or app event) matches your environment, then activate the workflow when you are ready to run it.
Is "Translate questions about e-mails into SQL queries and run them" free to use?
OpenRuna catalogs community n8n workflows under open licenses. Check the source corpus link for the original license; commercial use may require verifying the third-party API terms for convertToFile, readWriteFile, extractFromFile, chat, manual, postgres, lmChatOllama, executeWorkflow.

Related resources