SQL query to create table in Supabase:

create table
  public.telegram_users (
    id uuid not null default gen_random_uuid (),
    date_created timestamp with time zone not null default (now() at time zone 'utc'::text),
    telegram_id bigint null,
    openai_thread_id text null,
    constraint telegram_users_pkey primary key (id)
  ) tablespace pg_default;

Create assistant in OpenAI.

Specify own assistant id here

Create own Telegram bot in Botfather bot

Create table in Supabase with SQL query

Set up steps

1. Create a Telegram Bot using the Botfather and obtain the bot token.
2. Set up Supabase:
   1. Create a new project and generate a SUPABASE_URL and SUPABASE_KEY.
   2. Create a new table named telegram_users with the following SQL query:

create table
  public.telegram_users (
    id uuid not null default gen_random_uuid (),
    date_created timestamp with time zone not null default (now() at time zone 'utc'::text),
    telegram_id bigint null,
    openai_thread_id text null,
    constraint telegram_users_pkey primary key (id)
  ) tablespace pg_default;

3. OpenAI Setup:
   1. Create an OpenAI assistant and obtain the OPENAI_API_KEY.
   2. Customize your assistant’s personality or use cases according to your requirements.
4. Environment Configuration in n8n:
   1. Configure the Telegram, Supabase, and OpenAI nodes with the appropriate credentials.
   2. Set up triggers for receiving messages and handling conversation logic.
   3. Set up OpenAI assistant ID in "++OPENAI - Run assistant++" node.

AI Telegram Bot with Supabase memory

Made by Mark Shcherbakov from community 5minAI

Many simple chatbots lack context awareness and user memory. This workflow solves that by integrating Supabase to keep track of user sessions (via telegram_id and openai_thread_id), allowing the bot to maintain continuity and context in conversations, leading to a more human-like and engaging experience.

This Telegram bot template connects with OpenAI to answer user queries while storing and retrieving user information from a Supabase database. The memory component ensures that the bot can reference past interactions, making it suitable for use cases such as customer support, virtual assistants, or any application where context retention is crucial.

... or watch set up video [5 min]

AI Telegram Bot with Supabase memory

Purpose and structure

This folder contains the AI Telegram Bot with Supabase memory workflow. Its executable nodes use httpRequest, if, merge, supabase, telegram, telegramTrigger. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Get New Message

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Http/0594_HTTP_Telegram_Create_Webhook.json MIT; preserve source notices.