Automated Transaction Log Backup to Supabase and Google Sheets

Overview

This n8n workflow is designed to automate the process of backing up and analyzing transaction logs. It starts with a Webhook Trigger to receive log data. This data is then processed by a Text Splitter and converted into embeddings using the Embeddings node (Cohere). The embeddings are then inserted into a Supabase vector store for efficient querying and analysis via the Supabase Insert node. A Supabase Query node and Vector Tool enable searching and retrieving relevant log information. The RAG Agent orchestrates the process, leveraging a Chat Model and Window Memory. Finally, the workflow updates a Google Sheet with a status via the Append Sheet node and includes error handling with a Slack Alert.

This workflow is particularly useful for financial and accounting departments that need a robust and automated system for log management, enabling quick retrieval of historical data and maintaining an auditable trail.