Automated CSV Attachment Processing to Airtable and Vector Search

This n8n workflow automates the process of handling CSV file attachments, analyzing and storing their data effectively. The workflow begins with a webhook trigger that activates upon receiving a CSV file. It then splits the CSV data into manageable chunks and generates embeddings using the Cohere API for semantic understanding. These embeddings are stored in a Pinecone vector database for efficient retrieval. When a query or related input occurs, the system searches the vector database to find relevant data. Using language models from Anthropic, the workflow processes the data to generate insights or responses. Results are logged into Google Sheets for record-keeping, and errors trigger alerts via Slack. This automation is particularly useful for managing and analyzing large data files, enabling intelligent search and data integration, especially in contexts like data analytics, knowledge management, or customer support automation.