Back to Catalog

WhatsApp support assistant with GPT-4 Mini & Google Sheets data training

SpaGreen CreativeSpaGreen Creative
103 views
2/3/2026
Official Page

WhatsApp AI HelpDesk – Smart SupportBot Using Trained Data & WasenderAPI

Overview

This n8n workflow enables automated AI-driven support replies via your personal WhatsApp number using WasenderAPI.com. The bot intelligently responds to user messages based on trained data stored in Google Sheets, helping you avoid the high cost of WhatsApp Business API.


What It Does

  • Reads real-time data from a connected Google Sheet
  • Sends AI-generated responses based on predefined training data
  • Automatically applies rate limits to avoid account blocking
  • Updates each contact's support status after responding

Who’s It For

This workflow is ideal for:

  • Freelancers and small businesses offering support through WhatsApp
  • Customer service teams seeking to automate common queries
  • Entrepreneurs looking to deploy a cost-effective support assistant
  • SaaS founders managing WhatsApp inquiries without expensive API costs

Prerequisites

Make sure the following components are ready:

  • An active WhatsApp account (Personal or Business)
  • WasenderAPI subscription (around $6/month)
  • OpenAI API access (around $20/month)
  • n8n instance (self-hosted or cloud)
  • Google Sheets API connected to n8n
  • A training sheet like this sample:
    https://docs.google.com/spreadsheets/d/1Ui4TzzI-Gq-bsEsrZELwW1Kyddw0IU9L1wxlHikktqw/edit?usp=sharing

Setup Instructions

1. Connect WasenderAPI

  • Add your WhatsApp session to WasenderAPI
  • In n8n, create a Webhook node
  • Copy the webhook URL and paste it into your WasenderAPI session settings

2. Connect OpenAI

  • Add an OpenAI node in n8n
  • Authenticate using your OpenAI credentials
  • Configure the prompt to reference the data from your Google Sheet

3. Connect Google Sheets

  • Add a Google Sheets node
  • Authenticate using your Google account
  • Select the appropriate Spreadsheet and Worksheet
  • Format your sheet similarly to the sample template above

How to Customize the Workflow

To tailor the workflow to your business needs:

  • Update the training data in your Google Sheet to include your own FAQs, product info, or customer scripts
  • Adjust prompt instructions in the OpenAI node to change the tone, style, or behavior of the response
  • Add filtering logic using IF or SWITCH nodes to categorize and route different types of messages
  • Integrate CRM or ticketing systems via additional HTTP or database nodes
  • Set custom response delay or batching using WAIT or LIMIT nodes to control the load

Support & Community

Need help setting up or customizing the workflow? Reach out here:

WhatsApp Support Assistant with GPT-4 Mini and Google Sheets Data Training

This n8n workflow creates an intelligent WhatsApp support assistant that leverages GPT-4 Mini for conversational AI and trains itself on data fetched from Google Sheets. It allows you to provide dynamic, AI-powered responses to WhatsApp messages, making your support operations more efficient and automated.

Description

This workflow automates the process of responding to WhatsApp messages using a sophisticated AI agent. It listens for incoming WhatsApp messages, processes them with a custom code snippet, and then uses a LangChain AI Agent powered by GPT-4 Mini and a simple memory buffer to generate intelligent responses. The AI agent's knowledge can be dynamically updated by ingesting data from Google Sheets (though the Google Sheets node itself is not present in this JSON, the workflow is designed to support such an integration).

