Hadi Kianersi

n8n

n8n Automation Projects

A selection of workflow automation projects built with n8n, Telegram, PostgreSQL, external APIs, and scheduled processes.

These projects were designed to reduce repetitive operational work, connect multiple services, automate customer interactions, and create reliable backend workflows without requiring a separate application for every process.

Telegram VPN Sales and Provisioning Bot

Category: Workflow Automation / Telegram Bot / Service Provisioning
Technologies: n8n, Telegram Bot API, PostgreSQL, 3X-UI API, HTTP APIs
Type: End-to-End Sales and Account Provisioning Workflow

This project is an automated Telegram-based sales system for purchasing and renewing VPN services.

The workflow manages the complete customer journey inside Telegram, from selecting a service plan to receiving the final VPN connection details.

Main Workflow

  • Display available VPN plans to the user
  • Allow the customer to select a subscription plan
  • Create and store an order in PostgreSQL
  • Send USDT payment instructions through Telegram
  • Receive and save the customer’s transaction ID
  • Send the payment request to an administrator for review
  • Approve or reject the payment
  • Create the customer account automatically through the 3X-UI API
  • Generate the VPN connection link
  • Send the service configuration directly to the customer

Key Features

  • Telegram-based customer interaction
  • Semi-automated USDT payment verification
  • Administrative approval workflow
  • Automatic account creation in 3X-UI
  • PostgreSQL-based order and account storage
  • Automated delivery of VPN configuration links
  • Support for both new purchases and service renewals
  • Environment-based configuration for easier deployment

Technical Architecture

The workflow uses Telegram as the user interface, n8n as the automation and orchestration layer, PostgreSQL as the main database, and the 3X-UI API for VPN account provisioning.

The connection details were designed to be configurable through separate environment variables, allowing the server panel address and the customer connection address to be managed independently.

Project Summary

I developed this workflow to turn a manual VPN sales process into a structured and mostly automated service.

The automation reduces the need for manual order registration, customer follow-up, account creation, and configuration delivery, while keeping payment approval under administrator control.

VPN Account Expiration Reminder Automation

Category: Customer Retention / Scheduled Automation
Technologies: n8n, PostgreSQL, Telegram Bot API
Type: Scheduled Notification Workflow

This workflow automatically checks active VPN accounts and identifies services that are close to expiration.

It runs on a scheduled basis, retrieves account data from PostgreSQL, and sends reminder messages to customers through Telegram.

Main Workflow

  • Check active VPN accounts on a daily schedule
  • Identify subscriptions approaching their expiration date
  • Send an automated renewal reminder to the customer
  • Mark the reminder as sent in the database
  • Prevent duplicate reminder messages
  • Support the renewal flow through the Telegram sales bot

Business Purpose

The workflow helps reduce expired subscriptions caused by forgotten renewal dates and provides customers with a timely opportunity to extend their service.

It also removes the need for administrators to manually check expiration dates and contact users individually.

Project Summary

I built this automation as part of the VPN sales system to improve customer retention and automate subscription lifecycle management.

 

Daily VPN Plan Publishing Automation

Category: Content Automation / Telegram Channel Management
Technologies: n8n, PostgreSQL, Telegram HTTP API
Type: Scheduled Channel Publishing Workflow

This project automatically publishes active VPN subscription plans to a Telegram channel every day.

The workflow retrieves the current plans and messaging settings from PostgreSQL, formats them into a structured promotional message, and posts the result to the selected Telegram channel.

Main Workflow

  • Run automatically every day at 9:00
  • Load Telegram and channel settings from PostgreSQL
  • Query currently active VPN plans
  • Build a formatted channel post
  • Publish the message through the Telegram API
  • Keep plan information synchronized with the database

Key Benefits

  • Eliminates manual daily posting
  • Ensures that only active plans are published
  • Keeps pricing and package information consistent
  • Allows administrators to update plans through the database
  • Supports regular Telegram channel activity

