Automated Promotion Archive with AI Assistance

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.