What it does

  1. Listens for WhatsApp Messages: The workflow is triggered by incoming messages via a Webhook, which would typically be connected to a WhatsApp integration (e.g., Twilio, MessageBird, etc.).
  2. Processes Incoming Data: A "Code" node is used to parse and prepare the incoming message data for the AI agent.
  3. Initializes AI Agent: An "AI Agent" node (LangChain Agent) is set up to handle conversational logic.
  4. Configures Chat Model: The AI Agent uses an "OpenAI Chat Model" (specifically GPT-4 Mini, as suggested by the directory name) as its underlying language model.
  5. Manages Conversation History: A "Simple Memory" node (LangChain Memory Buffer Window) maintains a short-term memory of the conversation, allowing the AI to understand context.
  6. Generates Responses: The AI Agent processes the incoming message, utilizes its memory, and generates a relevant response.
  7. Sends HTTP Request: An "HTTP Request" node is responsible for sending the AI-generated response back to the user, likely via the WhatsApp API.

Prerequisites/Requirements

  • n8n Instance: A running n8n instance (self-hosted or cloud).
  • WhatsApp Integration: An external service that can send and receive WhatsApp messages via webhooks (e.g., Twilio, MessageBird, 360dialog, etc.). The Webhook node in this workflow will need to be configured with the URL provided by your WhatsApp integration.
  • OpenAI API Key: An API key for OpenAI to use the GPT-4 Mini chat model. This will be configured within the "OpenAI Chat Model" node.
  • Google Sheets (Optional, for training data): While not explicitly present in the provided JSON, the workflow's context suggests that Google Sheets would be used as a data source for training the AI agent. If you intend to use this feature, you would need a Google Sheets account and an n8n Google Sheets credential.

Setup/Usage

  1. Import the Workflow:
    • Copy the provided JSON code.
    • In your n8n instance, click "New" to create a new workflow.
    • Click the three dots menu (...) in the top right and select "Import from JSON".
    • Paste the JSON and click "Import".
  2. Configure Webhook:
    • Locate the "Webhook" node.
    • Set the "Webhook URL" to "POST" and copy the generated URL.
    • Configure your WhatsApp integration (e.g., Twilio, MessageBird) to send incoming message webhooks to this URL.
  3. Configure OpenAI Credentials:
    • Locate the "OpenAI Chat Model" node.
    • Click on "Credentials" and add a new "OpenAI API" credential.
    • Enter your OpenAI API Key.
    • Ensure the "Model" is set to "gpt-4-mini" or a similar appropriate model.
  4. Configure AI Agent:
    • Review the "AI Agent" node configuration. The default "Plan and Execute" agent is powerful for complex tasks.
    • Adjust the "System Message" in the "OpenAI Chat Model" to define the AI's persona and instructions (e.g., "You are a helpful support assistant for [Your Company Name]. Answer questions based on the provided context.").
  5. Configure HTTP Request (for sending replies):
    • Locate the "HTTP Request" node.
    • Configure it to send a POST request to your WhatsApp integration's API endpoint for sending messages.
    • Map the AI agent's output (e.g., {{ $node["AI Agent"].json["text"] }}) to the message body.
    • Ensure proper authentication (e.g., API Key, Bearer Token) is set up for your WhatsApp API.
  6. Activate the Workflow:
    • Once all credentials and configurations are set, save the workflow and toggle the "Active" switch to enable it.

Note on Google Sheets Data Training: The workflow JSON provided does not include a Google Sheets node. To incorporate Google Sheets for training data, you would typically add a "Google Sheets" node before the "AI Agent" to fetch relevant data. This data would then be passed to the AI Agent (e.g., via a "Document Loader" or by embedding it directly into the system message or context of the AI Agent) to inform its responses.

Related Templates

Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution

AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative β€” all powered by AI logic, sir. --- πŸ’‘ Key Advantages ⚑ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. πŸ“Š Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. πŸ’¬ Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. πŸ” Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- βš™οΈ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the β€œLeads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- πŸ› οΈ Setup Steps Trigger Node: HubSpot β†’ Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the β€œLeads” table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- πŸ” Credentials Required HubSpot OAuth2 API – To fetch and update leads. Airtable Personal Access Token – To store and update lead data. OpenAI API – To power the AI qualification and matching logic. Slack OAuth2 – For sending team notifications. Gmail OAuth2 – For automatic email alerts to assigned reps, sir. --- πŸ‘€ Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- πŸ’¬ Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular β€” perfect for scaling across global sales teams, sir.