Project Summary

I created this workflow to automate repetitive channel publishing and ensure that service plans are shared consistently without manual intervention.

Daily Quote Publishing Workflow

Category: Content Aggregation / Scheduled Publishing
Technologies: n8n, HTTP Request, HTML Extraction, Telegram API, PostgreSQL
Type: Web Content Extraction and Publishing Automation

This workflow automatically retrieves a daily quote from Time.ir and publishes it to a Telegram channel.

The automation fetches the source webpage, extracts the required text from the HTML response, formats the message, and sends it through the Telegram Bot API.

Main Workflow

  • Run automatically on a daily schedule
  • Fetch the daily quote page from Time.ir
  • Extract the quote from the webpage HTML
  • Format the extracted content
  • Load Telegram settings from PostgreSQL
  • Publish the quote to a Telegram channel

Key Features

  • Automated external content retrieval
  • HTML content extraction
  • Scheduled Telegram publishing
  • Centralized settings stored in PostgreSQL
  • No manual copy-and-paste process

Project Summary

I developed this workflow to demonstrate how n8n can connect external web content, data extraction, scheduling, and Telegram publishing in a single automated process.

Bale Commerce Automation with WooCommerce

Category: E-commerce Automation / Messaging Bot / Order Management
Technologies: n8n, Bale Bot API, WooCommerce, WordPress, Nextcloud, Webhooks
Type: Automated Sales and Payment Approval Workflow

This project is an automated e-commerce workflow that connects a Bale messaging bot with WooCommerce and WordPress.

The system allows customers to browse products, submit purchase requests, upload payment receipts, and follow their order status directly through Bale.

Main Workflow

  • Receive customer requests through a Bale bot
  • Display available products and purchasing options
  • Create or update WooCommerce orders
  • Collect customer information
  • Receive payment receipt images
  • Upload receipt files to Nextcloud
  • Save the private or shared receipt link in WooCommerce order metadata
  • Send the payment receipt to an administrator through Bale
  • Allow the administrator to approve or reject the payment
  • Update the WooCommerce order status automatically
  • Send the final payment result to the customer

Physical Product Delivery Workflow

A separate workflow was designed for physical products that require postal delivery.

This workflow:

  • Retrieves the customer’s postal address from WordPress and WooCommerce
  • Stores shipping information with the order
  • Waits for the postal tracking code
  • Sends the tracking code to the customer through Bale
  • Keeps the customer informed about the order status

Key Features

  • Bale-based shopping experience
  • WooCommerce order integration
  • Payment receipt approval
  • Nextcloud file storage
  • Order metadata synchronization
  • Administrator approval flow
  • Postal shipment tracking
  • Automated customer notifications

Project Summary

I designed this workflow to connect a local messaging platform with WooCommerce and automate the full purchase process.

The system reduces manual communication between customers, administrators, and the online store while keeping order, payment, and shipment information synchronized.

AI Photo Generation Bot

Category: Artificial Intelligence / Image Generation / Bot Automation
Technologies: n8n, Bale Bot API, PostgreSQL, AI Image APIs, Webhooks
Type: Credit-Based AI Image Generation Platform

This project is an AI-powered photo generation bot built around Bale and n8n.

Users interact with the bot, select an image model, upload their own photo, and receive a generated or transformed image based on the selected template.

Main Workflow

  • Receive user messages through a Bale webhook
  • Register or identify the user in PostgreSQL
  • Display available AI image models
  • Show a preview image for each model
  • Allow the user to select a model
  • Request the user’s source photo
  • Download the uploaded file from Bale
  • Send the image and prompt to an AI image-processing service
  • Deduct credits from the user’s balance
  • Save payment and credit information
  • Return the final generated image to the user

Database Structure

The system uses PostgreSQL tables for:

  • AI image models
  • Model prompts and templates
  • Credit plans
  • User balances
  • Payments
  • Generated image requests

