Supabase Automation Workflows
154 ready-made Supabase workflows for n8n, Make, Zapier, Activepieces, and Pipedream. Supabase-backed automations: auth events, database triggers, storage.
AI-Powered RAG Q&A Chatbot with OpenAI, Google Sheets, Glide, & Supabase
**Automate AI-Powered RAG System with Contextual Q&A, Google Sheets Integration, and Glide Frontend-Powered by n8n, OpenAI, Supabase, and Google Apps Script.** # Tools & Services Used - Glide (Frontend for user interactions) - Google Sheets (Stores questions and answers) - Google Apps Script (Forms + media upload handling) - OpenAI (Embeddings + GPT-4 to rank and generate answers) - Supabase (Optional for image hosting) - n8n (Automation logic and backend glue) # Workflow Overview ## This automation performs the following steps: - **Trigger**: Webhook receives a user question from a Glide frontend. - **Fetch Data**: Retrieves Q&A entries (and optionally, image URLs) from a connected Google Sheet. - **Rank Relevance**: - OpenAI Embeddings rank the relevance of stored questions to the new input. - Top matches are passed to a GPT-4 prompt for answer generation. - **Generate Answer**: - GPT-4 creates a contextual answer using the best match. - Optional: Includes media URL if attached to the matched answer. - **Response**: Sends the formatted answer back to Glide frontend (text + optional image). # Prerequisites ## Active accounts and API keys for: - OpenAI (API key with GPT-4 and embedding access) - Google Sheets (linked via Service Account or OAuth2 credentials) - Glide App (with a form to submit questions) - Supabase (optional, if hosting user-uploaded media) - n8n Self-hosted (for community nodes and webhook access) # How to Use This Template ## Step 1: Import the Template - Upload the provided JSON into your self-hosted n8n instance. - Requires installation of the Community Node: @n8n/n8n-nodes-openai-embeddings ## Step 2: Configure Credentials - **Webhook Trigger**: Replace the Glide webhook URL with your actual endpoint from your app. - **Google Sheets Node**: Set the spreadsheet ID and worksheet name to fetch your Q&A dataset. - **OpenAI Nodes**: - Insert your OpenAI API key. - Confirm that both text-embedding-ada-002 (or similar) and gpt-4 are available. - **Supabase or Apps Script (Optional)**: Ensure image links are correctly formed in the Sheet. ## Step 3: Customize Prompts and Thresholds - Update the OpenAI ranking prompt or similarity threshold in the Function or Code node. - Tailor GPT-4 prompts to return concise or detailed answers based on your use case. # Initial Test Run - Simulate a Question: - Trigger the Glide form with a sample question. - Check n8n logs for: - Matching score/ranking success - Correct retrieval from Sheets - GPT-4 answer generation - Image URL handling (if enabled) # Production Prep - Add error-handling nodes for cases when Sheets are empty or GPT-4 fails. - Set up logging via Google Sheets, Supabase, or external database. - Rate-limit or debounce requests from Glide if needed. # Use Cases - Customer Support Portals: Offer instant Q&A with your business data. - Internal Knowledgebase: Employees can query training manuals and SOPs. - AI Concierge: Combine structured answers with a friendly tone for guest interactions. # Disclaimer - Validate Glide form inputs before full deployment. - Ensure your OpenAI and Google Sheets usage stays within quota limits.
n8n$24.99Telegram Bot with Supabase Memory and OpenAI Assistant Integration
### Video Guide I prepared a detailed guide that showed the whole process of building an AI bot, from the simplest version to the most complex in a template. [.png)](https://www.youtube.com/watch?v=QrZxuWgFqBI) ### Who is this for? This workflow is ideal for developers, chatbot enthusiasts, and businesses looking to build a dynamic Telegram bot with memory capabilities. The bot leverages OpenAI's assistant to interact with users and stores user data in Supabase for personalized conversations. ### What problem does this workflow solve? 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. ### What this workflow does 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. 1. **Receive New Message:** The bot listens for incoming messages from users in Telegram. 2. **Check User in Database:** The workflow checks if the user is already in the Supabase database using the `telegram_id`. 3. **Create New User (if necessary):** If the user does not exist, a new record is created in Supabase with the telegram_id and a unique `openai_thread_id`. 4. **Start or Continue Conversation with OpenAI:** Based on the user's context, the bot either creates a new thread or continues an existing one using the stored `openai_thread_id`. 5. **Merge Data:** User-specific data and conversation context are merged. 6. **Send and Receive Messages:** The message is sent to OpenAI, and the response is received and processed. 7. **Reply to User:** The bot sends OpenAI's response back to the user in Telegram. ### Setup 1. **Create a Telegram Bot** using the [Botfather](https://t.me/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'), 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.
n8n$14.99Enhance WordPress User Experience with AI Chatbot Using Supabase and OpenAI
This workflow integrates WordPress content with Supabase and OpenAI to create an AI chatbot that enhances user experience through Retrieval-Augmented Generation (RAG).
n8n$19.99Automated Website Downtime Alerts with LINE Notifications and Supabase Logging
This workflow monitors website uptime using the UptimeRobot API. It sends humorous downtime alerts to a LINE group and logs incidents in a Supabase database, ensuring timely notifications and record-keeping.
n8n$9.99Provide Real-time Updates for Notion Databases via Webhooks with Supabase
## Purpose This enables webhooks for nearly real-time updates (every 5 seconds) from Notion Databases. ## Problem Notion does not offer webhooks. Even worse, the “Last edited time” property, which we could use for polling, only updates every minute. This gives us a polling interval only as low as 2 minutes, and we still need to implement a comparing mechanism to detect changes. ## Solution This workflow caches states in between while doing efficient polling & comparing. It brings down the update latency from 2 minutes to 5 seconds and also provides the output of the changes only. ## Demo [](https://youtu.be/BROsXafy9Uw) ## How it works - Database Pages are frequently polled while filtered by a last modified timestamp for more efficiency. - Retrieved pages get compared with previously cached versions in Supabase. - Only new and changed pages are pushed to a registered webhook. ## Setup - Create a new project in Supabase and import the DB schema (provided through Gumroad). - Add a Last edited time property to your Notion Database, if it has none yet. - Define the dynamically generated settings_id from the settings table (Supabase) in the Globals node. - Define the Notion Database URL in the Globals node. - Define your custom Webhook URL in the last node where the results should be pushed to. - It is recommended to call this workflow using [this](https://n8n.io/workflows/2270-prevent-simultaneous-workflow-executions-with-redis/) template to prevent simultaneous workflow executions. - Set the Schedule trigger to every 5 seconds or less frequent. - More detailed instructions provided within the workflow file and the illustrated instructions provided during the download. ## Example output ```json [ { "action": "changed", "changes": { "property_modified_at": "2024-06-04T17:59:00.000Z", "property_priority": "important" }, "data": { "id": "ba761e03-7d6d-44c2-8e8d-c8a4fb930d0f", "name": "Try out n8n", "url": "https://www.notion.so/Try-out-n8n-ba761e037d6d44c28e8dc8a4fb930d0f", "property_todoist_id": "", "property_id": "ba761e037d6d44c28e8dc8a4fb930d0f", "property_modified_at": "2024-06-04T17:59:00.000Z", "property_status": "Backlog", "property_priority": "important", "property_due": { "start": "2024-06-05", "end": null, "time_zone": null }, "property_focus": false, "property_name": "Try out n8n" }, "updated_at": "2024-06-04T17:59:42.144+00:00" } ] ```
n8n$14.99AI Chat Assistant for Supabase and Google Drive Files
Automate your file interactions with an AI chat agent, leveraging Supabase Storage and Google Drive.
n8n$24.99Store WhatsApp/Slack Chat Data in Supabase PostgreSQL
Captures user chat data from WhatsApp or Slack and stores it securely in Supabase PostgreSQL. Perfect for chatbots requiring persistent data storage with easy setup guide.
n8n$12.99Automated Slack IT Helpdesk with GPT, Supabase Vector Search & JIRA
Automates IT support in Slack using GPT for AI responses, Supabase for vector knowledge search, and JIRA for ticketing with emoji triggers.
n8n$24.99Telegram Document Q&A Bot with Gemini AI & Supabase Vector Search
Build a Telegram AI chatbot that answers questions from uploaded PDFs using Gemini for embeddings and Supabase for vector search, with rich HTML formatting.
n8n$24.99AI Voice & Text Note-Taking with LINE, Supabase Vector DB & Gmail
Capture text/voice notes from LINE chats, transcribe audio, store in Supabase Vector DB, send daily Gmail summaries, and query for ideas/quizzes.
n8n$24.99Multi-Modal Telegram Support Bot with GPT-4 & Supabase RAG
Builds a smart Telegram bot handling text, images, audio, docs via OpenAI GPT-4 and Supabase RAG for context-aware responses.
n8n$24.99Automated Zoho Inventory to Supabase Product Sync Pipeline
Automates syncing of products, variants, stock levels, and metadata from Zoho Inventory to Supabase via scheduled runs with secure OAuth authentication.
n8n$16.99Supabase AI Agent Server with RAG & Multi-Tenant CRUD
Stateful AI agent workflow powered by Supabase and RAG for persistent memory, dynamic CRUD operations, and multi-tenant data isolation in AI applications.
n8n$24.99🤖 Documentation Expert Bot with RAG, Gemini & Supabase
Build a RAG-powered AI chatbot that specializes in n8n documentation using Gemini for accurate answers and Supabase for vector storage.
n8n$24.99Advanced Multi-Query RAG System with Supabase & GPT-5
Build a sophisticated RAG workflow that decomposes complex queries, filters relevance, and synthesizes answers using Supabase and GPT-5 for superior AI research assistance.
n8n$24.99Inbox Manager: AI Email Automation with GPT, Calendar & Supabase
Automates email management by categorizing messages with AI, drafting replies via Google Calendar checks or Supabase knowledge base, and sending Telegram alerts for leads.
n8n$24.99AI-Powered Personalized Cold Email Sequences with GPT-4, Mailgun & Supabase
Automates 3-step personalized cold email sequences using GPT-4 for AI research and content generation, Mailgun for throttled delivery, and Supabase for lead management to boost reply rates.
n8n$24.99RAG Knowledge Chatbot: OpenAI, Google Drive & Supabase
Build a smart RAG chatbot that queries your Google Drive PDFs using OpenAI embeddings stored in Supabase for accurate, context-aware responses.
n8n$24.99Resume Data Extraction from Emails to Supabase
Automates AI-powered extraction of key resume data (name, skills, experience) from email attachments and stores it in Supabase, streamlining HR workflows.
n8n$22.99Reddit Lead Finder: AI Prospecting with GPT-4, Supabase & Gmail
Automates Reddit subreddit monitoring for sales leads using GPT-4 analysis, Supabase deduplication, Google Sheets storage, and Gmail alerts. Ideal for targeted prospecting in any niche market.
n8n$24.99Automate Spotify Playlist Management with Supabase Integration
This workflow automates the process of capturing Spotify playlist snapshots and managing related database entries in Supabase. It retrieves the current state of a specified playlist, checks for any changes compared to the last snapshot, and if dif...
n8n$19.99Literary English/German to Chinese Dictionary with GPT-4o-mini & Supabase
Automates creation of literary bilingual dictionaries from English/German to Chinese using GPT-4o-mini for definitions and examples, with Supabase storage via webhook.
n8n$14.99Voice AI Assistant: Telegram + Deepgram + OpenAI + Supabase
AI-powered voice-to-voice chatbot for Telegram using Deepgram STT/TTS, OpenAI processing, and Supabase knowledge base for contextual conversations.
n8n$24.99Automated WhatsApp Lead Nurturing with Gallabox & Supabase
Hourly automated WhatsApp messaging workflow that nurtures leads based on disposition status and message history from Supabase, using Gallabox for delivery.
n8n$22.99
More integrations
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work