MANISH KUMARBy MANISH KUMAR
113

Track daily moods with AI analysis & reports using GPT-4o, Data Tables & Gmail

Track your daily mood in one tap and receive automated AI summaries of your emotional trends every week and month. Perfect for self-reflection, wellness tracking, or personal analytics. This workflow logs moods sent through a webhook (/mood) into Data Tables, analyzes them weekly and monthly with OpenAI (GPT-4o), and emails you clear summaries and actionable recommendations via Gmail. βš™οΈ How It Works Webhook – Mood β†’ Collects new entries (πŸ™‚, 😐, or 😩) plus an optional note. Set Mood Data β†’ Adds date, hour, and note fields automatically. Insert Mood Row β†’ Stores each record in a Data Table. Weekly Schedule (Sunday 20:00) β†’ Aggregates the last 7 days and sends a summarized report. Monthly Schedule (Day 1 at 08:00) β†’ Aggregates the last 30 days for a deeper AI analysis. OpenAI Analysis β†’ Generates insights, patterns, and 3 actionable recommendations. Gmail β†’ Sends the full report (chart + AI text) to your inbox. πŸ“Š Example Auto-Email Weekly Mood Summary (last 7 days) πŸ™‚ 5 β–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆ 😐 2 β–ˆβ–ˆβ–ˆβ–ˆ 😩 0 Average: 1.7 (Positive πŸ™‚) AI Insights: You’re trending upward this week β€” notes show that exercise days improved mood. Try keeping short walks mid-week to stabilize energy. 🧩 Requirements n8n Data Tables enabled OpenAI credential (GPT-4o or GPT-4 Turbo) Gmail OAuth2 credential to send summaries πŸ”§ Setup Instructions Connect your credentials: Add your own OpenAI and Gmail OAuth2 credentials. Set your Data Table ID: Open the Insert Mood Row node and enter your own Data Table ID. Without this, new moods won’t be stored. Replace the email placeholder: In the Gmail nodes, replace your.email@example.com with your actual address. Deploy and run: Send a test POST request to /mood (e.g. { "mood": "πŸ™‚", "note": "productive day" }) to log your first entry. ⚠️ Before activating the workflow, ensure you have configured the Data Table ID in the β€œInsert Mood Row” node. 🧠 AI Analysis Interprets mood patterns using GPT-4o. Highlights trends, potential triggers, and suggests 3 specific actions. Runs automatically every week and month. πŸ”’ Security No personal data is exposed outside your n8n instance. Always remove or anonymize credential references before sharing publicly. πŸ’‘ Ideal For Personal mood journaling and AI feedback Therapists tracking client progress Productivity or self-quantification projects πŸ—’οΈ Sticky Notes Guide 🟑 Mood Logging Webhook POST /mood receives mood + optional note. ⚠️ Configure your own Data Table ID in the β€œInsert Mood Row” node before running. 🟒 Weekly Summary Runs every Sunday 20:00 β†’ aggregates last 7 days β†’ generates AI insights + emails report. πŸ”΅ Monthly Summary Runs on Day 1 at 08:00 β†’ aggregates last 30 days β†’ creates monthly reflection. 🟣 AI Analysis Uses OpenAI GPT-4o to interpret trends and recommend actions. 🟠 Email Delivery Sends formatted summaries to your inbox automatically.

Jose CastilloBy Jose Castillo
105

Create, update, and get a person from Copper

This workflow allows you to create, update, and get a person from Copper. Copper node: This node will create a new person in Copper. Copper1 node: This node will update the information of the person that we created using the previous node. Copper2 node: This node will retrieve the information of the person that we created earlier.

Harshil AgrawalBy Harshil Agrawal
603