AutomationMart
Home/Browse/AI-powered WhatsApp support bot with ticket creation for Google Sheets
n8n

AI-powered WhatsApp support bot with ticket creation for Google Sheets

n8nn8n32 modulesv1.0
agentchatTriggercodedocumentDefaultDataLoaderembeddingsOpenAiextractFromFileformTriggergmailToolgoogleSheetsToolhtmlhttpRequestlmChatOpenAimemoryBufferWindowmergeremoveDuplicatessetsplitInBatchesswitchvectorStorePineconewaitwhatsAppTriggerxml

This n8n workflow automates the entire process, from learning based on your website data, documents to a multi-channel chatbot with automated ticket creation. It's the perfect solution for businesses looking to build a powerful and intelligent chatbot, replace their customer support operations team with a website widget support and a dedicated WhatsApp support agent. How it Works 1. Data Ingestion & Vectorization: The workflow starts with a simple form where you can input your website's sitemap

At a glance

AI-powered WhatsApp support bot with ticket creation for Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects agent, chatTrigger, code, documentDefaultDataLoader. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
agent, chatTrigger, code, documentDefaultDataLoader, embeddingsOpenAi, extractFromFile
Modules
32
Price
Free
Version
v1.0
AI-powered WhatsApp support bot with ticket creation for Google Sheets workflow diagram

About this workflow

This n8n workflow automates the entire process, from learning based on your website data, documents to a multi-channel chatbot with automated ticket creation. It's the perfect solution for businesses looking to build a powerful and intelligent chatbot, replace their customer support operations team with a website widget support and a dedicated WhatsApp support agent. How it Works 1. Data Ingestion & Vectorization: The workflow starts with a simple form where you can input your website's sitemap, specific page URLs, and relevant documents containing your business information. n8n crawls and scrapes all the data from these sources. The scraped data is then processed and vectorized (converted into numerical representations). These vector embeddings are stored in a Pinecone Vector DB to create a powerful and searchable knowledge base. 2. Multi-Channel User Interaction: Website Widget Support: An integrated chatbot can be embedded directly onto your website. Users can ask questions and receive instant, accurate answers based on the vectorized data in Pinecone. WhatsApp Support Agent: A WhatsApp trigger allows users to interact with your business via WhatsApp. The bot responds to queries using the same knowledge base, making support accessible on a popular messaging platform. 3. Intelligent Ticket Creation: If a user describes a specific issue that requires human intervention, the bot will intelligently ask for more specific information (e.g., order number, user ID). Once the required information is provided, the workflow automatically creates a new support ticket in a designated Google Sheet. 4. Automated Communication: After a ticket is created, the workflow automatically sends a confirmation email to the user. This email contains the ticket details and a confirmation that their issue has been logged, ensuring a smooth and professional customer experience. Requirements n8n: A self-hosted or cloud instance of n8n. Pinecone: An account and API key for Pinecone to store your vector data. Google Sheets: A Google account with a designated spreadsheet for storing support tickets. Email Service: An email service provider (e.g., Gmail, SendGrid, Mailgun) configured with n8n to send automated emails. WhatsApp Business API: Access to the WhatsApp Business API for the WhatsApp trigger. How to Use 1. Configure Credentials: Set up your credentials for Pinecone, Google Sheets, your email service, and the WhatsApp Business API within n8n. 2. Populate the Knowledge Base: Use the provided form to enter your website's sitemap, specific URLs, and documents. Run the initial part of the workflow to scrape and store this data in Pinecone. 3. Activate the Chatbots: Deploy the website widget and activate the WhatsApp trigger. 4. Monitor and Manage: Monitor the incoming tickets in your Google Sheet and manage customer queries efficiently, knowing that the automated system is handling the initial interactions and basic queries.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Daily startup intelligence: Crunchbase updates to email digest with GPT

Automated Startup Intelligence: CrunchBase Updates to Email Digest Workflow! Workflow Overview This cutting-edge n8n automation is a sophisticated startup intelligence tool designed to transform market research into actionable insights. By intelligently connecting CrunchBase, AI processing, and Gmail, this workflow: 1. Discovers Startup Updates: - Automatically retrieves latest company information - Tracks recent organizational changes - Eliminates manual market research efforts 2. Intellige

Free

Automated LinkedIn lead generation, scoring & communication with AI-Agent

DISCLAIMER: This workflow uses the AnySite LinkedIn community node, which is only available on self-hosted n8n instances. It will not work on n8n.cloud. Overview This workflow automates the entire LinkedIn lead generation process from finding prospects that match your Ideal Customer Profile (ICP) to sending personalized messages. It uses AI to analyze lead data, score potential clients, and prioritize your outreach efforts. Key Features - AI-Driven Lead Generation: Convert ICP descriptions into

Free

Create a Slack AI chatbot with threads & thinking UI using OpenRouter & Postgres

Overview Slack quietly released an update to their API that allows developers to build "AI Apps & Agents", which is a special classification of apps that have access to several special capabilities including: - Multiple simultaneous chat threads with one user - Loading "three dots" UI while your agent is thinking - Option for users to pin your app to their top bar for quick chat access This workflow demonstrates how to build a Slack agent that takes advantage of all of these features. For

Free

Export search console results to Google Sheets

How it works This workflow gets the search console results data and exports this to google sheets. This makes it easier to visualize and do other SEO related tasks and activities without having to log into Search Console Setup and use 1. Set your desired schedule 2. Enter your desired domain 3. Connect to your Google sheets or make a copy of this sheet. Detailed Setup - Inputs and Outputs: - Input: API response from Google Search Console regarding keywords, page data, and date data. - Output: E

Free

B2B lead qualification

This automated n8n workflow qualifies B2B leads via voice calls using the VAPI API and integrates the collected data into Google Sheets. It triggers when a new lead’s phone number is added, streamlining lead qualification and data capture. What is VAPI? VAPI is an API service that enables voice call automation, used here to qualify leads by capturing structured data through interactive calls. Good to Know - VAPI API calls may incur costs based on usage; check VAPI pricing for details. - Ensure G

Free

Automated resume screening & ranking with Llama 4 AI and Google Workspace

Target Audience You will find this workflow or template perfect if you are in the internal talent acquisition teams, recruitment agencies, HR professionals, and hiring managers seeking to bulk automate the initial screening of CVs and resumes. By eliminating manual evaluation and screening, you get smart AI-Agent helping you to have standardized efficient, and scalable solution for handling large volumes of applications. With bulk automation, you can focus strategic decision-making rather than

Free

Collect leads with a conversational GPT-4.1 chatbot and Google Sheets

Description A natural conversational AI chatbot that collects lead information (Name, Phone, Email, Message) one question at a time without feeling like a form. Uses session-based memory to track conversations, intelligently asks only for missing details, and saves complete leads to Google Sheets automatically. --- What this workflow does This workflow creates a human-like booking assistant that gathers lead information through natural conversation instead of traditional forms. The AI

Free

Create Google Drive folders by path

This workflow creates nested Google Drive folders from a path string (like Projects/Clients/Reports). It automatically handles the necessary folder lookups and creation steps required by Google Drive, then outputs the final folder's ID for immediate use. How it works This workflow streamlines the creation of nested folders in Google Drive: 1. Input: Provide a rootfolderid and a path (e.g., Projects/Clients/Reports) as input. 2. Path Parsing: The workflow splits the path into individual folder na

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free