AutomationMart
Home/Browse/Customer support & lead collection chatbot with RAG, GPT-4o, Sheets & Telegram
n8n

Customer support & lead collection chatbot with RAG, GPT-4o, Sheets & Telegram

n8nn8n10 modulesv1.0
Google SheetsOpenAITelegram

Who’s it for This template is designed for small and medium businesses, startups, and agencies that want to automate customer inquiries, provide instant support, and capture leads without losing valuable conversations. It’s especially useful for teams that get many repetitive questions about products, services, or locations but don’t want to miss out on collecting contact details for follow-up. What it does / How it works The workflow creates a 24/7 AI-powered chatbot that answers company-relate

At a glance

Customer support & lead collection chatbot with RAG, GPT-4o, Sheets & Telegram is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, OpenAI, Telegram. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, OpenAI, Telegram
Modules
10
Price
Free
Version
v1.0
Customer support & lead collection chatbot with RAG, GPT-4o, Sheets & Telegram workflow diagram

About this workflow

Who’s it for This template is designed for small and medium businesses, startups, and agencies that want to automate customer inquiries, provide instant support, and capture leads without losing valuable conversations. It’s especially useful for teams that get many repetitive questions about products, services, or locations but don’t want to miss out on collecting contact details for follow-up. What it does / How it works The workflow creates a 24/7 AI-powered chatbot that answers company-related questions and collects customer information. It uses: • GPT-4o for natural conversations • Pinecone Vector Store for Retrieval-Augmented Generation (RAG) with your company knowledge base • Google Sheets to store structured lead data • Telegram to instantly notify your team When a customer asks about products, services, or hours, the AI answers using the Pinecone database. Afterwards, it politely asks for their name, email, phone number, and interest. The details are saved to Google Sheets and your team receives a Telegram message with a summary. How to set up 1. Connect your OpenAI account. 2. Create a Pinecone index with company FAQs, documents, or policies. 3. Link your Google Sheet with columns: Name, Email, Phone, Interested in. 4. Add your Telegram bot token and chat/group ID. 5. Replace [INSERTYOURCOMPANYNAMEHERE] in the system prompt with your company name. Requirements • OpenAI API key • Pinecone account • Google Sheets access • Telegram bot & chat ID How to customize • Change the system prompt to match your brand’s tone. • Update the Pinecone namespace and embeddings model if needed. • Add extra fields in Google Sheets (e.g., “Budget” or “Preferred product”). • Extend the flow with CRM integrations or automated email follow-ups. With this setup, you get a smart, RAG-powered chatbot that not only answers questions but also turns every conversation into a potential lead.

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

Send country-based user & session report from Google Analytics to Google Sheets

Gain deeper insights into your website’s traffic with our automated report that sends country-specific user and session data to Google Sheets every Friday. Easily adjust the scheduling to align with your analytical needs. The scenario is scheduled to execute every Friday at 17:00 which you can change in the schedule setting by clicking the clock icon on the first module.

Free

AI-Powered Email Campaign using a Name-Email Database

This HARPA AI + MAKE.COM scenario enriches your name-email database and creates personalized outreach emails to promote your offerings. You only need a name-email database that works with Google Sheets. Don't have one? You can export contacts from services like Hunter.io, Tomba.io, Dropcontact.io, findymail.com, or Instantly. If Google Sheets isn't your preferred tool, feel free to use Airtable or another CRM solution. Here's how it works: - HARPA scans company websites after receiving an ema

Free

Weekly SEO keyword research & competitor analysis with GPT5.5 and Bright Data

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically performs weekly keyword research and competitor analysis to discover trending keywords in your industry. It saves you time by eliminating the need to manually research keywords and provides a constantly updated database of trending search terms and opportunities. Overview This workflow automatically researches trending keywords for any specified topic or industry using

Free

Sync Youtube video URLs with Google Sheets

Sync Youtube Videos with Google Sheets (Part 1 of Youtube comments sentiment analyze automation along with detailed dashboard) This workflow is the first part of a multi-part automation system designed to perform large-scale YouTube comment sentiment analysis alongwith detailed dashboard. It solves the problem of manually tracking new videos across multiple YouTube channels by automatically fetching and organizing video URLs in a Google Sheet, setting the stage for deeper analysis in Part 2. Wha

Free

Domain to email extraction using Apollo API

Who is this for? - Sales professionals looking to build lead lists from target company domains - Business development teams conducting outreach campaigns - Marketers building contact databases for account-based marketing - Recruiters searching for potential candidates at specific companies - Anyone needing to transform a list of company domains into actionable contact information What problem is this workflow solving? Finding business email addresses for outreach is a time-consuming process. The

Free

Send a Telegram message from new Airtable records

Automatically send Telegram messages when new Airtable records are added, improving communication. Perfect for teams and project management.

Free

Create Shopify customers from a Google Sheet

Task Read a list of customers from a GoogleSheet and create them in Shopify using Shopify's Admin API (GraphQL). Why ? - Generate test users for development stores. - Migrate customers from other platforms. - Easy intro to Shopify's GraphQL API. Setup Setting up Google Sheets access Follow the instructions in the N8N Docs for granting Oauth2 access to Google services. You'll need to grant API access to Google Sheets and Google Drive (to list available sheets). Setting up Shopify access Shopify

Free

Extract LinkedIn post engagement data with Airtop

LinkedIn Post Engagement Data Extractor Use Case This automation is designed to extract key engagement metrics and audience data from a LinkedIn post. It's useful for analyzing the impact of content and identifying engaged users for lead generation, marketing, or research purposes. What It Does Given a LinkedIn post URL and an Airtop profile, this automation extracts: - Total number of reactions - Total number of comments - Total number of reposts - A list of users who reacted or commented, incl

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