Manage Google Sheets Data with GPT-4 Natural Language Processing + Calculator

This n8n workflow leverages the power of AI to interact with your data using natural language. It acts as a conversational agent that can understand your requests, perform calculations, and is designed to be extensible for managing data in tools like Google Sheets.

What it does

This workflow sets up a foundational AI agent that can:

1. Listen for Chat Messages: It initiates when a new chat message is received, acting as a conversational interface.
2. Maintain Conversation History: It uses a simple memory buffer to remember previous interactions, enabling more coherent and context-aware conversations.
3. Process Natural Language: It employs an OpenAI Chat Model (like GPT-4) to understand and interpret user queries.
4. Perform Calculations: It includes a "Calculator" tool, allowing the AI agent to solve mathematical problems directly within the conversation.
5. Act as an AI Agent: The core AI Agent node orchestrates the interaction between the language model, memory, and available tools to respond to user requests.

While the provided JSON primarily focuses on the conversational and calculation aspects, its structure (especially the "AI Agent" node) is built to be easily extended with tools for data management, such as interacting with Google Sheets, as hinted by the directory name.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (cloud or self-hosted).
• OpenAI API Key: An API key for OpenAI to use their chat models (e.g., GPT-3.5, GPT-4). This will need to be configured as an n8n credential.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots in the top right corner and select "Import from JSON".
   • Paste the JSON content or upload the file.
2. Configure Credentials:
   • Locate the "OpenAI Chat Model" node.
   • You will need to set up an OpenAI API credential. If you don't have one, click "Create New" next to the "Credential" field and follow the prompts to enter your OpenAI API Key.
3. Activate the Workflow:
   • Once imported and credentials are set, click the "Activate" toggle in the top right corner of the workflow editor.
4. Interact with the Chat Trigger:
   • The "When chat message received" node acts as the entry point. Depending on your n8n setup, you might interact with this through a dedicated chat interface, a connected messaging app (like Slack or Telegram, which would require additional trigger nodes), or by manually triggering it with test data.
   • Send a message to the chat trigger, and the AI agent will process it. Try asking it to perform a calculation, e.g., "What is 123 * 45?" or "What is the square root of 81?".

This workflow provides a robust foundation for building more complex AI-driven data management solutions.