AutomationMart
Home/Browse/Personal knowledgebase AI agent
n8n

Personal knowledgebase AI agent

n8nn8n19 modulesv1.0
Google SheetsTelegramGemini

How it works: This project creates a personal AI knowledge assistant that operates through Telegram. The assistant can extract summaries from YouTube videos or online articles, store them in Google Sheets for later reference, and retrieve stored summaries when requested by the user. Step-by-step: Google Sheets Trigger: The workflow starts by detecting a new YouTube or article URL added to a dedicated sheet (Sheet2). It checks whether the link is already processed. Link

At a glance

Personal knowledgebase AI agent is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Telegram, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Telegram, Gemini
Modules
19
Price
Free
Version
v1.0
Personal knowledgebase AI agent workflow diagram

About this workflow

How it works: This project creates a personal AI knowledge assistant that operates through Telegram. The assistant can extract summaries from YouTube videos or online articles, store them in Google Sheets for later reference, and retrieve stored summaries when requested by the user. Step-by-step: Google Sheets Trigger: The workflow starts by detecting a new YouTube or article URL added to a dedicated sheet (Sheet2). It checks whether the link is already processed. Link Type Detection: The system identifies if the URL is from YouTube or a standard article. Data Retrieval: If it’s YouTube: Uses Apify to fetch the transcript. If it’s an article: Uses an HTTP Request node to fetch the webpage content. AI Summarization: The transcript or article content is passed to Google Gemini for refined summarization. Google Sheets Storage: The summary and title are appended to another sheet (Sheet1) for long-term storage, along with a “Stored” status update in Sheet2. Telegram Assistant: A Telegram Trigger listens for messages from the user. The assistant searches stored summaries in Google Sheets. If a match is found, it returns the result to the user on Telegram; otherwise, it politely apologizes. ---

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

BrowserAct Intelligent Software Category Search Bot

This template creates a fully automated business app recommendation bot for Telegram. It starts by analyzing the user’s message with AI to determine whether the user is casually chatting or requesting a software recommendation. If a valid category is detected, BrowserAct is triggered to search G2 and extract app details such as name, company, description, pros and cons, images, and review links. The extracted data is then processed by Gemini, which formats each item into a clean JSON structure c

Free

Add Google Sheets rows for new Memberful subscriptions created

Every time a new subscription is created in your Memberful, Make will automatically add a Google Sheets row. Here's the [sheet](https://docs.google.com/spreadsheets/d/1gD0ScQqx1Pgw3MqU1GEjgFs4svY2_CnbEs2ptcvCPIM/edit?usp=sharing) used in this scenario.

Free

Smart Gmail cleaner with AI validator & Telegram alerts

Automatically clean up your Gmail inbox by deleting unwanted emails, validated by Gemini AI. Ideal for anyone tired of manual inbox cleanup, this workflow helps you save time while staying in control, with full transparency via Telegram alerts. How it works - Scans Gmail inbox in adjustable 2-week batches - Uses Gemini AI to decide if an email should be deleted or skipped - Applies a label to skipped emails to avoid rechecking in future runs - Deletes unwanted emails and sends a Telegram mes

Free

Create new Bannerbear images from new Google Sheets spreadsheet rows

Every time a new row is added to a Google Sheets spreadsheet, Make will automatically create a new image in Bannerbear. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1rfmN1VIjJIawhwIxLqoKxfSikwVrrkUM6XV3ynBc5Gs/edit?usp=sharing).

Free

Send Chatwork messages for new rows in Google Sheets

Streamline your team communication by automatically sending messages in Chatwork whenever a new row is added to your Google Sheets. This template ensures that important updates or data entries are instantly communicated to your team, enhancing collaboration and keeping everyone informed in real-time. Perfect for project management, tracking tasks, or sharing critical information, this integration helps you maintain a seamless workflow between Google Sheets and Chatwork.

Free

Generate personalized language learning news digests with LLaMA-3.1 & DeepSeek AI

Automatically generate and email level-appropriate language learning content based on trending news. This workflow reads learner preferences from Google Sheets (language, level, and topic of interest), uses an AI web search model to fetch relevant news, and formats the result into a structured HTML digest featuring grammar explanations and vocabulary highlights. Emails are sent automatically to each learner in a clean, mobile-friendly format. --- ⚙️ What it does 1. ⏰ Daily Trigger at 6 AM 2.

Free

Compare flight prices across multiple booking platforms with email reports

This workflow automates flight price comparison across multiple booking platforms (Kayak, Skyscanner, Expedia, Google Flights). It accepts natural language queries, extracts flight details using NLP, scrapes prices in parallel, identifies the best deals, and sends professional email reports with comprehensive price breakdowns and booking links. 📦 What You'll Get A fully functional, production-ready n8n workflow that: ✅ Compares flight prices across 4 major platforms (Kayak, Skyscanner, Expedia,

Free

Conversing with data: transforming text into SQL queries and visual curves

Conversational Data Retrieval and Visualization Workflow This workflow enables users to interact with a PostgreSQL database using natural language. It translates text inputs into SQL queries, retrieves the corresponding data, and generates visualizations using QuickChart, facilitating seamless data analysis without manual query writing. Table of Contents - Pre-conditions and Requirements - Database Schema Setup - Step-by-Step Workflow Explanation - Customization Guide Pre-conditions and Requirem

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