This n8n workflow automates the process of archiving promotional data using AI and vector technology. It is triggered via an HTTP webhook, which could be invoked by a form submission or another system. The workflow splits incoming text into smaller parts, generates embeddings using OpenAI, stores and queries vectors in Pinecone, and applies a retrieval-augmented generation (RAG) approach for intelligent data handling. The AI-powered insights are then logged into Google Sheets, providing a seamless and automated way to manage promotional data. In case of errors, notifications are sent via Slack.
### Workflow Steps:
1. **Webhook Trigger**: Initiates the workflow when an external system sends data via POST request.
2. **Text Splitter**: Processes the incoming content by splitting it into smaller chunks based on characters.
3. **Embeddings**: Converts the text chunks into vector embeddings using OpenAI’s `text-embedding-3-small` model.
4. **Pinecone Insert & Query**: Stores the generated vectors in Pinecone, enabling efficient similarity searches, and queries existing vectors for relevant data.
5. **Vector Processing & RAG Agent**: Uses a custom agent with a language model to process the retrieved vectors, handling data intelligently.
6. **Google Sheets Logging**: Records the processing status and relevant information in a Google Sheet for tracking.
7. **Error Handling**: Sends alerts to a Slack channel if any issues occur during execution.
### Use Cases:
This workflow is ideal for automating the archiving and retrieval of promotional content, enhancing content management systems, and leveraging AI for data analysis and insights in marketing and advertising campaigns.
