Automated WhatsApp Chatbot with Google Drive & Pinecone Integration

This n8n workflow creates an intelligent WhatsApp chatbot that integrates with Google Drive and Pinecone to provide context-aware responses. The bot automatically loads data from a Google Drive file, splits it into manageable chunks, and indexes these chunks in a Pinecone vector database. It monitors the Google Drive file for updates every minute, ensuring the knowledge base remains current.

The workflow begins with a webhook triggered by incoming WhatsApp messages, whether in individual chats or groups. If a message is received, the workflow checks if it is a group or individual message, and processes only relevant ones. The text content is extracted and matched against the vector database to find the most relevant chunks of information.

Using OpenAI’s language models (GPT-4 mini), the bot constructs contextually appropriate responses based on the retrieved information. It can handle multiple chunks by limiting the number of chunks sent to the model, ensuring concise and relevant replies. The responses are then sent back via WhatsApp, enabling real-time, automated, and intelligent communication.

This workflow is ideal for use cases such as customer support, internal team assistants, community bots, or personal knowledge management systems. It supports group chats, updates its knowledge base automatically, and does not require a Meta or Facebook account setup, making it accessible and easy to deploy for various scenarios.