Automate Weekly Notes Backup with n8n and Vector Storage

Overview

This n8n workflow is designed to create a robust system for backing up and processing your weekly notes. It begins with a Webhook Trigger that initiates the process, likely when new notes are ready to be backed up. The incoming text data is then segmented into smaller pieces using the Text Splitter node, which is crucial for managing larger documents. These chunks are converted into numerical representations (embeddings) using the Embeddings node (Cohere in this case) and then stored in a vector database (Weaviate) for efficient retrieval and analysis. A Weaviate Query and Vector Tool are employed to access this stored information. The core logic resides in the RAG Agent, which utilizes a Chat Model (OpenAI) and Window Memory to process the input and query results. Finally, the outcome is logged to a Google Sheet via the Append Sheet node, and any errors encountered during the execution are sent as alerts to Slack using the Slack Alert node.