One of the main tables used for AI model definitions was:

n8naiphoto_image_models

Each model could include:

  • Model name
  • Prompt template
  • Provider name
  • Provider endpoint
  • Preview image
  • Credit cost

Key Features

  • AI image generation through a messaging bot
  • Model preview before selection
  • Credit-based usage system
  • PostgreSQL-driven model management
  • Payment and balance tracking
  • External AI worker integration
  • Image upload and delivery through Bale

Project Summary

I developed this workflow as a modular AI image-generation platform where models, prompts, pricing, and providers can be managed from the database.

n8n acts as the orchestration layer between Bale, PostgreSQL, the payment system, and the AI image-processing service.

Multilingual Health Content Automation

Category: Content Automation / Health Publishing / Multilingual Workflow
Technologies: n8n, WordPress, HTTP APIs, Bale, HTML Processing, Proxy
Type: Automated Content Generation and Publishing Workflow

This project automates the preparation and publishing of multilingual health content.

The workflow was designed to process content in Persian, English, and Arabic, enrich the article structure, insert HTML blocks, manage featured images, and publish the final content to a website.

Main Workflow

  • Receive or prepare health-related source content
  • Process the article in three languages
  • Generate Persian, English, and Arabic HTML sections
  • Insert custom HTML blocks after the first paragraph
  • Add the featured image at the end of the article
  • Send the content to WordPress
  • Use a proxy for external requests when direct access is restricted
  • Deliver workflow notifications through Bale

External Access Configuration

The workflow required a proxy for accessing external health-related sources.

Proxy configuration used:

31.57.62.118:8888

This proxy was added to the request path so n8n could retrieve external content and continue the publishing workflow.

Key Features

  • Persian, English, and Arabic article processing
  • WordPress publishing automation
  • Dynamic HTML insertion
  • Featured-image handling
  • External API and website access
  • Proxy-enabled requests
  • Bale-based workflow communication
  • Importable n8n JSON with variables defined at the start

Project Summary

I designed this workflow to reduce the manual work involved in publishing multilingual health content.

The system standardizes article structure across three languages and automates content preparation, media handling, and WordPress publishing.

Physical Product Shipping and Tracking Workflow

Category: E-commerce Automation / Logistics / Order Fulfillment
Technologies: n8n, WooCommerce, WordPress, Bale Bot API, PostgreSQL, Webhooks
Type: Automated Shipping and Customer Notification Workflow

This project automates the fulfillment process for physical product orders, from collecting the customer’s delivery information to sending the final tracking details.

The workflow connects WooCommerce, WordPress, the Bale messaging platform, and backend automation services to reduce manual order handling and keep customers informed throughout the shipping process.

Main Workflow

  • Receive a confirmed physical product order

  • Retrieve customer and order information from WooCommerce

  • Collect or validate the customer’s postal address

  • Save shipping details in the order record

  • Notify the administrator that the order is ready for fulfillment

  • Wait for the shipping or postal tracking code

  • Save the tracking number in WooCommerce

  • Update the order status automatically

  • Send the tracking code to the customer through Bale

  • Notify the customer when the order is dispatched

Key Features

  • WooCommerce order synchronization

  • Customer address collection and validation

  • Automated shipping-status updates

  • Postal tracking-code management

  • Bale customer notifications

  • Webhook-based order processing

  • Reduced manual communication

  • Centralized order and delivery information

Business Value

The workflow simplifies the operational process of shipping physical products by connecting order data, customer information, fulfillment status, and messaging in one automated system.

It helps reduce shipping errors, shortens response time, and gives customers clear visibility into the status of their purchase.

Project Summary

I designed this workflow to automate the post-purchase journey for physical products.

Once an order is approved, the system manages address information, shipment preparation, tracking-code registration, order-status updates, and customer notifications. This creates a more reliable fulfillment process and reduces repetitive administrative work.