OpenRuna
Sign in
← Workflows

SHEETS RAG

23 nodes · googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow

Engine
n8n
Nodes
23
Trigger
scheduled/triggered
Source file
1144_Postgres_Code_Automation_Triggered.json

Workflow flow

IntegrationsGoogle DriveToolWorkflowLmChatGoogleGeminiPostgreSQLGoogle SheetsExecuteWorkflowManualChatAgentCode@n8n/n8n-nodes-langchain.toolWorkflow@n8n/n8n-nodes-langchain.lmChatGoogleGeminiSet+3 more
100%
TRIGGER

Google Drive Trigger

Google Drive

execute_query_tool

@n8n/n8n-nodes-langchain.toolWorkflow

Google Gemini Chat Model

@n8n/n8n-nodes-langchain.lmChatGoogleGemini

get_postgres_schema

@n8n/n8n-nodes-langchain.toolWorkflow

TRIGGER

Execute Workflow Trigger

ExecuteWorkflow

TRIGGER

When chat message received

@n8n/n8n-nodes-langchain.manualChat

change_this

Set

sql query executor

PostgreSQL

schema finder

PostgreSQL

AI Agent With SQL Query Prompt

@n8n/n8n-nodes-langchain.agent

table exists?

PostgreSQL

response output

Set

schema to string

Code

fetch sheet data

Google Sheets

is not in database

IF

remove table

PostgreSQL

create table query

Code

create table

PostgreSQL

create insertion query

Code

perform insertion

PostgreSQL

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

Browse by integration

googleDrivetoolWorkflowlmChatGoogleGeminipostgresgoogleSheetsexecuteWorkflowmanualChatagent
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

SHEETS RAG (23-node n8n automation, googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow, manualChat, agent) is free on OpenRuna — view the graph and export the JSON to import into n8n.

What this workflow does

"SHEETS RAG" is an n8n automation built from 23 nodes spanning googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow, manualChat, agent. 23 nodes · googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow A scheduled/triggered entry point kicks it off, and each node passes data to the next until the run completes. On OpenRuna you get the visual graph, the integration list, and a downloadable JSON ready to import into n8n. Use it to learn integration patterns, fork it for your own use case, or deploy it quickly after reconnecting credentials.

Use cases

  • Use it as a starting template when wiring googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow, manualChat, agent — adjust node parameters to your accounts and record IDs.
  • Import "SHEETS RAG" into n8n, reconnect credentials for googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow, manualChat, agent, and run the same automation in your own workspace.
  • Share it with your team as a documented reference for scheduled/triggered automations in the googleDrive stack.
  • Study how data moves from googleDrive to toolWorkflow before building your own variant.

Example output

Imported into n8n, "SHEETS RAG" exposes 23 configured nodes. Trigger type: scheduled/triggered. Integrations: googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow, manualChat, agent. Set your credentials on the googleDrive node, then verify each downstream node picks them up. 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 "SHEETS RAG" into Claude and ask it to explain each of the 23 nodes. Claude is good at suggesting credential mappings for googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow, manualChat, agent, plus error-handling and idempotency improvements before you run it in production.

ChatGPT

Have ChatGPT generate a checklist for adapting "SHEETS RAG" to your accounts — which googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow, manualChat, agent 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 23 nodes.

Frequently asked questions

How do I import "SHEETS RAG" 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 "SHEETS RAG" use?
It uses: googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow, manualChat, agent. The flow diagram above shows how each service connects across the 23 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 googleDrive and toolWorkflow credentials in n8n after import.
What trigger type does "SHEETS RAG" 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 "SHEETS RAG" 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 googleDrive, toolWorkflow, lmChatGoogleGemini, postgres, googleSheets, executeWorkflow, manualChat, agent.

Related resources