SHEETS RAG

Automated workflow: SHEETS RAG. This workflow integrates 13 different services: stickyNote, googleDriveTrigger, code, lmChatGoogleGemini, manualChatTrigger. It contains 26 nodes and follows best practices for error handling and security.

Workflow Structure (21 nodes)
100%
Stop And Error
Error Handler
Google Drive Trigger
Google Drive Trigger
No Op
When chat message received
Set
change_this
No Op
Google Gemini Chat Model
No Op
AI Agent With SQL Query Prompt
Postgres
remove table
Postgres
table exists?
No Op
get_postgres_schema
Google Sheets
fetch sheet data
Code
create table query
No Op
execute_query_tool
If
is not in database
Postgres
create table
Code
create insertion query
Execute Workflow Trigger
Execute Workflow Trigger
Postgres
perform insertion
Postgres
sql query executor
Postgres
schema finder
Set
response output
Code
schema to string
Node Types:
code
trigger
default
transform
logic
action
Requires credentials

Prerequisites

Required Credentials (4)

Google Drive

Used by: Google Drive Trigger

Docs

Google Palm

Used by: Google Gemini Chat Model

Docs

Google Sheets

Used by: fetch sheet data

Docs

Postgres

Used by: table exists?, remove table +4 more

Docs

Multiple services required

This workflow needs 4 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~55 min
Score: 85/100
Custom Code
Conditional Logic
6 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

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.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json
{
  "id": "7gRbzEzCuOzQKn4M",
  "meta": {
    "instanceId": "workflow-82537033",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:51.329386",
    "updatedAt": "2025-09-29T07:07:51.329401",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "SHEETS RAG",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...

Workflow Details

Nodes
24
Trigger
Event
Source
community
Added
Sep 29, 2025

Need Help?

Check out the official n8n documentation for detailed guides.

Related Workflows

API Schema Extractor

Stage 1 - Research for API Documentation - Fetch a list of services pending research from Database (Google Sheet) - Uses...

Http-request
Textsplitterrecursivecharactertextsplitter
Documentdefaultdataloader
Executeworkflow
88 nodesEvent
Curated

Agent Workflow

Automated workflow: Agent Workflow. This workflow integrates 97 different services: vectorStoreInMemory, if, gumroadTrig...

Bitly
Dropbox
Gmail
Google-calendar
113 nodesEvent

Manualtrigger Workflow

Automated workflow: Manualtrigger Workflow. This workflow integrates 19 different services: stickyNote, switch, lmChatOp...

Google-drive
Google-sheets
Executeworkflow
Str
36 nodesEvent

Manualtrigger Workflow

Automated workflow: Manualtrigger Workflow. This workflow integrates 19 different services: stickyNote, switch, lmChatOp...

Google-drive
Google-sheets
Executeworkflow
Str
36 nodesEvent

Automated Research Report Generation with OpenAI, Wikipedia, Google Search, and Gmail/Telegram

Automated workflow: Automated Research Report Generation with OpenAI, Wikipedia, Google Search, and Gmail/Telegram. This...

Google-sheets
Http-request
Gmail
Telegram
26 nodesEvent

Manualtrigger Workflow

Automated workflow: Manualtrigger Workflow. This workflow integrates 26 different services: stickyNote, textSplitterRecu...

Http-request
Executeworkflow
Executiondata
Google-sheets
88 nodesEvent