{
    "name": "JSON to Sheet",
    "nodes": [
        {
            "parameters": {
                "content": "Automated workflow: JSON to Sheet",
                "height": 530,
                "width": 1100,
                "color": 5
            },
            "id": "22ae73af-1660-49c3-97b3-3e896eaab598",
            "name": "Sticky Note",
            "type": "n8n-nodes-base.stickyNote",
            "typeVersion": 1,
            "position": [
                -480,
                -240
            ]
        },
        {
            "parameters": {
                "httpMethod": "POST",
                "path": "json-to-sheet"
            },
            "id": "2b9c6e14-8640-4c28-a593-07c2c7b34dcc",
            "name": "Webhook Trigger",
            "type": "n8n-nodes-base.webhook",
            "typeVersion": 1,
            "position": [
                -300,
                0
            ]
        },
        {
            "parameters": {
                "chunkSize": 400,
                "chunkOverlap": 40
            },
            "id": "a3ffd546-08d9-48cb-9cf1-814f585c244e",
            "name": "Text Splitter",
            "type": "@n8n\/n8n-nodes-langchain.textSplitterCharacterTextSplitter",
            "typeVersion": 1,
            "position": [
                -130,
                0
            ]
        },
        {
            "parameters": {
                "model": "text-embedding-3-small",
                "options": []
            },
            "id": "26b8037e-5205-4e2e-9f84-f45759cdc143",
            "name": "Embeddings",
            "type": "@n8n\/n8n-nodes-langchain.embeddingsOpenAi",
            "typeVersion": 1,
            "position": [
                70,
                0
            ],
            "credentials": {
                "openAiApi": {
                    "id": "OPENAI_API",
                    "name": "OpenAI"
                }
            }
        },
        {
            "parameters": {
                "mode": "insert",
                "options": [],
                "pineconeIndex": {
                    "__rl": true,
                    "value": "json_to_sheet",
                    "mode": "list",
                    "cachedResultName": "json_to_sheet"
                }
            },
            "id": "8e87db29-aed5-4470-974b-2d9a7f80c050",
            "name": "Pinecone Insert",
            "type": "@n8n\/n8n-nodes-langchain.vectorStorePinecone",
            "typeVersion": 1,
            "position": [
                270,
                0
            ],
            "credentials": {
                "pineconeApi": {
                    "id": "PINECONE_API",
                    "name": "Pinecone account"
                }
            }
        },
        {
            "parameters": {
                "pineconeIndex": {
                    "__rl": true,
                    "value": "json_to_sheet",
                    "mode": "list",
                    "cachedResultName": "json_to_sheet"
                }
            },
            "id": "1a4f3b0a-2109-4277-82d5-d2f8bad3e1b8",
            "name": "Pinecone Query",
            "type": "@n8n\/n8n-nodes-langchain.vectorStorePinecone",
            "typeVersion": 1,
            "position": [
                270,
                -180
            ],
            "credentials": {
                "pineconeApi": {
                    "id": "PINECONE_API",
                    "name": "Pinecone account"
                }
            }
        },
        {
            "parameters": {
                "name": "Pinecone",
                "description": "Vector context"
            },
            "id": "d9de9e88-d22b-400e-a6c9-6c33c6a6bf62",
            "name": "Vector Tool",
            "type": "@n8n\/n8n-nodes-langchain.toolVectorStore",
            "typeVersion": 1,
            "position": [
                450,
                -180
            ]
        },
        {
            "parameters": [],
            "id": "39699355-6f61-45d7-ac91-739b8ae368ad",
            "name": "Window Memory",
            "type": "@n8n\/n8n-nodes-langchain.memoryBufferWindow",
            "typeVersion": 1.3,
            "position": [
                450,
                -40
            ]
        },
        {
            "parameters": {
                "options": []
            },
            "id": "69b5c1aa-f248-4db2-b35a-f5ac7470b2ce",
            "name": "Chat Model",
            "type": "@n8n\/n8n-nodes-langchain.lmChatOpenAi",
            "typeVersion": 1,
            "position": [
                450,
                -340
            ],
            "credentials": {
                "openAiApi": {
                    "id": "OPENAI_API",
                    "name": "OpenAI"
                }
            }
        },
        {
            "parameters": {
                "promptType": "define",
                "text": "Process the following data for task 'JSON to Sheet':\n\n{{ $json }}",
                "options": {
                    "systemMessage": "You are an assistant for JSON to Sheet"
                }
            },
            "id": "6fbd4ea9-4762-4904-a2a6-eea9f6d7f629",
            "name": "RAG Agent",
            "type": "@n8n\/n8n-nodes-langchain.agent",
            "typeVersion": 1,
            "position": [
                720,
                -40
            ]
        },
        {
            "parameters": {
                "operation": "append",
                "documentId": {
                    "__rl": true,
                    "value": "SHEET_ID",
                    "mode": "list",
                    "cachedResultName": "JSON to Sheet"
                },
                "sheetName": {
                    "__rl": true,
                    "value": "Log",
                    "mode": "list",
                    "cachedResultName": "Log"
                },
                "columns": {
                    "mappingMode": "defineBelow",
                    "value": {
                        "Status": "={{$json[\"RAG Agent\"].text}}"
                    },
                    "schema": []
                }
            },
            "id": "3b91edac-b782-4e3b-8b42-a6b45da192c7",
            "name": "Append Sheet",
            "type": "n8n-nodes-base.googleSheets",
            "typeVersion": 4,
            "position": [
                930,
                -40
            ],
            "credentials": {
                "googleSheetsOAuth2Api": {
                    "id": "SHEETS_API",
                    "name": "Google Sheets account"
                }
            }
        },
        {
            "parameters": {
                "channel": "#alerts",
                "text": "JSON to Sheet error: {$json.error.message}"
            },
            "id": "40ba60ac-f1dd-4440-9339-3ec56db3532e",
            "name": "Slack Alert",
            "type": "n8n-nodes-base.slack",
            "typeVersion": 1,
            "position": [
                930,
                120
            ],
            "credentials": {
                "slackApi": {
                    "id": "SLACK_API",
                    "name": "Slack"
                }
            }
        }
    ],
    "connections": {
        "Webhook Trigger": {
            "main": [
                [
                    {
                        "node": "Text Splitter",
                        "type": "main",
                        "index": 0
                    },
                    {
                        "node": "Window Memory",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Text Splitter": {
            "main": [
                [
                    {
                        "node": "Embeddings",
                        "type": "main",
                        "index": 0
                    }
                ]
            ],
            "ai_textSplitter": [
                [
                    {
                        "node": "Pinecone Insert",
                        "type": "ai_textSplitter",
                        "index": 0
                    }
                ]
            ]
        },
        "Embeddings": {
            "ai_embedding": [
                [
                    {
                        "node": "Pinecone Insert",
                        "type": "ai_embedding",
                        "index": 0
                    },
                    {
                        "node": "Pinecone Query",
                        "type": "ai_embedding",
                        "index": 0
                    }
                ]
            ]
        },
        "Pinecone Insert": {
            "ai_document": [
                []
            ]
        },
        "Pinecone Query": {
            "ai_vectorStore": [
                [
                    {
                        "node": "Vector Tool",
                        "type": "ai_vectorStore",
                        "index": 0
                    }
                ]
            ]
        },
        "Vector Tool": {
            "ai_tool": [
                [
                    {
                        "node": "RAG Agent",
                        "type": "ai_tool",
                        "index": 0
                    }
                ]
            ]
        },
        "Window Memory": {
            "ai_memory": [
                [
                    {
                        "node": "RAG Agent",
                        "type": "ai_memory",
                        "index": 0
                    }
                ]
            ]
        },
        "Chat Model": {
            "ai_languageModel": [
                [
                    {
                        "node": "RAG Agent",
                        "type": "ai_languageModel",
                        "index": 0
                    }
                ]
            ]
        },
        "RAG Agent": {
            "main": [
                [
                    {
                        "node": "Append Sheet",
                        "type": "main",
                        "index": 0
                    }
                ]
            ],
            "onError": [
                [
                    {
                        "node": "Slack Alert",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "settings": {
        "executionOrder": "v1"
    },
    "triggerCount": 1
}