by Diego Alejandro Parrás
Manage Supabase database with Telegram commands How it works Receive message — Telegram trigger captures incoming bot messages Validate user — Checks if sender's chat ID is in the authorized list Parse command — Extracts command type (/add, /list, etc.) and parameters Route & execute — Performs the appropriate Supabase operation (INSERT, SELECT, UPDATE, DELETE) Respond — Sends formatted results back to Telegram Turn your Telegram into a powerful database management interface. This workflow lets you create, read, update, delete, and search records in your Supabase database using simple chat commands — no SQL knowledge required. Who is this for? Small business owners, freelancers, and teams who need to manage data on the go without opening dashboards or writing queries. Perfect for inventory tracking, simple CRM, expense logging, or any scenario where you need quick mobile access to your database. What problem does it solve? Managing database records typically requires logging into admin panels or writing SQL queries. This workflow eliminates that friction by letting you interact with your data through familiar Telegram messages, from anywhere, on any device. Benefits Mobile database access** — Manage your data from anywhere using just your phone Zero SQL required** — Simple commands replace complex database queries Secure by default** — Only authorized Telegram users can access your data Instant feedback** — Get formatted responses confirming every operation Fully customizable** — Adapt to any table structure with minimal changes Available commands | Command | Format | Example | |---------|--------|---------| | /add | name, price, quantity, category | /add iPhone 15, 999.99, 50, electronics | | /list | [category] | /list or /list electronics | | /get | id | /get 15 | | /update | id field=value | /update 15 price=899 quantity=45 | | /delete | id | /delete 15 | | /search | text | /search iPhone | | /help | — | Shows all available commands | Set up steps 1. Create your Telegram bot Message @BotFather on Telegram Send /newbot and follow the prompts Save the API token you receive 2. Get your Telegram chat ID Message @userinfobot on Telegram It will reply with your chat ID number 3. Create the Supabase table Run this SQL in your Supabase project's SQL Editor: CREATE TABLE products ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, price DECIMAL(10,2), quantity INTEGER DEFAULT 0, category TEXT, created_at TIMESTAMP DEFAULT NOW() ); 4. Configure the workflow Import the workflow into n8n Add your Telegram Bot credentials (using the API token from step 1) Add your Supabase credentials (Project URL + API Key from Supabase dashboard) Open the "Is Authorized?" node and replace 123456789 with your actual chat ID from step 2 Activate the workflow 5. Test it Send /help to your bot to verify everything works! Customization Adding more authorized users Open the "Is Authorized?" node Click "Add condition" Add another OR condition: chatId equals [new user's chat ID] Using a different table Change products to your table name in all Supabase nodes Update the field parsing in the "Parse Command and Parameters" code node Update field mappings in "Supabase Insert Product" and "Prepare Update Data" nodes Adjust the help message in "Send Help Message" node Adding more fields Modify the command parsing logic in "Parse Command and Parameters" Add field mappings in the Supabase Insert node Update the "Prepare Update Data" Set node with new fields Update the help message Example use cases Inventory management** — Track stock levels from your phone while in the warehouse Simple CRM** — Add and lookup contacts on the go Expense tracking** — Log expenses as they happen Task management** — Create and update tasks without opening any app Field data collection** — Teams can submit data from anywhere Requirements n8n instance (cloud or self-hosted) Telegram account Supabase account (free tier works) Difficulty level: Intermediate Estimated setup time: 15-20 minutes Monthly operating cost: $0 (Telegram and Supabase free tiers)
by Peliqan
How it works This template is an end-to-end demo of an in-house AI agent that can answer a wide range of questions by retrieving information from the Uniconta ERP system. For example users can ask questions related to products, stock, accounting or any other type of information contained in Uniconta. Peliqan.io is used as a "cache" of all Uniconta data. Peliqan uses one-click ELT to sync all data from Uniconta to the built-in data warehouse, allowing for fast & accurate queries. The AI agent uses Text-to-SQL to answer questions. Text-to-SQL is performed via the Peliqan node, added as a tool to the AI Agent. The question of the user - in natural language - is converted to an SQL query by the AI Agent. The query is executed by Peliqan.io on the source Uniconta data and the result is interpreted by the AI Agent. Preconditions You signed up for a Peliqan.io free trial account You have a Uniconta ERP system Set up steps Sign up for a free trial on peliqan.io Add Uniconta as a connection in Peliqan (using an API key from Uniconta) Copy your Peliqan API key (in Peliqan go to Settings > API key) and use it in n8n to add a Peliqan connection Select your data warehouse in the Peliqan node "Execute an SQL query via Peliqan" in the drop-down field "Data warehouse name or id" Optional: run the template script in Peliqan that outputs your specific Uniconta datamodel (tables & columns). Copy your datamodel and paste it in the System Message of the AI Agent (replace the standard Uniconta model already present in this workflow) Visit peliqan.io/n8n for more information. Need help ? Contact Peliqan at support@peliqan.io Disclaimer: This template contains a community node and therefore only works for n8n self-hosted users.
by Peliqan
How it works This template is an end-to-end demo of an in-house AI agent that can answer a wide range of questions by retrieving information from the Cin7 ERP system. For example users can ask questions related to products, stock, accounting or any other type of information contained in Cin7. Peliqan.io is used as a "cache" of all Cin7 data. Peliqan uses one-click ELT to sync all data from Cin7 to the built-in data warehouse, allowing for fast & accurate queries. The AI agent uses Text-to-SQL to answer questions. Text-to-SQL is performed via the Peliqan node, added as a tool to the AI Agent. The question of the user - in natural language - is converted to an SQL query by the AI Agent. The query is executed by Peliqan.io on the source Cin7 data and the result is interpreted by the AI Agent. Preconditions You signed up for a Peliqan.io free trial account You have a Cin7 Omni or Cin7 Core ERP system Set up steps Sign up for a free trial on peliqan.io Add Cin7 Omni or Cin7 Core as a connection in Peliqan (using an API key from Cin7) Copy your Peliqan API key (in Peliqan go to Settings > API key) and use it in n8n to add a Peliqan connection Select your data warehouse in the Peliqan node "Execute an SQL query via Peliqan" in the drop-down field "Data warehouse name or id" Optional: run the template script in Peliqan that outputs your specific Cin7 datamodel (tables & columns). Copy your datamodel and paste it in the System Message of the AI Agent (replace the standard Cin7 model already present in this workflow) Visit peliqan.io/n8n for more information. Need help ? Contact Peliqan at support@peliqan.io Disclaimer: This template contains a community node and therefore only works for n8n self-hosted users.
by Rahul Joshi
Description: Stay ahead of payment disputes with this automated n8n workflow that integrates Stripe, Slack, and ClickUp. Perfect for finance teams, payment ops specialists, and SaaS businesses, this template fetches disputes directly from Stripe, analyzes urgency, and instantly notifies your team with rich, formatted alerts. High-priority disputes are flagged, pushed into Slack for immediate visibility, and tracked in ClickUp with due dates aligned to Stripe evidence deadlines—ensuring no dispute ever slips through the cracks. For lower-priority or resolved cases, the workflow provides concise updates and maintains an audit trail. No more manual Stripe checks, late responses, or missed deadlines—this workflow turns dispute management into a proactive, structured process. What This Template Does (Step-by-Step): 🟢 Trigger: Manual or Scheduled Execution Run the workflow on demand or schedule it (e.g., every 4 hours). 📥 Fetch Stripe Disputes Calls the Stripe API to retrieve all active disputes in your account. 📊 Validate & Format Data Ensures disputes exist, then enriches data with formatted amounts, deadlines, and customer info. ⚖️ Priority Logic Determines urgency based on dispute status, evidence deadlines, and transaction amount. 🚨 High Priority Path • Sends urgent Slack alert with full dispute details • Creates a high-priority ClickUp task with due dates • Flags immediate action required 📋 Standard Path • Sends standard Slack alert for non-urgent cases • Creates a ClickUp task with appropriate priority levels ℹ️ No Disputes Path Sends a Slack summary confirming no new disputes, maintaining a clear audit trail. ✅ Workflow Completion Confirms all disputes are processed, logged, and assigned—ready for your team to take action. Required Integrations: ✅ Stripe API (for dispute data) ✅ Slack API (for team alerts) ✅ ClickUp API (for task management) Perfect For: 💳 FinOps and payment operations teams monitoring transactions 🏢 SaaS platforms or e-commerce handling large payment volumes 🛡️ Risk and compliance teams tracking disputes and deadlines 📈 Businesses scaling customer payment handling and case management Why Use This Template? ✔️ Never miss a dispute deadline ✔️ Automated priority assessment saves hours of manual checks ✔️ Seamlessly integrates alerts + task tracking ✔️ Provides full visibility and accountability for dispute resolution
by Ajay Yadav
A production-ready n8n workflow that automatically analyzes websites to detect e-commerce platforms, frameworks, payment gateways, and technology stacks. Perfect for lead generation, competitive analysis, and market research. 🎯 Use Cases Lead Generation: Identify potential e-commerce clients Competitive Analysis: Analyze competitor technology stacks Market Research: Understand technology adoption trends Sales Intelligence: Qualify prospects based on their tech stack Agency Services: Automated technology audits for clients ⚡ Key Features Comprehensive Detection 50+ E-commerce Platforms: Magento, Shopify, WooCommerce, BigCommerce, Squarespace, Wix, etc. Modern Frameworks: React, Vue.js, Next.js, Angular, WordPress, Gatsby Payment Gateways: Stripe, PayPal, Square, Klarna, Razorpay, Braintree E-commerce Features: Cart, Catalog, Checkout, Wishlist, PWA capabilities Custom E-commerce: Detects custom-built e-commerce solutions Production-Ready Features Intelligent Error Handling: Specific error types (DNS, SSL, timeout, 404, 500, etc.) Rate Limiting: Respectful 2-second delays between requests Batch Processing: Processes domains in chunks of 5 for optimal performance Retry Logic: 3 attempts with exponential backoff for failed requests SSL Handling: Ignores certificate issues for broader compatibility Smart Domain Processing Multiple Detection Methods: 8 different approaches to extract domain names Protocol Auto-Addition: Automatically adds https:// to bare domains Domain Cleaning: Removes www, paths, and query parameters HTML Meta Extraction: Fallback domain detection from og:url and canonical tags Advanced Analysis Confidence Scoring: 0-100% accuracy rating for each detection Comprehensive Logging: Detailed console output for debugging Multiple Triggers: Manual execution or scheduled automation Flexible Output: Updates Google Sheets with structured results
by Satoshi
Overview A cornerstone of your Order Management System, this workflow ensures seamless inventory control through fully automated stock checks, leading to a direct reduction in operational costs. It provides real-time alerts to the responsible personnel, enabling proactive issue detection and resolution to eliminate the financial damages associated with unexpected stock-outs. How it works Order Webhook Receives orders from external sources (e.g., website, form, or app) via API. Check Order Request Checks the validity of the order (e.g., complete product, valid customer details) Check Inventory Retrieve inventory information and compare it with the order request. Notifications Generate a notification to Slack for the manager indicating a successful order or an out-of-stock situation. Logging Log the process details to a Google Sheet for tracking. Set up steps Webhook Create a JSON request with the following format to call the Webhook Url { "id": "ORDER1001", "customer": { "name": "Customer", "email": "customer@example.com" }, "items": [ { "sku": "SKU001", "quantity": 2, "name": "Product A", "price": 5000 }, { "sku": "SKU002", "quantity": 2, "name": "Product C", "price": 10000 } ], "total": 30000 } Define the greater than or less than conditions on the inventory level to enter the corresponding branches. Google Sheet Clone the file to your Google Drive. (WMS Data Demo) Replace your credentials and connect. Access permission must be granted to n8n. Slack Replace your credentials and connect. A channel named "warehouse" needs to be prepared to receive notifications (if using a different name, you must update the Slack node).
by Richard Uren
Create Products in Shopify from Airtable This workflow creates products in your Shopify store from Airtable. It also enables inventory tracking and sets the quantity of an inventory item at your store's default location. This is a great way to keep shopify in sync with Airtable if Airtable is your primary source of data, Only records with the 'sync' column set to true are sync'd. Setup Airtable Automations so that if any records are created or updated then this flag is set to true. Records are matched using the 'slug' column which Shopify calls a handle. Airtable Setup Notes The Airtable products table has the following columns title - free text description - free text company - free text type - free text status - ACTIVE, DRAFT or ARCHIVE slug - used in the product url, text with no spaces, can also use hyphen. price - sale price of the products compare_at_price - compare at price for products sku - unique code for each product stock_on_hand - quantity of this item available for purchase. sync - boolean, set to true to sync this record. Update GraphQL nodes with your Shopify store URL 1) Replace the URL in all GraphQL nodes with the URL for your Shopify store. 2) All GraphQL requests all use the Shopify 2025-04 GraphQL Admin API.
by Fred Carbonare
This workflow instantly sends successful Stripe Checkout payments to RD Station Marketing by creating an Order & Payment Event for every confirmed transaction. It’s ideal for businesses that want to automate lead tracking, unify customer data, and trigger marketing automation flows at the moment of sale. Who’s it for This template is designed for online sellers, course creators, SaaS businesses, and marketers who use Stripe Checkout for payments and RD Station Marketing for lead management and automation. If you want real-time revenue data inside RD Station without manual work, this workflow is for you. How it works Stripe triggers the workflow whenever a Checkout Session is completed. The workflow checks the payment status and retrieves the list of purchased items. A new Order & Payment Event is sent to RD Station Marketing using the community node. You can extend the workflow to include customer details captured during checkout. How to set up Edit the Stripe Trigger and getItems nodes with your Stripe API keys. Add your RD Station Marketing credentials in the send2RDMKT node. In production, copy the workflow’s webhook URL and add it to your Stripe Webhook settings. Test the workflow with a real or test payment. Requirements A Stripe account and valid API keys An RD Station Marketing account Installation of the community node: RD Station Marketing for n8n Disclaimer: This workflow requires a self-hosted n8n instance because it uses a community node. How to customize the workflow You can extend the payload sent to RD Station Marketing to include additional fields such as customer name, email, coupon codes, or metadata collected in Stripe Checkout. Feel free to add routers, conditionals, or enrichment nodes depending on your marketing logic.
by System Admin
Tagged with: , , , ,
by System Admin
Tagged with: , , , ,
by System Admin
Tagged with: , , , ,
by System Admin
Tagged with: , , , ,