Data Processing & Analysis

SHEETS RAG

Complex

High

Nodes

Complex

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

code

create table query, create insertion query, schema to string

3 nodes

google Drive Trigger

Google Drive Trigger

1 node

tool Workflow

execute_query_tool, get_postgres_schema

2 nodes

lm Chat Google Gemini

Google Gemini Chat Model

1 node

set

change_this, response output

2 nodes

is not in database

1 node

postgres

table exists?, remove table, create table, perform insertion, sql query executor, schema finder

6 nodes

google Sheets

fetch sheet data

1 node

execute Workflow Trigger

Execute Workflow Trigger

1 node

sticky Note

Sticky Note, Sticky Note1, Sticky Note2

3 nodes

manual Chat Trigger

When chat message received

1 node

agent

AI Agent With SQL Query Prompt

1 node

Workflow JSON

30.9 KB

{
  "id": "7gRbzEzCuOzQKn4M",
  "meta": {
    "instanceId": "edc0464b1050024ebda3e16fceea795e4fdf67b1f61187c4f2f3a72397278df0",
    "templateCredsSetupCompleted": true
  },
  "name": "SHEETS RAG",
  "tags": [],
  "nodes": [
    {
      "id": "a073154f-53ad-45e2-9937-d0a4196c7838",
      "name": "create table query",
      "type": "n8n-nodes-base.code",
      "position": [
        1280,
        2360
      ],
      "parameters": {
        "jsCode": "// Helper function to check if a string is in MM/DD/YYYY format\nfunction isDateString(value) {\n  const dateRegex = /^\\d{2}\\/\\d{2}\\/\\d{4}$/;\n  if (typeof value !== 'string') return false;\n  if (!dateRegex.test(value)) return false;\n  const [month, day, year] = value.split('/').map(Number);\n  const date = new Date(year, month - 1, day);\n  return !isNaN(date.getTime());\n}\n\nconst tableName = `ai_table_${$('change_this').first().json.sheet_name}`;\nconst rows = $('fetch sheet data').all();\nconst allColumns = new Set();\n\n// Collec...

Showing first 1000 characters. Click "Expand" to view the full JSON.