Automate JSON to Google Sheets with RAG Agent

Overview

This n8n workflow is designed to automatically ingest JSON data from a webhook, process it using a RAG (Retrieval-Augmented Generation) Agent, and then append the processed information into a Google Sheet. The workflow starts with a Webhook Trigger to receive data, followed by Text Splitter to prepare the content. Embeddings are generated to create vector representations, which are then inserted into a Pinecone Insert vector store. A Pinecone Query and Vector Tool enable the retrieval of relevant information. The core processing happens with the RAG Agent node, which uses the retrieved context and memory (Window Memory, Chat Model) to act upon the incoming JSON. Finally, the results are appended to a Google Sheet using the Append Sheet node. Error handling is implemented with a Slack Alert node to notify of any issues.