Airtable and Telegram integration

💅 AI Agents Generate Content & Automate Posting for Beauty Salon Social Media 📲 Who Is This For? This workflow is for beauty salons who want consistent, high‑quality social media content without writing every post manually. It also suits agencies and automation builders who manage multiple beauty brands and want a reusable, AI‑driven posting system they can adapt per client. What Problem Is This Workflow Solving? Many beauty businesses struggle to post regularly because research, copywriting, and design all take time and marketing skills. This workflow automates research, writing, image creation, and posting, so your channels stay active and relevant while you focus on clients and services. What This Workflow Does Generates short, engaging posts tailored to a beauty‑salon audience (hair, nails, skincare, make‑up, self‑care) using an AI agent. Uses Tavily Internet Search to pull up‑to‑date information and trends based on a reference link or topic. Turns each post into a detailed, photorealistic image prompt and creates a matching visual with an AI image model (for example, gpt‑image‑1 or other connected providers). Automatically sends the final text and image to Telegram, and can be extended to other social platforms from the Split Out node. How It Works Trigger the workflow Scheduled automatic generation:** Run the parent workflow on a schedule (for example, once per day at 9 AM) to publish new content regularly. Google Sheets trigger:** Generate content when a new row with a reference link or topic is added to your sheet. Use it when you manage ideas or briefs in Google Sheets and want the workflow to react as soon as a new idea appears. RSS Feed trigger:** Start the workflow when new items appear in a selected RSS feed. Ideal for turning fresh blog posts, news, or industry updates into social media content or automated summaries. Meta (Facebook/Instagram) webhook:** Use the Meta Reference trigger to fire the workflow on incoming webhooks from Meta (for example, new comments, messages, or events). Helpful when you want to auto‑respond, log activity, or generate follow‑up content from Meta activity. Airtable trigger:** Start the workflow when records in a selected Airtable base/table change (for example, a new idea, brief, or status update), so your posts react instantly to updates in your Airtable content board. Postgres trigger:** Fire the workflow when new rows are inserted or existing rows are updated in a connected PostgreSQL table, letting you drive content generation from events in your app database or Supabase‑style back end. Manual start:* Hit Execute workflow* whenever you want to spin up a batch of posts on demand, test new prompt settings, or debug the flow step by step. Research and generate copy The GENERATE TEXT agent calls Tavily to gather fresh information on the topic. It writes a post under 1024 characters with a hook, practical tips, relevant hashtags, and a closing line with your salon address and contact. Create the visual The GENERATE PROMPT agent converts the post into a single, clear description of the scene (client, service, salon interior, lighting, mood) with a strict “no text on image” rule. An image model such as gpt‑image‑1 or one of the HTTP image APIs renders a matching beauty visual. Distribute the content The Split Out node fans out the result so Telegram receives a photo post with the generated caption. Additional social or content nodes (for example Facebook, LinkedIn, X, template tools) can be wired after this step for multi‑channel posting. How to Customize This Workflow to Your Needs Brand voice** Edit the system message in the GENERATE TEXT node to adjust tone (luxury, friendly, clinical, playful), language, services, and city. Update the final address and phone line to match your salon details. Topics and triggers** Point the Google Sheets Trigger to your own document ID, sheet, and columns for ideas, links, or campaign themes. Use the Schedule Trigger for fully automatic posting or rely on the Manual Trigger for controlled, batch generation sessions. Models and providers** Swap GPT‑5 llm and the default image model for alternatives such as Mistral, Gemini, Anthropic, DeepSeek, or custom HTTP image APIs by enabling the corresponding nodes and adding credentials. Channels and outputs** Connect or remove social nodes after Split Out depending on which platforms you actively use. Add extra processing steps (for example resizing images or adding UTM parameters) before each channel if needed. Visual style** Tweak the GENERATE PROMPT instructions to control composition (close‑up vs. full‑body), color palette, lighting, and overall salon aesthetic, while keeping the constraint of no text or logos in the image.

Graceful Client Onboarding Concierge — Pro A warm, reliable onboarding system for small businesses and studios. Captures a form submission via webhook, creates a Client record in Notion, sends a concierge-style welcome email (with scheduler + optional contract link), optionally pings the owner on Telegram, mirrors the lead to Airtable/HubSpot, places a temporary Google Calendar hold, and includes a double opt-in confirmation link. Made for: coaches, designers, boutique agencies, e-commerce and service providers who want consistent follow-up without manual busywork. What it does (flow) Trigger:** Form ➜ POST /client-intake (or Manual Trigger for instant demo) Normalize & Score:** Map fields, auto-generate optInToken, compute score and tier Create in Notion:** Clients page (Name, Email, Package, Notes, Status, Score, Tier, OptInToken, Consent=false) Welcome Email:** industry-tuned copy + scheduler link (+ contract link for Growth/Pro/Custom packages) Owner Notify (optional):** Telegram ping with tier + score CRM Mirrors (optional):** Create Airtable row and/or HubSpot contact Calendar Hold (optional):** 30-min “Intro Hold” event (e.g., now + 48h) Double Opt-In:** /optin-confirm?token=...&email=... sets Consent=true & Status=Confirmed in Notion Error Handling:** On failure, send an email to the owner flowchart TD A[Form → Webhook /client-intake] --> B[Map Intake + Score Lead] B --> C[Notion: Create Client] B --> D[Build Welcome Email] D --> E[Email: Send Welcome] D --> F{Optional actions} F -->|Telegram| G[Telegram: Notify Owner] F -->|Airtable| H[Airtable: Create Row] F -->|HubSpot| I[HubSpot: Create Contact] F -->|Calendar Hold| J[Google Calendar: Create Hold] K[GET /optin-confirm] --> L[Find Notion by OptInToken] --> M[Update: Consent=true, Status=Confirmed] ER[Error Trigger] --> EH[Email Owner] Prerequisites Notion* database Clients* with properties: Name (title), Email (email), Package (select), Notes (rich text), Status (select), Score (number), Tier (select), OptInToken (text), Consent (checkbox) (CSV header provided in the Sticky note on canvas.) Email** (SMTP or Gmail OAuth) Optional:** Telegram Bot + Chat ID, Airtable (Base ID + Table), HubSpot (Contacts), Google Calendar (Calendar ID) Configuration (Set these in Set: User Config) NOTION_DB_ID = your Notion Clients DB ID FROM_EMAIL = sender address for welcome email OWNER_EMAIL = where error notifications go SCHEDULER_URL = booking link (Calendly, Once, etc.) BASE_URL = your public n8n domain (for opt-in link) CONTRACT_BASE_URL = (optional) proposal/contract URL base ENABLE_TELEGRAM = true|false TELEGRAM_CHAT_ID = (if enabled) ENABLE_AIRTABLE = true|false AIRTABLE_BASE_ID = (if enabled) AIRTABLE_TABLE = (if enabled) ENABLE_HUBSPOT = true|false ENABLE_CAL_HOLD = true|false CALENDAR_ID = "primary" or calendar ID HOLD_HOURS_FROM_NOW = number of hours (default 48) INDUSTRY = coaching | design_studio | ecommerce | services Credentials: Attach in node credentials panels (no secrets in JSON). How to use Import the workflow JSON. Open Set: User Config and fill required values (see above). Attach credentials: Notion + Email; optional Telegram/Airtable/HubSpot/Google Calendar. Run Manual Trigger to simulate an intake and verify: Notion page created Welcome email received Optional Telegram/CRM/Calendar actions Switch your form to the Production Webhook URL shown in the Client Intake Webhook node. Sample JSON (for testing the live webhook): {"name":"Ava Laurent","email":"[email protected]","package":"Growth","message":"Excited to begin!"} Double opt-in: The welcome email includes a link like https://YOUR-N8N-DOMAIN/webhook/optin-confirm?token=...&email=... Clicking it sets Consent=true and Status=Confirmed on the Notion record. Industry-tuned welcome copy Set INDUSTRY to control phrasing automatically: coaching – gentle goals/blocks framing design_studio – asset handoff + milestone language ecommerce – store link + quick-win focus services – general service language Submission compliance ✅ Manual Trigger path for instant demo ✅ Markdown sticky notes with clear H2 sections (README, Prereqs + CSV, Setup, Testing, Compliance, Changelog) ✅ No hardcoded API keys (credentials only) ✅ Timezone-safe ISO times for calendar hold ✅ Clear placeholders and copy-paste CSV headers included Troubleshooting (quick) No email:** attach Email creds; ensure FROM_EMAIL is allowed by your provider. No Notion page:** verify NOTION_DB_ID and property names; check Notion permissions. Webhook issues:* ensure your form sends JSON*; adapt mapping for form-encoded payloads. Opt-in link fails:** BASE_URL must be your public n8n domain; workflow must be active. Calendar hold not created:** set ENABLE_CAL_HOLD=true, attach Google Calendar creds, confirm CALENDAR_ID. Tags: onboarding, notion, email, crm, telegram, airtable, hubspot, calendar, double-opt-in, small business, concierge, women-led brands Version: v3 (see Changelog sticky on canvas)

> Reach out to me for any setup help/consulting. Automate the curation and sharing of trending GitHub discussions from Hacker News to Twitter and LinkedIn. This workflow leverages AI to generate engaging posts, streamlining your social media content creation and distribution. How it Works Crawl Hacker News for GitHub Posts: The workflow fetches trending GitHub-related discussions from Hacker News. Extract Key Information: Relevant data such as post titles, URLs, and metadata are extracted and filtered to focus only on unposted content. Fetch Additional Details: For each GitHub post, the workflow retrieves extra information from the GitHub repository page to enrich the post content. Generate Social Media Posts: Using AI, the workflow automatically generates tailored posts for Twitter and LinkedIn based on the collected data. Post to Twitter & LinkedIn: The generated content is posted to your Twitter and LinkedIn accounts. Track and Log Posts: Each post is logged in Airtable for tracking, and its status is updated to ensure no duplicate posts are made. Telegram Notification: After posting, a summary of the posts is sent to your Telegram chat for real-time updates. Requirements n8n Account**: Set up and configured. Sign up here. API Credentials**: Valid keys for LinkedIn, Twitter, Airtable, OpenAI, and Telegram. Airtable Base**: Configured with fields such as Title, URL, Post Content, Status, and Timestamp. Get started with Airtable. Telegram Chat ID**: For receiving real-time notifications. Set Up Steps Clone the Workflow: Import the workflow into your n8n environment using the provided JSON. Configure API Credentials: Enter your API keys for LinkedIn, Twitter, Airtable, OpenAI, and Telegram into the respective nodes. Set Up Airtable Base: Create an Airtable base with fields such as Title, URL, Post Content, Status, and Timestamp. Customize Telegram Chat ID: Modify the 'Ping me' node with your Telegram chat ID to receive notifications. Run the Workflow: Activate the workflow to start the automated content curation and posting process. Additional Resources n8n AI Agentic Workflows Guide n8n AI Workflow Tutorial n8n Community Tutorial on Building an AI-Powered Telegram Bot > Note: Chat GPT prompt should/can be tweaked in the step to give the desired behaviour. Sample Posts from my X and LinkedIn -**

Who is this for? This workflow is perfect for: HR professionals** seeking to automate employee and department management Startups and SMBs** that want an AI-powered HR assistant on Telegram Internal operations teams** that want to simplify onboarding and employee data tracking What problem is this workflow solving? Managing employee databases manually is error-prone and inefficient—especially for growing teams. This workflow solves that by: Enabling natural language-based HR operations directly through Telegram Automating the creation, retrieval, and deletion of employee records in Airtable Dynamically managing related data such as departments and job titles Handling data consistency and linking across relational tables automatically Providing a conversational interface backed by OpenAI for smart decision-making What this workflow does Using Telegram as the interface and Airtable as the backend database, this intelligent HR workflow allows users to: Chat in natural language (e.g. “Show me all employees” or “Create employee: Sarah, Marketing…”) Interpret and route requests via an AI Agent that acts as the orchestrator Query employee, department, and job title data from Airtable Create or update records as needed: Add new departments and job titles automatically if they don’t exist Create new employees and link them to the correct department and job title Delete employees based on ID Respond directly in Telegram, providing user-friendly feedback Setup View & Copy the Airtable base here: 👉 Employee Database Management – Airtable Base Template Telegram Bot: Set up a Telegram bot and connect it to the Telegram Trigger node Airtable: Prepare three Airtable tables: Employees with links to Departments and Job Titles Departments with Name & Description Job Titles with Title & Description Connect your Airtable API key and base/table IDs into the appropriate Airtable nodes Add your OpenAI API key to the AI Agent nodes Deploy both workflows: the main chatbot workflow and the employee creation sub-workflow Test with sample messages like: “Create employee: John Doe, [email protected], Engineering, Software Engineer” “Remove employee ID rec123xyz” How to customize this workflow to your needs Switch databases**: Replace Airtable with Notion, PostgreSQL, or Google Sheets if desired Enhance security**: Add authentication and validation before allowing deletion Add approval flows**: Integrate Telegram button-based approvals for sensitive actions Multi-language support**: Expand system prompts to support multiple languages Add logging**: Store every user action in a log table for auditability Expand capabilities**: Integrate payroll, time tracking, or Slack notifications Extra Tips This is a two-workflow setup. Make sure the sub-workflow is deployed and accessible from the main agent. Use Simple Memory per chat ID to preserve context across user queries. You can expand the orchestration logic by adding more tools to the main agent—such as “Get active employees only” or “List employees by job title.” Contact me for consulting and support: 📧 [email protected]

Who is this for? This template is ideal for B2B founders, solopreneurs, growth marketers, SDRs, or anyone looking to scale their lead generation and enrichment with no-code tools to low-code tools. Whether you're building your first lead pipeline or upgrading a manual spreadsheet, LeadAIgen automates the entire discovery → enrichment → logging process using AI and verified email data. What problem does this solve? Lead sourcing and enrichment are time-consuming, inconsistent, and often require multiple tools or manual scraping. This workflow solves that by chaining AI + contact discovery, validating everything, and storing clean, structured data in Google Sheets — ready for outreach or CRM sync. What this workflow does: ✅ Accepts an industry/topic prompt via chat trigger or Telegram, 🤖 Uses OpenRouter (Perplexity) to find 15 relevant companies with domains, 📤 Parses the results, filters duplicates based on your Google Sheet, 📩 Enriches each domain with up to 3 real personal emails using Hunter.io, 💡 If no emails found → Fallback AI tries to locate general email info, 📊 Updates your Google Sheet with all valid enriched leads (status: “Enriched”), 🔁 Runs in safe batches of 10 to protect your API limits, 🛠️ Includes logic to clean data, validate JSON, and slice leads. Setup: Create Google Sheets, Hunter.io, and OpenRouter credentials in your n8n instance Import the JSON workflow Set your OpenRouter model (default = Perplexity Sonar Large) Connect your Google Sheet (must contain a header row with Domain, Status, etc.) Paste your Hunter API key into the Hunter.io node (Optional) Add Telegram Bot trigger to chat with your lead generator 🗒 Color-coded workflow notes: To make customization easier, this template includes Innovatio's signature visual sticky note system inside the n8n canvas. You’ll find: 🟩 Green Notes → Main Steps The core logic blocks — from company generation to AI fallback and Google Sheets update. 🟦 Blue Notes → Personalization Tips How to adapt filters, prompts, and data mappings for your business needs. 🟨 Yellow Notes → Optional / Advanced Expand with Telegram chat triggers, Airtable integration, CRM push, or lead scoring logic. 🟫 Gray Notes → Welcome, Outro & Upgrade Suggestions Clear guidance and CTAs if you want help scaling this further. 👉 Each node includes comments or setup notes so you can learn the system as you use it. How to customize this workflow? 🎯 Swap Google Sheets for Airtable for relational views and tagging, 🤖 Replace Perplexity with GPT-4, Claude, or Mixtral inside OpenRouter, 📬 Auto-send enriched leads to Gmail, Slack, or your CRM, 🗣️ Connect this to Telegram for on-the-go company generation, 🔁 Want dynamic lead scoring or auto-categorization? We can help — [email protected] Final notes This template was designed by Velebit from Innovatio. External links (e.g. documentation or support email) lead only to official sources with no affiliate tracking or paid placements. A separate license applies to the paid version on Gumroad, which includes commercial use rights, extended fallback logic, and advanced upgrade tips.

Who Is This For? This workflow is designed for marketers, content creators, agencies, and solo founders who want to publish long‑form posts with visuals on autopilot using n8n and AI agents. ​ Whether you run a blog, SaaS, personal brand, newsletter, or client accounts, this tool helps you keep a consistent content pipeline without manually writing every article, creating images, and posting to each platform one by one. ​ ​ 💪🏼 While the template is wired around classic blog + social media distribution, the underlying logic is universal. You can easily adapt it to any niche by editing prompts, swapping models, and re‑wiring nodes. You can plug in any LLM you like, from ChatGPT to Claude, Gemini, Mistral, DeepSeek, OpenRouter, or even local models through Ollama. ​ What Problem Is This Workflow Solving? 🤯 Most teams waste hours on the same repetitive loop: research a topic, gather links, write a blog post, craft social captions, generate visuals, upload everything to multiple platforms, and archive assets. ​ ​ 💎 This workflow solves that by automating the full content chain—from research and blog‑post generation to image creation, publishing across channels, and logging everything in your content database—so your feeds stay active while you focus on strategy, not busywork. ​ What This Workflow Does ✨ Generates in‑depth blog posts tailored to your topic and target audience, enriched with fresh references from the web via Tavily/SerpAPI search tools. ​ ✨ Creates an image prompt and title from the article, generates the visual with OpenAI Images (gpt-image-1), and converts it into a ready‑to‑use image file. ​ ✨ Automatically publishes content to your connected platforms (WordPress for blog posts, Telegram, X/Twitter, Facebook, LinkedIn) while saving images to Google Drive and logging each publication in Google Sheets for tracking. ​ How It Works? Surprisingly simple ☺️ The workflow is triggered by another n8n workflow or by one of several triggers (Facebook, RSS, Google Sheets, Airtable, Postgres) that pass in the blogTopic, targetAudience, and Telegram chatID. ​ ​ The Blog Post Agent (LLM with access to Tavily/SerpAPI) researches the topic, writes a structured article for the specified audience, and sends its output to the Image Prompt Agent, which turns the content into a visual prompt and title. ​ 🎯 The end result: you provide a topic, run the workflow, and receive a complete blog post, matching image, and ready‑made social posts shipped directly to your channels and archives—no manual copy‑paste. ​ How to Customize This Workflow to Your Needs 🎨 Switch AI models and fine‑tune prompts so the agent can handle your exact formats: tutorials, case studies, listicles, product updates, thought‑leadership pieces, or campaign landing posts. 🔍 Refine research sources inside Tavily/SerpAPI to prioritize the domains, blogs, and docs your audience trusts, keeping posts accurate and up to date. ⏰ Adjust posting cadence and schedules to align with peak engagement for your audience, mixing automated slots with manual “launch” runs for special announcements. 📱 Expand or trim channels as needed: keep just WordPress + LinkedIn, add Telegram as a content feed, or plug the workflow into additional automations like email campaigns or RSS feeds. 📊 Use Google Sheets as your content hub to store ideas, angles, CTAs, references, and performance notes so you can double‑down on topics and formats that perform best. 🎬 Swap images for video by replacing the image generation node with video tools (for example, Runway‑style APIs) if your strategy is video‑first while keeping the same prompt pipeline. 💾 Build a reusable prompt library in Sheets, Notion, or Airtable so you can rotate proven prompt patterns each month and keep quality high without reinventing the wheel. 🤖 The system will continuously generate blog posts, visuals, and social updates and publish them across your selected platforms while archiving everything in Drive and Sheets—keeping your brand visible, consistent, and professional with minimal ongoing effort.

Multi-Platform AI Sales Agent with RAG, CRM Logging & Appointment Booking This workflow acts as a 24/7 sales agent, engaging leads across WhatsApp, Instagram, Facebook, Telegram, and your website. It intelligently transcribes audio messages, answers questions using a knowledge base, and uses modular sub-workflows to manage your CRM in Airtable and book appointments in Google Calendar. Who Is It For? This solution is designed for service-based businesses that require a sophisticated, multi-channel lead management and appointment booking system. Agencies, consultants, and clinics** looking to automate lead qualification and booking across text and voice messages. Sales teams** needing a robust system that separates CRM and calendar logic for easier management and scalability. Advanced n8n users** who want a powerful, agent-based framework that can be easily customized and extended. Key Features & Workflow This system is composed of a parent workflow that orchestrates the conversation and calls specialized sub-workflows (agents) to perform specific tasks. Omni-Channel Engagement:* Greets and converses with leads naturally on Website Chat, WhatsApp, Instagram, Facebook, and Telegram*. Voice Message Transcription:* Automatically transcribes incoming audio/voice notes from WhatsApp and Telegram* into text, allowing the AI to understand and respond without manual intervention. RAG-Powered Intelligence:* The AI agent draws answers from your dedicated PostgreSQL Knowledge Base (RAG)*, providing accurate information about your services, pricing, and process. A built-in tool allows you to load new knowledge documents from Google Drive. Modular CRM Agent (Sub-Workflow):* When the conversation requires CRM actions (like creating a contact or updating an opportunity), the main agent calls a dedicated Airtable CRM sub-workflow* to handle the task. Modular Calendar Agent (Sub-Workflow):* To book appointments, the main agent calls a separate Google Calendar sub-workflow*, which manages event creation, updates, and deletions. What You'll Need This workflow framework requires credentials for the following services: An AI provider (OpenAI is used for the main agent, transcription, and embeddings). PostgreSQL** database with the pgvector extension (for RAG and chat memory). Airtable** account (for the CRM sub-workflow). Google Calendar** account (for the Calendar sub-workflow). Telegram Bot** credentials. A Meta Developer Account (for WhatsApp, Instagram & Facebook). (Optional) Google Drive for loading knowledge documents. (Optional) Google Gemini for embeddings. How to Set It Up This is a modular system. You must set up the sub-workflows first. Deploy Sub-Workflows: Create two new, separate workflows using the provided templates for the CRM Agent and the Calendar Agent. Configure the credentials (Airtable, Google Calendar) within those workflows, then save and activate them. Link Sub-Workflows in Main Workflow: Return to this main workflow. In the "CRM Agent" and "Consultation Agent" tool nodes, select the new workflows you just created from the dropdown list. Configure Main Credentials: Securely add the remaining credentials (OpenAI, PostgreSQL, Telegram, and your Meta App) in this main workflow. Personalize the AI Agent: In the "Update Agent Details" node, fill in your business name, the agent's persona name, and your key services to customize the AI's personality. Load Your Knowledge (Optional): To populate the RAG database, use the manual trigger path starting with "When clicking ‘Execute workflow’" to download a document from Google Drive and insert it into your PostgreSQL vector store. Activate: Configure your channel-specific details (e.g., Phone Number ID in WhatsApp nodes), save the workflow, and activate it. Demo CRM Table: View on Airtable

Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control. Demo & Explanation How it works User permissions are managed in Airtable where every restricted AI tool is listed by name and connected via roles to users Requests to the Main Agent can be sent through a Telegram message (can be replaced by Whatsapp, IMAP or similar) On every request the Telegram username is used to query a list of all allowed tools which are linked in Airtable A LangChain Code node is used to compare that list against the connected tools Every tool which is not permitted to be used is being replaced by a tool, which has a status response, telling the Agent to return a message to the user, that he is not authorized to use the tool Otherwise allowed tools are passed through to the Agent, as if they were connected directly to the Agent The parameters can also be passed to a sub-agent called as a sub-workflow where permissions can be checked the same way Every response is sent back to the same Telegram conversation Setup Clone the workflow and select the belonging credentials. You'll need an OpenAI and Airtable Account as well as a Telegram Bot (refer to the docs for the Telegram credentials). Copy this Airtable Template into your workspace Follow the instructions given in the yellow sticky notes Activate the workflow How to use Try this example: Create a new line in Airtable under “Users” containing your Telegram username and your full name Set the roles “basic” and “info” Consider temporarily disconnecting or resetting the chat memories so they do not remember previous confirmations Start a new chat, asking about your permitted roles - you should get a list of those Ask about the current weather in your city - you should be informed, that you do not have permission to access that information Back in Airtable add the role “weather” to your user Now ask the Agent the same question again - It should give you a proper answer this time From here on you can add tools and create roles to your likings. Disclaimer Please note, that this workflow can only run on self-hosted n8n instances, since it requires the LangChain Code Node.

🧠 Problem This Solves Manually sharing Medium articles to LinkedIn daily can be repetitive and time-consuming. This automation: Fetches the latest Medium articles based on a tag (e.g., android) Posts them on LinkedIn twice daily Uses Airtable to prevent duplicates Sends a confirmation to Telegram once posted Stay consistently active on LinkedIn without lifting a finger. 👥 Who This Template Is For Developers who write or follow Medium content Tech creators or founders looking to grow an audience Community or page managers needing regular curated posts Busy professionals who want hands-free LinkedIn engagement ⚙️ Workflow Breakdown This automation runs at 9:00 AM and 7:00 PM daily and performs these steps: Fetch articles from MediumAPI.com by tag Check Airtable to prevent reposting the same article Post on LinkedIn if it’s new Store the article ID in Airtable Send a Telegram message after successful posting 🧾 Step-by-Step Setup Instructions ✅ 1. Airtable Configuration Create a base with: Table Name: PostedArticles Column: ArticleID (Single line text – to track posted articles) 🔗 2. MediumAPI Setup Go to https://mediumapi.com Sign up and generate your API key from the dashboard Use this API endpoint in an HTTP node: GET https://mediumapi.com/api/tag/YOUR_TAG/latest Headers: Authorization: Bearer YOUR_API_KEY Replace YOUR_TAG with a topic like android, ai, webdev, etc. 💬 3. Telegram Bot Setup Go to @BotFather and create a new bot Save the bot token Use @userinfobot to get your Telegram chat ID Add a Telegram node in n8n with the token + chat ID 🔗 4. LinkedIn Setup Create a LinkedIn Developer App Connect it via OAuth2 in n8n Choose to post on your profile or company page 🧱 5. n8n Workflow Structure Node Type Description Cron Triggers the flow twice a day HTTP Request Fetches articles from MediumAPI.com Airtable Search Checks if article ID already exists IF Node Skips duplicates LinkedIn Post Publishes to your LinkedIn profile/page Airtable Create Stores posted article ID Telegram Node Sends success notification 🛠️ Customization Tips Change the tag in the API URL to match your niche Add hashtags or personal comments to the LinkedIn message Schedule different posting times in the Cron node Filter Medium posts based on length or title keywords (optional)

🚀 Remote Job Automation Workflow Automatically fetch, clean, and broadcast the latest remote job listings — powered by RemoteOK, Airtable, and Telegram. 🔧 Key Features Seamless Data Fetching: Pulls the latest job listings from the RemoteOK API using an HTTP Request node. Smart Data Processing (via Code Node): Filters out irrelevant metadata Cleans and sanitizes job descriptions (e.g., HTML tags, special characters) Handles malformed or encoded text gracefully Extracts and formats salary ranges for clarity Airtable Integration (Upsert): Stores each job as a unique record using job ID Avoids duplication through conditional upserts using Airtable's Personal Access Token Telegram Bot Broadcasting: Automatically formats and sends job posts to a Telegram group or channel Keeps your community or team updated in real-time 📦 Tech Stack RemoteOK API – source of curated remote job listings Airtable – lightweight, accessible job database Telegram Bot API – for real-time job notifications n8n – workflow automation engine to tie everything together 🔁 Workflow Overview Fetch Jobs from RemoteOK API Clean & Normalize job descriptions and metadata Extract Salary ranges and standardize them Upsert to Airtable (avoiding duplicates) Format Post for visual clarity Send to Telegram via bot integration 🧠 Perfect For Remote job boards or aggregators Recruitment agencies/startups Developers building personal job feeds Communities or channels sharing curated remote opportunities Automating newsletters or job digests ✅ Benefits Near real-time updates Minimal maintenance Full control and extensibility with n8n

Fully Automated AI Email System for n8n: Triage, Summarize & Alert—Never Check Your Inbox Again! Fully Automated Email Intelligence: Triage, Summarize, Escalate & Alert—Never Check Your Inbox Again 🚀 Overview Turn every minute you waste in your inbox into revenue‑generating focus time. This is more than a workflow—it’s a profit engine disguised as an email assistant. ⚙️ Eliminate 90 % of inbox noise with AI triage and smart labeling. 🚨 Instantly surface high‑value leads & crises via Telegram push alerts—before they cost you. 📰 Digest newsletters in 60 seconds with bite‑size AI briefs that keep you ahead of the curve. 🤖 Hand off replies, snoozes, and archiving to a tireless autonomous agent that never slips. Set‑up takes 10 minutes. The payoff starts within the first hour—hours reclaimed, opportunities captured, and the calm certainty your inbox is handled perfectly, 24/7. 🎯 Who's It For? Startup Founders & CEOs – Stop wasting hours on inbox cleanup. Automatically surface leads, triage support, and escalate ops issues while you focus on growth. Agencies & Consultants – Instantly prioritize high-value client messages, flag urgent ops threads, and never drop the ball on critical communication. Busy Professionals & Teams – Reclaim 5–10 hours weekly by letting AI handle noise, flag what matters, and summarize newsletters into actionable insights. No-Code Builders & AI Engineers – Plug in, customize, and ship production-ready inbox automation in minutes—no training required. Remote Operators & Virtual Assistants – Delegate inbox management confidently with a system that flags what’s important and handles the rest. 📌 High‑Impact Results What You’re Dealing With → What This System Solves Instantly Inbox Clutter & Constant Noise → 90% Noise Reduction Trivial, low-value messages are automatically triaged and labeled—only high-value threads stay in your spotlight. Missing Critical Emails → Real-Time Telegram Alerts Get instantly notified the moment a client, lead, or ops-critical email lands. Zero lag. Zero drop. Manual Reply Fatigue → AI-Generated Drafts in Seconds Fully contextual, brand-aligned replies ready at a click—cut response time from minutes to seconds. Newsletter Overload → Actionable 60-Second Summaries Dense newsletters converted into digestible, decision-ready highlights. Save hours while staying sharp. Information Chaos → Fully Structured Inbox Intelligence From raw email to labeled insights to escalated alerts—your inbox becomes an automated decision support system. This system doesn’t just "help"—it replaces hours of work per week, prevents costly misses, and ensures you never drown in emails again. ⚙️ Powerful Features 📥 AI Email Triage – Classifies and sorts emails using GPT/Gemini, labeling by intent and urgency. 📰 Newsletter Summarizer – Extracts concise, actionable insights from newsletters into structured summaries. 🚨 Real-Time Priority Alerts – Instantly escalates mission-critical emails via Telegram. 🤖 Autonomous Inbox Agent – Proactively manages email actions: replies, drafts, archives, and thread labeling. 🧠 Persistent Context Memory – Remembers senders, conversation history, and adjusts responses accordingly. 🏅 Why Choose This Solution? Fully Self-Hosted & Secure – Keep full control of your data and privacy. No external storage, no SaaS lock-in—just your infrastructure, your rules. Production-Grade Reliability – Built by a Lead Software Engineer. Tested, trusted, and optimized for uptime by myself. AI-Native Workflow Engine – Smart, adaptive, and deeply embedded in your processes. Automates with context, learns with use, and gets smarter over time. 💰 Pricing Limited Time Launch Price: $29 (One-time payment) 🎯 Lifetime access—pay once, save time forever. ⏱️ Designed to reclaim 5–10 hours per week per inbox. 🚨 One missed priority email could cost more—this system prevents that. ⚡ Launch offer pricing will increase SOON!—lock in early. 📦 What's Included? ✅ Fully documented and annotated n8n workflow (ready-to-import JSON) 📂 Gmail labeling system (production-ready taxonomy) 📲 Telegram integration and alert configuration 🛠 Customizable AI prompt templates for Gemini/GPT 🧠 Custom prompt templates for GPT & Gemini ⚙️ Autonomous email categorization & filtering 📰 Newsletter summarizer with structured JSON output 🤖 Optional AI agent for full inbox management tasks 🚀 Quick Start Setup Import the full workflow into your self-hosted n8n environment. Connect your Gmail, Telegram, and preferred LLMs (OpenAI or Gemini). Deploy Gmail labels using the included taxonomy—ensures proper triage and filtering. Trigger test alerts from real email data to verify AI classification and Telegram escalation. Go live—start receiving summarized insights, escalations, and triaged inbox updates within minutes. ❓ FAQ Q: What kind of ROI can I expect? A: On average, users reclaim 5–10 hours per week per inbox by eliminating low-priority noise, surfacing urgent emails instantly, and automating replies and summaries. For a business leader or agency, that’s hundreds of dollars in time savings weekly—and zero dropped balls. Q: Can it scale for my team? A: Absolutely. It’s architected with modular nodes and reusable components so you can rapidly duplicate, extend, or adapt it across teams, departments, and workflows. Whether you’re a solo founder or managing 20+ inboxes, this system grows with you—without code rewrites. Q: Is my data secure? A: Absolutely!. This system runs entirely in your self-hosted n8n environment, so your data never leaves your control. External LLMs (like OpenAI or Gemini) are only used when needed and receive minimal, context-limited input. You control all API keys and endpoints. No data is stored externally unless you configure it. Made with ❤️ by Bluegrass Digital Advantage

🧠 Problem This Solves: For developers and creators, consistently posting quality content on LinkedIn can be time-consuming. This workflow automates the process by: Fetching the latest Dev.to articles Posting them to LinkedIn twice daily Preventing duplicates using Airtable Sending success alerts to Telegram This ensures you're always active on LinkedIn, with zero manual effort. 👥 Who This Template Is For Developers who want to build their presence on LinkedIn Tech creators or solo founders looking to grow an audience Community/page managers who want regular, curated content Busy professionals aiming for consistent LinkedIn engagement without doing it manually ⚙️ Workflow Breakdown This automation runs twice a day (9:00 AM and 7:00 PM) and performs the following steps: Fetches Dev.to articles based on a tag Checks Airtable to avoid reposting the same article Posts to LinkedIn if it’s new Sends a Telegram message after posting successfully 🧩 Step-by-Step Setup Instructions ✅ 1. Airtable Configuration Create a new base in Airtable with just one table and one column: Table Name: PostedArticles Column: ArticleID (Single line text – stores the unique ID of each Dev.to article posted) This column is used to track posted articles and prevent duplicates. 🔗 2. Dev.to API Setup Use the following endpoint in the HTTP Request node: arduino Copy Edit https://dev.to/api/articles?tag=YOUR_TAG_HERE&per_page=10 Replace YOUR_TAG_HERE with a tag like android, webdev, ai, etc. 💬 3. Telegram Bot Setup Open @BotFather in Telegram and create a new bot Save the bot token Get your chat ID using @userinfobot or via Telegram API Add a Telegram node in n8n using this token and chat ID This will notify you when a post is successfully published. 🧾 4. LinkedIn Setup Create a LinkedIn Developer App Use OAuth2 to connect it in n8n Choose to post on either a user profile or a company page 🧱 5. n8n Workflow Structure Here’s the basic structure of the workflow: Cron Node – Triggers at 9:00 AM and 7:00 PM daily HTTP Request – Fetches latest articles from Dev.to Airtable Search – Checks if ArticleID already exists IF Node – Filters new vs. already-posted articles LinkedIn Post – Publishes new article Airtable Create – Saves the new ArticleID Telegram Message – Sends success confirmation 🛠️ Customization Tips Change the Dev.to tag in the API URL Modify LinkedIn post format (add hashtags, emojis, personal notes) Adjust posting times in the Cron node Use additional filters (e.g., only post articles with a cover image or certain word count)

Who is this for? This template is perfect for Gumroad creators, solopreneurs, digital product sellers, and freelancers who want to track and thank customers automatically — without spending time on manual work. What problem does this solve? Every sale is a moment to build trust. But manually checking your inbox for new orders, logging clients, and remembering to send a thank-you note? It’s time-consuming and inconsistent. This workflow handles it all: From sale → to sheet → to ping → to personalized “thank you” — all fully automated. What this workflow does: ✅ Triggers on each new sale on Gumroad 📋 Extracts buyer details, amount paid, and product purchased 📈 Logs the sale to a Google Sheet for tracking 📲 Sends a Telegram approval message to notify you 💌 (Optional) Sends a Gmail thank-you email to the buyer 🔁 Keeps your workflow organized with color-coded notes and sample data ⚙️ Setup Instructions: Create Gumroad API and connect the trigger node Authenticate with Google Sheets to store each client Connect your Telegram bot for real-time alerts (Optional) Setup Gmail API for sending thank-you emails Customize the email copy & sheet headers (e.g. % cut, timestamps) 🗒 Color-coded workflow notes: To make customization smooth, the workflow includes a color-coded sticky note system: 🟩 Green Notes – Main building blocks (trigger, logging, ping, email) 🟦 Blue Notes – Setup guidance and editable fields (e.g. your email or brand name) 🟨 Yellow Notes – Optional upgrades (e.g. swap Gmail, use AI email generator, change to WhatsApp) Each step has comments or hints to make your setup easy — whether you're new to n8n or a seasoned automator. 🔧 How to customize this workflow? 🎯 Swap Gmail with Outlook, SMTP, or Mailgun 🤖 Use AI (e.g. OpenAI or Claude) to draft personalized emails dynamically 📞 Replace Telegram with WhatsApp, Discord, or Slack 🗃️ Log to Airtable or Notion instead of Google Sheets 🧠 Add approval logic or advanced tagging in Gmail 🧾 Licensing & Support This template is built by Velebit from Innovatio. External links (Gumroad store or support email) are included in the notes for optional help and upgrades. A separate license applies to the paid version on Gumroad, which includes additional modules and commercial use rights. 📩 Support & customization: [email protected]

📚 MOTION TUTOR - AI-Powered Language Learning System Unlock the Power of Language with Personalized AI Learning! MOTION TUTOR is a revolutionary AI-powered language learning platform that adapts to your progress and guides you from basic vocabulary to complex sentence structures. Whether you're a beginner or looking to refine your skills, MOTION TUTOR provides an engaging and structured learning experience. 🎯 Key Features: ✅ AI-Powered Lessons: Receive interactive, real-life conversation-based lessons generated by cutting-edge AI. MOTION TUTOR dynamically adapts content to match your learning pace. ✅ Personalized Progress Tracking: Track your growth effortlessly! The system connects with Airtable to monitor your vocabulary, grammar, and situational language skills, ensuring lessons align with your goals. ✅ Memory Retention for Contextual Learning: With built-in memory capabilities, MOTION TUTOR remembers where you left off and keeps the conversation flowing. No need to repeat or restart — pick up right where you left off! ✅ Real-Time Telegram Integration: Learn on the go! Engage with MOTION TUTOR directly through Telegram and receive instant feedback and lesson suggestions based on your performance. ✅ Structured Learning Path: From mastering essential vocabulary to crafting complex sentences, MOTION TUTOR guides you step-by-step with a well-defined roadmap. Basic Vocabulary & Phrases Basic Grammar Structures Situational Vocabulary Intermediate Grammar Concepts Advanced Vocabulary Complex Sentence Structures ✅ Customized Role-Playing & Practice Scenarios: Practice vocabulary and grammar in context by engaging in situational conversations that simulate real-life interactions. 💡 How It Works: Message on Telegram: Send a message to initiate your learning session. AI Processes Input: MOTION TUTOR analyzes your request and customizes the next lesson. Context Retention: Continuation from previous sessions to ensure seamless learning. Track Progress: Updates and tracks progress in Airtable for personalized learning insights. Receive Feedback: AI-generated lessons and tips sent directly through Telegram. 📡 Why Choose MOTION TUTOR? 🎉 Engaging & Interactive Learning: Learn in a fun and practical way with interactive scenarios. 🚀 AI Adaptation for All Levels: Whether you're learning from scratch or advancing your fluency, MOTION TUTOR customizes content to suit your journey. 📝 Progress You Can Measure: Track your achievements and growth with structured Airtable data. 🔁 Never Lose Track: Memory-powered learning ensures you continue smoothly where you last paused. 🎁 Ideal For: Language learners seeking a personalized, guided learning experience. Professionals preparing for international business communication. Travelers aiming to learn practical vocabulary before their next adventure. Students looking to enhance their grammar and conversation skills. 🚀 Get Started Today! Embrace the future of language learning with MOTION TUTOR and gain the confidence to engage in everyday conversations and complex dialogues effortlessly. Ready to Speak with Confidence? 💬 Connect with MOTION TUTOR on Telegram and Start Learning Today!

Accelerate your real estate marketing by moving from "photo capture" to "published listing" in seconds. This workflow automates the entire listing process by hosting property photos via UploadToURL, using GPT-4o Vision to write professional MLS descriptions, and parallel-publishing the results to WordPress and Airtable. 🎯 What This Workflow Does Turns on-site property photos into fully-enriched digital listings: 📝 Captures Property Media - Receives a photo (binary or URL) and basic address metadata via Webhook. ☁️ Instant CDN Hosting - UploadToURL converts the photo into a permanent, high-speed CDN link for your website. 👁️ Intelligent Property Analysis - GPT-4o Vision analyzes the image to detect room type, condition scores (1–10), professional feature tags, and lighting quality. ✍️ Automated Copywriting - Generates a 2-3 sentence, MLS-compliant description using professional real estate terminology. ⚡ Parallel Publishing - Simultaneously creates a draft post in WordPress (using Gutenberg blocks) and a new record in your Airtable MLS database. 📲 Instant Agent Confirmation - Sends a Telegram message to the agent with live links to the WordPress draft and Airtable record for immediate review. ✨ Key Features UploadToURL Integration**: Native community node hosting ensures your property photos are web-ready instantly without manual resizing or cloud storage management. Vision-Powered Insights**: AI automatically detects "premium finishes" or "renovation age," providing pricing signals without manual entry. Parallel Execution**: Uses a split-branch logic to publish to multiple platforms at once, significantly reducing total execution time. Unified Response**: A Merge node assembles the final IDs and URLs from all platforms into a single, clean JSON response. Audit-Ready MLS**: Every Airtable record is timestamped and includes the original high-res CDN link for external syndication. 💼 Perfect For Real Estate Agencies**: Managing high-volume listings across multiple agents and neighborhoods. Property Managers**: Quickly documenting unit conditions and updates for internal tracking. Independent Realtors**: Automating their personal website and CRM directly from their smartphone while on-site. Property Photographers**: Delivering "ready-to-publish" assets to clients with AI-generated metadata already attached. 🔧 What You'll Need Required Integrations UploadToURL** - To host property photos and provide CDN links. n8n Community Node** - n8n-nodes-uploadtourl must be installed. OpenAI API** - GPT-4o Vision for professional image analysis and copywriting. WordPress** - Basic Auth or Application Password to create draft posts. Airtable** - Personal Access Token to manage your MLS database. Optional Integrations Telegram** - To receive real-time notifications with links to your new listings. 🚀 Quick Start Import Template - Copy the JSON and import it into your n8n canvas. Install Node - Ensure the UploadToURL community node is installed. Set Credentials - Link your UploadToURL, OpenAI, WordPress, Airtable, and Telegram accounts. Define Variables - Update n8n variables: WP_BASE_URL, AIRTABLE_BASE_ID, and TELEGRAM_CHAT_ID. Prepare Airtable - Ensure your table has columns for Listing ID, Address, Price, and MLS Description. Deploy - Activate the workflow and start publishing properties instantly from the field. 🎨 Customization Options Watermarking**: Insert a node to add your agency logo to photos before they are uploaded to the CDN. Zillow/MLS Sync**: Add a branch to push the AI-generated data to external listing services via API. Virtual Staging**: Route photos through an AI staging service before hosting them on UploadToURL. Price Formatting**: Update the code node to support different currencies or regional price display formats. 📈 Expected Results Save 20-30 minutes per listing** by eliminating manual uploading, writing, and platform syncing. Improved SEO**: Every property photo includes AI-generated Alt-Text and descriptive filenames. Better Accuracy**: AI consistently captures features (like "crown molding" or "natural light") that agents might miss in a rush. Zero Friction**: Agents can go from taking a photo to having a draft live on the website before they leave the property. 🏆 Use Cases Rapid Market Entry A team of agents can document an entire apartment complex in one afternoon, with every room automatically categorized and described in WordPress by the time they get back to the office. Internal Quality Audits Property managers use the condition score (1–10) generated by the AI to prioritize maintenance and renovations across a portfolio. Social Media Teasers The AI-generated "Marketing Blurb" can be used to instantly trigger a second workflow that posts a property "sneak peek" to Instagram or LinkedIn. 💡 Pro Tips Structured Filenames**: The workflow automatically renames files to {listingId}_{address}.jpg for better organization and SEO. Draft Status**: Listings are created as "Drafts" in WordPress by default, allowing for a quick "Human-in-the-loop" review before going live. Lighting Analysis**: Use the AI-detected "Lighting Quality" field to identify photos that might need professional retouching. Ready to automate your real estate pipeline? Import this template and connect UploadToURL to start publishing professional listings faster. Questions about the Airtable schema? The workflow includes detailed sticky notes explaining the exact field types required for the MLS record sync.

Community Contest Tracker (FB Comments) → Sentiment Analysis → Telegram Winner Alerts + Airtable Proof This workflow automatically monitors a Facebook post, extracts comments, enforces a "past winner" blocklist, analyzes sentiment using AI to find positive entries, randomly selects a winner, stores them in Airtable and announces the result via Telegram. This workflow runs every night to manage your daily community giveaways. It fetches fresh comments from a specific Facebook post and cross-references users against a list of previous winners stored in Airtable to ensure fairness. It uses OpenAI to filter for genuinely positive sentiment (removing spam), selects a random winner, saves the record and sends a celebratory announcement to your Telegram channel. You receive: Daily automated comment collection** Fairness enforcement (Blocklist for past winners)** AI-powered sentiment filtering (Positive vibes only)** Automated winner selection & notification** Ideal for community managers and brand owners who want to run fair, high-engagement contests without manually reading hundreds of comments or tracking past winners in spreadsheets. Quick Start – Implementation Steps Add your Facebook Graph API Credentials in the HTTP Request node. Connect and configure your Airtable base (Winners Table). Add your OpenAI API Key for sentiment analysis. Connect your Telegram Bot credentials and set the Chat ID. Update the Post ID in the "Get FB Comments" node. Activate the workflow — daily contest automation begins instantly. What It Does This workflow automates the entire lifecycle of a social media contest: Daily Trigger: Runs automatically at 9:00 PM every day. Data Ingestion: Fetches the latest comments from Facebook and the full list of past winners from Airtable simultaneously. Pre-Processing: Creates a blocklist of users who won in the last 30 days. Filters out spam, short comments (e.g., single emojis) and blocklisted users. AI Analysis: Uses GPT-4o-mini to analyze the text of eligible comments. Filters specifically for "Positive" sentiment. Selection: Randomly picks one winner from the pool of positive comments. Storage: Saves the winner's Name, Facebook ID and Comment to Airtable. Notification: Sends a "Winner Announcement" to your public Telegram channel. If any errors occur (e.g., DB save fail), logs them to Supabase and alerts the Admin. This ensures your contests are fair, spam-free and consistently managed with zero manual effort. Who’s It For This workflow is ideal for: Social Media Managers Community Moderators Digital Marketing Agencies Brand Owners running daily giveaways Influencers managing high-volume comment sections Customer Experience teams rewarding positive feedback To run this workflow, you will need n8n instance** (cloud or self-hosted) Facebook Developer App** (Graph API Access Token) Airtable Base** + Personal Access Token OpenAI API Key** (or compatible LLM) Telegram Bot Token** Supabase Project** (Optional, for error logging) How It Works Daily Trigger – The schedule node initiates the process. Fetch Data – Comments are pulled from FB; Winners pulled from Airtable. Code Filter – JavaScript node removes past winners and low-quality spam. Sentiment Analysis – AI determines if the comment is Positive, Neutral or Negative. Pick Winner – A randomized logic block selects one "Positive" user. Record Keeping – The winner is officially logged in your database. Broadcast – The winner is announced to the community via Telegram. Setup Steps Import the provided n8n JSON file. Open Get FB Comments node → Add credentials and paste your specific Post ID. Open Get Past Winners node → Link to your Airtable "Winners" table. Open OpenAI Chat Model node → Add your API Key. Open Create a record (Airtable) → Map the fields: Name Facebook ID Date Open Send a text message (Telegram) → Add your Chat ID (e.g., @mychannel). Activate the workflow — done! How To Customize Nodes Customize Filtering Logic Modify the Pre-Filter (Blocklist) Code node: Change the minimum character length (default is 2). Adjust the "Blocklist" duration (e.g., allow users to win again after 7 days instead of 30). Customize AI Criteria Modify the Sentiment Analysis or OpenAI prompt: Look for "Creative" or "Humorous" comments instead of just "Positive". Filter for specific keywords related to your brand. Customize Notifications Replace Telegram with: Slack** (for internal team updates). Discord** (for gaming communities). Email** (SMTP/Gmail) to notify the marketing team. Customize Storage Replace Airtable with: Google Sheets Notion PostgreSQL / MySQL Add-Ons (Optional Enhancements) You can extend this workflow to: Auto-Reply:** Use the Facebook API to reply to the winner's comment automatically ("Congrats! DM us to claim."). Image Generation:** Use OpenAI DALL-E or Bannerbear to generate a "Winner Certificate" image. Cross-Posting:** Automatically post the winner's name to Twitter/X or LinkedIn. Sentiment Report:** Create a weekly summary of overall community sentiment (Positive vs Negative ratio). Prize Tiering:** Assign different prizes based on the quality of the comment. Use Case Examples Daily Product Giveaways Reward one user every day who comments why they love your product. Feedback Drives Encourage users to leave constructive feedback and reward the most helpful positive comment. Community Engagement Keep your group active by automating "Best Comment of the Day" rewards. Brand Loyalty Programs Track "Super Fans" by counting how many times they participate (even if they don't win). Troubleshooting Guide | Issue | Possible Cause | Solution | | :--- | :--- | :--- | | No comments found | Invalid Post ID or Token | Check Facebook Graph API token and Post ID. | | No winner selected | No positive comments | AI found no "Positive" sentiment. Check prompt or input data. | | Airtable Error | Field Mismatch | Ensure column names in Airtable match exactly (Name, Facebook ID). | | Telegram Error | Bot Permissions | Ensure the Bot is an Admin in the channel. | | Workflow Stuck | API Rate Limit | Check OpenAI or Facebook API usage limits. | Need Help? If you need help customizing or extending this workflow, adding multi-platform support (Instagram/YouTube), integrating complex prize logic or setting up advanced dashboards, feel free to hire n8n automation developers at WeblineIndia. We are happy to assist you with advanced automation solutions.

This AI receptionist handles restaurant bookings and delivery orders with Vapi, Telegram, and Airtable Who’s it for This n8n template is built for restaurants that want to automate table bookings and delivery or takeaway orders using an AI receptionist. It’s suitable for small to mid-sized restaurants that receive bookings and orders via voice calls or Telegram and want a structured, reliable backend without manual handling. How it works The workflow powers an AI receptionist that operates through Vapi (voice) and Telegram (chat). For table bookings, it collects party size and preferred time, checks table availability within the requested time range, and returns available options or a “no availability” response. For orders, the menu is fetched from Airtable, items are validated, prices are calculated, and order details are collected. Delivery addresses are validated and checked against supported areas. If delivery is unavailable, the system automatically offers takeaway. All confirmed bookings and orders are saved to Airtable. How to set up Download JSON flows from the Dropbox folder, copy Airtable base with template tables to your account. Get Airtable, OpenAI, Telegram Bot, Google Maps API credentials. Set up credentials and test. How to customize the workflow You can plug a VAPI assistant. Copy the prompt from the AI agent and paste it into VAPI system prompt section. Also add MCP tool and call it restaurant tool. You can adjust booking rules, table capacity logic, menu structure, restaurant location, delivery zones, pricing calculations, and message wording to match your restaurant’s operations.

|Overview |Sample| |-|-| |This template is the first of its kind: it automatically generates both the caption and the image for your Instagram posts by analysing your existing feed, with zero spreadsheets or manual steps. Once configured, the workflow runs on a schedule, fetches your past posts, and uses a custom AI agent to craft a new caption and image prompt. Then creates the image via OpenRouter (Nano Banana) and stores everything in Airtable. A Telegram message gives you one‑tap control to confirm, regenerate or cancel; if confirmed, the post is published directly to Instagram. Perfect for creators and marketers who want fresh, on‑brand content without daily manual effort. | | Good to Know Fully hands‑off:** No need to prepare datasets or manually upload assets. The workflow reads your Instagram history via the Graph API and generate new content. AI‑powered creativity:** Uses OpenAI for caption generation and Nano Banana via OpenRouter for image synthesis. Privacy‑friendly:** Your content stays within your Airtable and n8n instance; only the AI models receive anonymised prompts. Nano Banana:** Currently the gemini-2.5-flash-image-preview model is used but you can use any available in Open Route. How It Works Scheduling: A schedule trigger initiates the workflow at your chosen time. Feed Analysis: The workflow uses your Instagram business account ID and access token to fetch past posts. AI Content Generation: A custom AI agent analyses your captions, applies category tag, and writes a new caption and a detailed image prompt. If there is no content it will be based on the category to create something new. Image Creation: The prompt is sent to the Nano Banana model on OpenRouter to generate a new image. The binary is converted to JPEG and stored in Airtable wih the caption and prompt. Approval via Telegram: A Telegram bot sends you the generated image, caption and three inline buttons: Confirm, Regenerate and Cancel. ✅ Confirm: Uploads the image to Instagram via a Graph API call. ♻️ Regenerate: Re‑runs just the AI ​​creation steps, generating a different title and image. ❌ Cancel: Updates the Telegram message to note the cancellation and removes the buttons. Publishing: When confirmed, the workflow uses the image’s public URL (generated in Airtable and served via an n8n webhook) to create and publish the post on Instagram. How to Use Prepare your accounts: Instagram Business Account connected to a Facebook Page (get your IG Business ID and a long‑lived Graph API access token). Airtable base and table with fields: id, img_prompt, caption, data_binary, action, mime_type, created_at. Personal access token for Airtable, Telegram bot token and chat ID, OpenAI and OpenRouter API keys. Create workflows: Four workflows are included: schedule trigger, webhook to serve the image, main content‑generation workflow and Telegram response workflow. Replace placeholders: Fill in your account IDs, token values, n8n instance URL and webhook paths. Define Category: Adjust the Define Category node to steer the content theme (e.g. natural landscapes, urban fashion). Activate and test: Activate the workflows "ebhook to serve the image and Telegram response workflow. Configure Schedule Trigger workflow to call the Main Content-Generation Workflow. Run the Main Content-Generation Workflow once to create a sample post and test the Telegram buttons. Activate the schedule for the generation of automatic posts. Requirements Instagram Business account & Facebook Graph API (tokens with instagram_basic and instagram_content_publish permissions) Airtable base & personal access token Telegram bot (token & chat ID) OpenAI API key OpenRouter API key Customization Caption tone:** Modify the AI Agent prompt to change tone (flirtatious, motivational, mysterious). Schedule:** Set your preferred posting time via the schedule trigger. Additional fields:** Expand the Airtable schema and 'Take Caption' node to include hashtags, analysis summaries or performance metrics.

This n8n workflow receives files sent in a Telegram chat, uploads them to Google Drive, extracts text using OCR (for images and PDFs), and stores the extracted content in Airtable for quick search and retrieval. Users can later search through documents using a Telegram /search command. Key Features Accepts images and documents from Telegram Uploads files to Google Drive automatically Detects file type and runs OCR if eligible Extracts text from images & PDFs via Google Vision Stores file metadata + text in Airtable Search documents using /search command in Telegram Sends result previews and file links Error handling & user notifications included Use Cases Personal document vault with search Team knowledge filing system Receipt & invoice OCR archive Legal documents store & retrieval Research papers & notes indexing Company file inbox for AI knowledge base Workflow Steps | Step | Action | Description | | ---- | --------------------- | ---------------------------------------------------------- | | 1 | Telegram Trigger | Detects incoming docs/images or /search command | | 2 | Filter File or Search | Routes based on whether message has file or search command | | 3 | Extract Metadata | Reads file info such as name, MIME type, user | | 4 | Download File | Downloads file via Telegram API | | 5 | Upload to Drive | Saves file in Google Drive | | 6 | OCR Check | Determines if file supports OCR | | 7 | Google OCR | Runs OCR for images/PDFs | | 8 | Extract Text | Pulls text output from OCR | | 9 | Merge OCR Text | Combines file data + text | | 10 | Save to Airtable | Indexes with metadata + text | | 11 | Success Reply | Sends link + success message | | 12 | /search Flow | Parse search query | | 13 | Airtable Search | Full-text search for records | | 14 | Send Results | Sends matches to Telegram | | 15 | Error Handler | Notifies user on failure | Input Formats File Messages Supported Images PDFs Documents Search Command /search keyword Example: /search invoice Output After Upload: ✅ File saved & indexed successfully! 🔗 Drive Link: <link> After Search: Returns structured result: File name Preview text snippet Google Drive link Data Stored in Airtable | Field | Description | | ------------- | ------------------------- | | File Name | Original name | | File Link | Google Drive link | | MIME Type | File type | | Telegram User | Sender info | | OCR Text | Extracted searchable text | | Uploaded Date | Timestamp | Technical Requirements Telegram Bot Token Google Drive API connection Google Vision API key Airtable API key & table Benefits Automatically organizes Telegram files Makes PDFs & images searchable Saves manual sorting and indexing time AI-ready data storage (future LLM integration) Fast search experience right in Telegram Enhancement Ideas Add Whisper for voice message transcription Add chat GPT summarization for large docs Build dashboard for uploaded files Auto-tag documents (invoice, ID, receipt etc.) Multi-language OCR support Status ✅ Ready for production ✅ Handles images, PDFs, and files ✅ End-to-end automation 🛠 Optional: add more AI enrichment later

AI Customer Support Triage with Gmail, OpenAI, Airtable & Slack How it Works This workflow monitors your Gmail support inbox every minute, automatically sending each unread email to OpenAI for intelligent analysis. The AI evaluates sentiment (Positive/Neutral/Negative/Critical), urgency level (Low/Medium/High/Critical), categorizes requests (Technical/Billing/Feature Request/Bug Report/General), extracts key issues, and generates professional response templates. The system calculates a priority score (0-110) by combining urgency and sentiment weights, then routes tickets accordingly. Critical issues trigger immediate Slack alerts with full context and 30-minute SLA reminders, while routine tickets post to standard monitoring channels. Every ticket logs to Airtable with complete analysis and thread tracking, then updates a Google Sheets dashboard for real-time analytics. A secondary AI pass generates strategic insights (trend identification, risk assessment, actionable recommendations) and stores them back in Airtable. The entire process takes seconds from email arrival to team notification, eliminating manual triage and ensuring critical issues get immediate attention. Who is this for? Customer support teams needing automated prioritization for high email volumes SaaS companies tracking support metrics and response times Startups with lean teams requiring intelligent ticket routing E-commerce businesses managing technical, billing, and return inquiries Support managers needing data-driven insights into customer pain points Setup Steps Setup time:** 20-30 minutes Requirements:** Gmail, OpenAI API key, Airtable account, Google Sheets, Slack workspace Monitor Support Emails: Connect Gmail via OAuth2, configure INBOX monitoring for unread emails AI Analysis Engine: Add OpenAI API key, system prompt pre-configured for support analysis Parse & Enrich Data: JavaScript code automatically calculates priority scores (no changes needed) Route by Urgency: Configure routing rules for critical vs routine tickets Slack Alerts: Create Slack app, get bot token and channel IDs, replace placeholders in nodes Airtable Database: Create base with "tblSupportTickets" table, add API key and Base ID (replace appXXXXXXXXXXXXXX) Google Sheets Dashboard: Create spreadsheet, enable Sheets API, add OAuth2 credentials, replace Sheet ID (1XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX) Generate Insights: Second OpenAI call analyzes patterns, stores insights in Airtable Test: Send test email, verify Slack alerts, check Airtable/Sheets data logging Customization Guidance Priority Scoring:** Adjust urgency weight (25) and sentiment weight (10) in Code node to match your SLA requirements Categories:** Modify AI system prompt to add industry-specific categories (e.g., healthcare: appointments, prescriptions) Routing Rules:** Add paths for High urgency, VIP customers, or specific categories Auto-Responses:** Insert Gmail send node after routine tickets for automatic acknowledgment emails Multi-Language:** Add Google Translate node for non-English support VIP Detection:** Query CRM APIs or match email domains to flag enterprise customers Team Assignment:** Route different categories to dedicated Slack channels by department Cost Optimization:** Use GPT-3.5 (~$0.001/email) instead of GPT-4, self-host n8n for unlimited executions Once configured, this workflow operates as your intelligent support triage layer—analyzing every email instantly, routing urgent issues to the right team, maintaining comprehensive analytics, and generating strategic insights to improve support operations. Built by Daniel Shashko Connect on LinkedIn

🔐 n8n Workflow: Role-Based Access Control (RBAC) for Telegram Automations This n8n workflow lets you control access to your internal Telegram bots and automation systems based on user roles and departments. It ensures that only authorized team members — defined in your employee database — can interact with specific parts of your workflow. Perfect for agencies, internal tools, or multi-team organizations where permissions differ across roles (e.g., Marketing, Sales, Administration). 📌 Section 1: Trigger & Input ⚡ Receive Message (Telegram Trigger) Purpose: Captures incoming messages from users interacting with your Telegram bot. How it works: When a user sends any message to the bot, the workflow retrieves their Telegram username and triggers the process. Benefit: Provides a secure and instant entry point for validating user identity before running any internal logic. 📌 Section 2: Role Lookup 📋 Employee Database (Data Table Node) Purpose: Fetches user details such as Position and Type from your internal employee table. Structure Example: UserName===Position===Type User_1===Marketing===SEO User_2===Administration===Manager User_3===Marketing===Target Benefit: Centralized employee management — you can update access levels (roles or departments) directly in the data table without editing the workflow. 📌 Section 3: Position & Role Check 🧩 Choose Position (Switch Node) Purpose: Determines the user’s department or role level (e.g., Marketing, Sales, Administration). 🧩 Check Role Type (Switch Node) Purpose: Performs a second-level check — filters users by Type (e.g., SEO, SMM, Target). Logic: Marketing → SEO → Send to SEO workflow branch Marketing → Target → Send to Ads branch Administration → Manager → Grant full access Sales → Employee → Limited access Benefit: Allows multi-level, role-based logic with different automation paths for each team or position. 📌 Section 4: Action Routing 💬 No Operation Nodes (Placeholders) Purpose: Represent different action branches — each can later be replaced with the logic specific to that department. Examples: “Target” branch → connect to ad performance automation “SEO” branch → connect to Google Search Console reports “Sales” branch → connect to CRM updates Benefit: A flexible access framework — ready to integrate with any process per department. 📊 Workflow Overview Table Section Node Name Purpose Trigger Telegram Trigger Captures user messages Lookup Employee Database Fetches user position and type Check Choose Position / Role Switch Defines access path based on role Routing No Operation Nodes Separate workflows per department 🎯 Key Benefits 🔐 Granular Access Control: Multi-level permission logic (Position + Role). ⚙️ Dynamic Role Management: Update access directly in your data table — no redeployment needed. 🧱 Modular Design: Add or replace department branches without affecting core logic. 🚀 Scalable Foundation: Perfect base for enterprise-grade permission systems or multi-team bots. 📈 Cross-Platform Ready: Can be adapted for Slack, Discord, or internal chat tools.

🔐 n8n Workflow: Access Control for Internal Chats or Chatbots This n8n workflow helps you restrict access to your internal chats or chatbots so that only authorized team members can interact with them. It's perfect for setups using Telegram, Slack, or other corporate messengers, where you need to prevent unauthorized users from triggering internal automations. 📌 Section 1: Trigger & Input ⚡ Receive Message (Telegram Trigger) Purpose: Captures every incoming message from a user interacting with your Telegram bot (or another messenger). How it works: When a user sends a message, it instantly triggers the workflow and passes their username or ID as input data. Benefit: Acts as the entry point for verifying whether a user is allowed to proceed. 📌 Section 2: Access Table Lookup 📋 User Access Table (Data Node / Spreadsheet / DB Query) Purpose: Stores all your team members and their current access status. Structure Example: | Username | Access Status | |----------|---------------| | user1 | granted | | user2 | denied | | user3 | granted | Benefit: Centralized access control — you can easily update user permissions without editing the workflow. 📌 Section 3: Permission Check 🧩 Check Access (IF Node) Purpose: Compares the incoming user's name or ID against the access table. Logic: If status = granted → Allow message to continue If status = denied → Stop workflow execution Benefit: Ensures only approved users can interact with your automations or receive responses. 📌 Section 4: Response Handling 💬 Send Reply (Telegram Node) Purpose: Sends a message back to the user depending on their access level. Paths: ✅ Granted: Sends the normal bot response or triggers the main process. ❌ Denied: Sends no reply (or an optional "Access denied" message). Benefit: Prevents unauthorized access while maintaining a seamless experience for approved users. 📊 Workflow Overview Table | Section | Node Name | Purpose | |---------|-----------|---------| | 1. Trigger | Receive Message | Captures incoming messages | | 2. Access Table | User Access Table | Stores usernames + permissions | | 3. Check | Check Access | Verifies if user has permission | | 4. Response | Send Reply | Sends or blocks response based on status | 🎯 Key Benefits 🔐 Secure access control: Only trusted users can trigger your internal automations. ⚙️ Dynamic management: Easily update user permissions from a table or database. 🧠 Lightweight setup: Just three nodes create a fully functional access gate. 🚀 Scalable foundation: Extend it with role-based access or activity logging later.

Telegram AI Assistant with Memory, Tasks, and Live Search (Airtable + Google Calendar) This workflow creates an intelligent Telegram-based AI assistant that remembers user details, manages lists, integrates with Google Calendar, and can fetch live information from the web. It is designed for everyday use and improves over time with your feedback. What It Does Personal Memory:** Saves user preferences and instructions in Airtable. Task & Grocery Lists:** Add, search, or delete grocery and to-do items directly in Telegram. Calendar Management:** Create, update, delete, and search events (single or recurring) with Google Calendar. Voice Support:** Send voice messages—these are transcribed and processed like text. Web Search:** (Optional) Fetch real-time answers using SerpAPI. Prerequisites n8n (Cloud or self-hosted instance). Telegram Bot (create via @BotFather on Telegram). Airtable account with a new Base containing 3 tables: User Memory Grocery's To Do List Google Account with Calendar enabled (for OAuth2). OpenAI API Key (for AI responses + voice transcription). SerpAPI Key (optional, for live web search). Airtable Schema Inside your new Airtable Base, create the following tables and fields: User Memory Memory (text) User (text) Time (created time) Grocery's Item (text) User (text) Created (created time) To Do List Task (text) Project or Class (text) User (text) Created (created time) > Field names must match exactly. Setup Instructions Import the workflow JSON into n8n. Configure credentials for each service in the workflow: Telegram API → Paste in your bot token. Airtable → Add your Airtable personal access token. After this, Airtable nodes will show dropdowns where you can select your Base and then your Tables (no need to paste IDs). Google Calendar → Connect your Google account. Once credentials are added, simply pick your Calendar from the dropdown (e.g., “primary” or any shared calendar). OpenAI → Add your API key for chat + voice transcription. SerpAPI → Add your API key (optional). For Telegram Trigger: Click “Listen for Test Event” and send a message to your bot to register the webhook. In group chats: disable privacy mode in @BotFather so the bot can see all messages. Activate the workflow and start chatting with your bot. How to Use Memory** “Remember my coffee order is oat milk latte.” “Keep replies shorter.” Grocery List** “Add eggs.” → “Added eggs.” “What’s on my grocery list?” → Lists all items “Remove bread.” → “Removed bread.” To-Do List** “Add finish report for work.” “What’s on my to-do list?” “Remove finish report.” Calendar** “Create event ‘Team sync’ tomorrow 3–4 pm.” “Make a recurring study session every Friday at 2 pm.” “Delete the dentist appointment at 4 pm.” Web Search** “Get news.” → Summarizes top 5–6 stories from the past 24 hours. Configuration Notes You don’t need to enter Airtable IDs or Calendar IDs manually — just use the dropdowns after credentials are set up. Airtable “User” field is filled automatically with the Telegram username. Voice messages are downloaded and transcribed by OpenAI before being processed as text. Security All API keys and tokens are stored securely in n8n Credentials. No hard-coded IDs, emails, or secrets in this template. Webhook IDs are not included; n8n generates them automatically on import. Troubleshooting Bot not responding?** Ensure the workflow is active, Telegram Trigger is listening, and bot privacy settings are configured for groups. Airtable errors?** Check that your base and tables exist, and that field names match exactly. Calendar issues?** Confirm the Google account has access to the selected calendar. Voice transcription failing?** Verify your OpenAI credentials and Telegram bot permissions. Why This Template Works for Everyone Uses dropdown selections for Airtable and Google Calendar (no IDs needed). Includes clear setup instructions. Credentials are handled securely through n8n. Flexible: works with groceries, tasks, memory, calendar, and optional live web search.

🧾 What this workflow does This automation turns a Telegram voice or text message into a high-quality LinkedIn post using OpenAI’s Whisper, Dumpling AI and GPT-4, and then repurposes that same message into a content idea with visual inspiration using Dumpling AI. All outputs are saved to Airtable for review, approval, and scheduling. 👤 Who is this for Founders or creators sharing ideas while walking or multitasking Content teams turning voice memos into carousel content Personal brands posting on LinkedIn with minimal manual work Virtual assistants or SMMs handling voice-driven content tasks ⚙️ How to set up ✅ Requirements You’ll need active accounts for: Telegram Bot (via n8n’s Telegram Trigger node) OpenAI (for Whisper and GPT-4) Dumpling AI (to search Google and create Image) Airtable (to log your posts) In Airtable, create a table with the following fields: Ideas (Single line text) Context (Long text) Image URL (URL) 🔧 Setup steps Set up your Telegram bot Use BotFather to create a bot and get your token Add the bot to a private group or channel Connect all credentials in n8n Telegram Trigger (Bot Token) OpenAI (for Whisper + GPT-4) Dumpling AI (HTTP Auth) Airtable (OAuth or Personal Token) Update node parameters In the Telegram Trigger node, specify your bot and listening chat In the HTTP node for Dumpling AI, add your API key via header In Airtable nodes, map to your base and table correctly Optional prompt customization In the GPT-4 node, you can update the prompt for tone, formatting, or CTA style Optional: Adjust the Dumpling AI prompt to suit your niche (e.g., health, tech, finance). 🧠 How it works The Telegram bot receives a voice message. Whisper transcribes the voice into clean text. GPT-4 formats the text into a polished LinkedIn post. Dumpling AI: Generates a short-form content idea from the transcript. Creates a branded image prompt and renders a matching image. The full set of outputs (text, idea, image) is saved to Airtable. You can now review and schedule the post manually or via another automation. 🛠️ Customization ideas Swap Telegram for WhatsApp or voice memos via Google Drive Add moderation or approval steps before saving to Airtable Send the LinkedIn post directly to Buffer or Hootsuite for auto-posting Generate post captions or hashtags using GPT-4 before publishing Extend the workflow to auto-create carousel slides from the content idea This workflow makes it easy to share your voice with your audience — literally. Whether you're walking, thinking out loud, or sending team updates, this automation turns your spoken ideas into professional content, ready to post or polish.

This workflow automates brand monitoring on X by analyzing both the text and the images in posts. It uses multi-modal AI to score brand relevance, filters out noise, logs important mentions in Airtable, and sends real-time alerts to a Telegram group for high-priority posts. What it does Traditional brand monitoring tools often miss the most authentic user content because they only track text. They can't "see" your logo in a photo or your product featured in a video without a direct keyword mention. This workflow acts as an AI agent that overcomes this blind spot. It finds mentions of your brand on X and then uses Google Gemini's multi-modal capabilities to perform a comprehensive analysis of both the text and any attached images. This allows it to understand the full context of a mention, score its relevance to your brand, and take the appropriate action, creating a powerful "visual intelligence" system. How it works The workflow runs on a schedule to find, analyze, and triage brand mentions. Get New Tweets: The workflow begins by using an Apify actor to scrape X for recent posts based on a defined set of search terms (e.g., Tesla OR $TSLA). It then filters these results to find unique mentions not already processed. Check for Duplicates: It cross-references each found tweet with an Airtable base to ensure it hasn't been analyzed before, preventing duplicate work. Analyze Post Content: For each new, unique post, the workflow performs two parallel analyses using Google Gemini: Analyze the Photos: The AI examines the images in the post to describe the scene, identify logos or products, and determine the visual mood. Analyze the Text: A separate AI call analyzes the text of the post to understand its context and sentiment. Final Relevance Check: A "Head Strategist" AI node receives the outputs from both the visual and text analyses. It synthesizes this information to assign a final brand relevance score from 1 to 10. Triage and Action: Based on this score, the workflow automatically triages the post: High Relevance (Score > 7): The post is logged in the Airtable base, and an instant, detailed alert is sent to a Telegram monitoring group. Medium Relevance (Score 4-7): The post is quietly logged in Airtable for later strategic review. Low Relevance (Score < 4): The post is ignored, effectively filtering out noise. Setup Instructions To get this workflow running, you will need to configure your Airtable base and provide credentials for Apify, Google, and Telegram. Required Credentials Apify: You will need an Apify API Token to run the X scraper. Airtable: You will need Airtable API credentials to connect to your base. Google AI: You will need credentials for the Google AI APIs to use the Gemini models. Telegram: You will need a Bot Token and the Chat ID for the channel where you want to receive high-relevance alerts. Of course. Based on the Config node parameters you provided, the setup process is much more centralized. Here is the corrected and rewritten "Step-by-Step Configuration" section. Of course. Here is the rewritten "Step-by-Step Configuration" section with the link to the advanced search documentation. Step-by-Step Configuration Set up Your Airtable Base: Before configuring the workflow, create a new table in your Airtable base. For the workflow to function correctly, this table must contain fields to store the analysis results. Create fields with the following names: postId, postURL, postText, postDateCreated, authorUsername, authorName, sentiment, relevanceScore, relevanceReasoning, mediaPhotosAnalysis, and status. Once the table is created, have your Base ID and Table ID ready to use in the Config node. Edit the Config Node: The majority of the setup is handled in the first Config node. Click on it and edit the following parameters in the "Expressions" tab: searchTerms: Replace the example with the keywords, hashtags, and accounts you want to monitor. The field supports advanced search operators for complex queries. For a full list of available parameters, see the Twitter Advanced Search documentation. airtableBaseId: Paste your Airtable Base ID here. airtableTableId: Paste your Airtable Table ID here. lang: Set the two-letter language code for the posts you want to find (e.g., "en" for English). min_faves: Set the minimum number of "favorites" a post should have to be considered. tweetsToScrape: Define the maximum number of posts the scraper should find in each run. actorId: This is the specific Apify actor for scraping X. You can leave this as is unless you intend to use a different one. Configure the Telegram Node: In the final node, "Send High Relevance Posts to Monitoring Group", you need to manually set the destination for the alerts. Enter the Chat ID for your Telegram group or channel. How to Adapt the Template This workflow is a powerful framework that can be adapted for various monitoring needs. Change the Source:* Replace the Apify* node with a different trigger or data source. You could monitor Reddit, specific RSS feeds, or a news API for mentions. Customize the AI Logic:* The core of this workflow is in the AI prompts. You can edit the prompts in the Google Gemini* nodes to change the analysis criteria. For example, you could instruct the AI to check for specific competitor logos, analyze the sentiment of comments, or identify if the post is from an influential account. Modify the Scoring:** Adjust the logic in the "Switch" node to change the thresholds for what constitutes a high, medium, or low-relevance post to better fit your brand's needs. Change the Actions:* Replace the Telegram* node with a different action. Instead of sending an alert, you could: Create a ticket in a customer support system like Zendesk or Jira. Send a summary email to your marketing team. Add the post to a content curation tool or a social media management platform.

🚀 Transform Your Job Hunt with AI-Powered Telegram Bot Turn job searching into a conversational experience! This intelligent Telegram bot automatically scrapes job postings from LinkedIn, Indeed, and Monster, filters for sales & marketing positions, and delivers personalized results directly to your chat. ✨ Key Features Interactive Telegram Commands**: Simple /jobs [keyword] [location] searches Multi-Platform Scraping**: Simultaneous data collection from 3 major job boards AI-Powered Filtering**: Smart relevance detection and experience level classification Real-Time Notifications**: Instant job alerts delivered to Telegram Automated Data Storage**: Saves results to Google Sheets and Airtable Duplicate Removal**: Advanced deduplication across platforms Mobile-First Experience**: Full job search functionality through Telegram 🎯 Perfect For Sales Professionals**: Account managers, sales representatives, business development Marketing Experts**: Digital marketers, marketing managers, growth specialists Recruiters**: Streamlined candidate sourcing and job market analysis Job Seekers**: Hands-free job discovery with instant notifications 🛠️ Setup Requirements Required Credentials: Telegram Bot Token**: Create bot via @BotFather Bright Data API**: Professional web scraping service (LinkedIn/Indeed datasets) Google Sheets OAuth2**: For spreadsheet integration Airtable Token**: Database storage and management Prerequisites: n8n instance with HTTPS enabled (required for Telegram webhooks) Valid domain name with SSL certificate Basic understanding of Telegram bot commands 🔧 How It Works User Experience: Send /start to activate the bot and see available commands Use /jobs sales manager New York to search for specific positions Receive formatted job results instantly in Telegram Click "Apply Now" links to go directly to job postings All jobs automatically saved to your connected spreadsheets Behind the Scenes: Command Processing: Bot parses user input for keywords and location Parallel Scraping: Simultaneous API calls to LinkedIn, Indeed, and Monster AI Processing: Intelligent filtering, experience level detection, remote work identification Data Enhancement: Salary extraction, duplicate removal, relevance scoring Multi-Format Storage: Automatic saving to Google Sheets, Airtable, and JSON export Real-Time Response: Formatted results delivered back to Telegram chat 🎨 Telegram Bot Commands /start - Welcome message and command overview /jobs [keyword] [location] - Search for jobs (e.g., /jobs marketing manager remote) /help - Show detailed help information /status - Check bot status and recent activity 📊 Sample Output The bot delivers beautifully formatted job results: 🎯 Job Search Results 🎯 Found 7 relevant opportunities Platforms: linkedin, indeed, monster Remote jobs: 3 ─────────────────── 💼 Senior Sales Manager 🏢 TechCorp Industries 📍 New York, NY 💰 $80,000 - $120,000 🌐 Remote Available 📊 senior level 🔗 Apply Now 🔒 Security & Best Practices Rate Limiting**: Built-in Telegram API compliance (30 requests/second) Error Handling**: Graceful failure recovery with user-friendly messages Input Validation**: Sanitized user input to prevent injection attacks Credential Management**: Secure API key storage using n8n credentials system HTTPS Enforcement**: Required for production Telegram webhook integration 📈 Benefits & ROI 95% Time Reduction**: Automated job discovery vs manual searching Multi-Source Coverage**: Access 3 major job platforms simultaneously Mobile Accessibility**: Search jobs anywhere using Telegram mobile app Real-Time Alerts**: Never miss new opportunities with instant notifications Data Organization**: Automatic spreadsheet management for job tracking Market Intelligence**: Comprehensive job market analysis and trends 🚀 Advanced Customization Custom Keywords**: Modify filtering logic for specific industries Location Targeting**: Adjust geographic search parameters Experience Levels**: Fine-tune senior/mid/entry level detection Additional Platforms**: Easily add more job boards via HTTP requests Notification Scheduling**: Set up periodic automated job alerts Team Integration**: Deploy for multiple users or team channels 💡 Use Cases Individual Job Seekers**: Personal job hunting assistant Recruitment Agencies**: Streamlined candidate sourcing Sales Teams**: Territory-specific opportunity monitoring Marketing Departments**: Industry trend analysis and competitor tracking Career Coaches**: Client job market research and opportunity identification Ready to revolutionize your job search? Deploy this workflow and start receiving personalized job opportunities directly in Telegram!

How It Works User sends a reminder request via Telegram (e.g., “Remind me to clean the garage tomorrow at 12 pm”). The request is parsed by AI Agent and stored in Airtable with a unique reminder code. The reminder workflow checks Airtable at scheduled intervals and sends a Telegram notification when the reminder is due. Each reminder includes a unique cancel code (e.g., Reply 4936 to stop this reminder). If the user replies with the code, the bot searches Airtable, deletes the reminder, and confirms the deletion in Telegram. If the code doesn’t exist, the bot replies “Code not found.” ⚡ Setup Steps Create a Telegram Bot Use BotFather on Telegram. Run /newbot and copy your bot token. Add the token in your Telegram Trigger and Telegram Send nodes in n8n. Set Up Airtable Create an Airtable base called REMINDER-TABLE. Add a table with fields: title (Text) – reminder text due_at (Date/Time) – when the reminder is due chat_id (Text) – user’s Telegram chat ID code (Number/Text) – unique cancel code Generate an API key / Personal Access Token and connect it in n8n. Import This Workflow In n8n, click Import Workflow. Paste the JSON template. Connect your Telegram and Airtable credentials. Activate the Workflow Start the workflow in n8n Cloud or Self-Hosted. Send a test reminder in Telegram (e.g., “Remind me in 5 minutes to call mom”). When notified, reply with the cancel code to test deletion. Optional Customizations Modify reminder frequency (Every 5 minutes node). Change reminder message formatting in the Format Message node. Add logging/analytics by connecting Google Sheets or another DB. ⚡ Result: You now have a fully automated AI-powered Telegram Reminder Bot with Airtable storage, cancel codes, and real-time notifications!

How it works • Webhook triggers from content creation system in Airtable • Downloads media (images/videos) from Airtable URLs • Uploads media to Postiz cloud storage • Schedules or publishes content across multiple platforms via Postiz API • Tracks publishing status back to Airtable for reporting Set up steps • Sign up for Postiz account at https://postiz.com/?ref=max • Connect your social media channels in Postiz dashboard • Get channel IDs and API key from Postiz settings • Add Postiz API key to n8n credentials (Header Auth) • Update channel IDs in "Prepare for Publish" node • Connect Airtable with your content database • Customize scheduling times per platform as needed • Full setup details in workflow sticky notes

Summary Chat with your AI agent in Telegram. It remembers important facts about you in Airtable, can transcribe your voice messages, search the web, read and manage Google Calendar, fetch Gmail, and query Notion. Responses are grounded in your recent memories and tool outputs, then sent back to Telegram. What this workflow does Listens to your Telegram messages (text or voice) Maintains short-term chat memory per user and long-term memory in Airtable Decides when to save new facts about you (auto “Save Memory” without telling you) Uses tools on demand: Web search via SerpAPI Google Calendar: list/create/update/delete events Gmail: list and read messages Notion: fetch database info Transcribes Telegram voice notes with OpenAI and feeds them to the agent Combines live tool results + recent memories and replies in Telegram Apps and credentials Telegram Bot API: personal_bot xAI Grok: Grok-4 model for chat OpenAI: speech-to-text (transcribe audio) Airtable: store long-term memories Google Calendar: calendar actions Gmail: email actions Notion: knowledge and reading lists SerpAPI: web search Typical use cases Personal assistant that remembers preferences, decisions, and tasks Create/update meetings by chatting, and get upcoming events Ask “what did I say I’m reading?” or “what’s our plan from last week?” Voice-first capture: send a voice note → get a transcribed, actionable reply Fetch recent emails or look up info on the web without leaving Telegram Query a Notion database (e.g., “show me the Neurocracy entries”) How it works (node-by-node) Telegram Trigger Receives messages from your Telegram chat (text and optional voice). Text vs Message Router Routes based on message contents: Text path → goes directly to the Agent (AI). Voice path → downloads the file and transcribes before AI. Always also fetches recent Airtable memories for context. Get a file (Telegram) Downloads the voice file (voice.file_id) when present. Transcribe a recording (OpenAI) Converts audio to text so the agent can use it like a normal message. Get memories (Airtable) Searches your “Agent Memories” base/table, filtered by user, sorted by Created. Aggregate (Aggregate) Bundles recent memory records into a single array “Memories” with text + timestamp. Merge (Merge) Combines current input (text or transcript) with the memory bundle before the agent. Simple Memory (Agent memory window) Short-term session memory keyed by Telegram chat ID; keeps the recent 30 turns. Tools wired into the agent SerpAPI Google Calendar tools: Get many events in Google Calendar Create an event in Google Calendar Update an event in Google Calendar Delete an event in Google Calendar Gmail tools: Get many messages in Gmail Get a message in Gmail Notion tool: Get a database in Notion Airtable tool: Save Memory (stores distilled facts about the user) Agent System prompt defines role, tone, and rules: Be a friendly assistant. On each message, decide if it contains user info worth saving. If yes, call “Save Memory” to persist a short summary in Airtable. Don’t announce memory saves—just continue helping. Use tools when needed (web, calendar, Gmail, Notion). Think with the provided memory context block. Uses xAI Grok Chat Model for reasoning and tool-calling. Can call Save Memory, Calendar, Gmail, Notion, and SerpAPI tools as needed. Save Memory (Airtable) Persists Memory and User fields to “Agent Memories” base; auto timestamp by Airtable. Send a text message (Telegram) Sends the agent’s final answer back to the same Telegram chat ID. Node map | Node | Type | Purpose | |---|---|---| | Telegram Trigger | Trigger | Receive text/voice from Telegram | | Text vs voice router | Flow control | Route text vs voice; also trigger memories fetch | | Get a file | Telegram | Download voice audio | | Transcribe a recording | OpenAI | Speech-to-text for voice notes | | Get memories | Airtable | Load recent user memories | | Aggregate | Aggregate | Pack memory records into “Memories” array | | Merge | Merge | Combine input and memories before agent call | | Simple Memory | Agent memory | Short-term chat memory per chat ID | | xAI Grok Chat Model | LLM | Core reasoning model for the Agent | | Search Web with SerpAPI | Tool | Web search | | Google Calendar tools | Tool | List/create/update/delete events | | Gmail tools | Tool | Search and read email | | Notion tool | Tool | Query a Notion database | | Save Memory | Airtable Tool | Persist distilled user facts | | AI Agent | Agent | Orchestrates tools + memory, produces the answer | | Send a text message | Telegram | Reply to the user in Telegram | Before you start Create a Telegram bot and get your token (via @BotFather). Put your Telegram user ID into the Telegram Trigger node (chatIds). Connect credentials: xAI Grok (model: grok-4-0709) OpenAI (for audio transcription) Airtable (Agent Memories base and table) Google Calendar OAuth Gmail OAuth Notion API SerpAPI key Adjust the Airtable “User” value and the filterByFormula to match your name or account. Setup instructions 1) Telegram Telegram Trigger: additionalFields.chatIds = your_telegram_id download = true to allow voice handling Send a text message: chatId = {{ $('Telegram Trigger').item.json.message.chat.id }} 2) Memory Airtable base/table must exist with fields: Memory, User, Created (Created auto-managed). In Save Memory and Get memories nodes, align Base, Table, and filterByFormula with your setup. Simple Memory: sessionKey = {{ $('If').item.json.message.chat.id }} contextWindowLength = 30 (adjust as needed) 3) Tools Google Calendar: choose your calendar, test get/create/update/delete. Gmail: set “returnAll/simplify/messageId” via $fromAI or static defaults. Notion: set your databaseId. SerpAPI: ensure the key is valid. 4) Agent (AI node) SystemMessage: customize role, name, and any constraints. Text input: concatenates transcript or text into one prompt: {{ $json.text }}{{ $json.message.text }} How to use Send a text or voice message to your bot in Telegram. The agent replies in the same chat, optionally performing tool actions. New personal facts you mention are silently summarized and stored in Airtable for future context. Customization ideas Replace Grok with another LLM if desired. Add more tools: Google Drive, Slack, Jira, GitHub, etc. Expand memory schema (e.g., tags, categories, confidence). Add guardrails: profanity filters, domain limits, or cost control. Multi-user support: store chat-to-user mapping and separate memories by user. Add summaries: a daily recap message created from new memories. Limits and notes Tool latency: calls to Calendar, Gmail, Notion, and SerpAPI add response time. Audio size/format: OpenAI transcription works best with common formats and short clips. Memory growth: periodically archive old Airtable entries, or change Aggregate window. Timezone awareness: Calendar operations depend on your Google Calendar settings. Privacy and safety Sensitive info may be saved to Airtable; restrict access to the base. Tool actions operate under your connected accounts; review scopes and permissions. The agent may call external APIs (SerpAPI, OpenAI); ensure this aligns with your policies. Example interactions “Schedule a 30‑min catch‑up with Alex next Tuesday afternoon.” “What meetings do I have in the next 4 weeks?” “Summarize my latest emails from Product Updates.” “What did I say I’m reading?” (agent recalls from memories) Voice note: “Remind me to call the dentist this Friday morning.” → agent transcribes and creates an event. Tags telegram, agent, memory, grok, openai, airtable, google-calendar, gmail, notion, serpapi, voice, automation Changelog v1: First release with Telegram agent, short/long-term memory, voice transcription, and tool integrations for web, calendar, email, and Notion.

How it works? Send a message or a voice note on Telegram right after the meeting. n8n transcribes (if it's a voice note) and sends the text to GPT. GPT generates a structured and professional meeting minutes report. The report is automatically stored in Airtable. Your team is instantly notified in Slack. A formal email is sent via Gmail to the right recipients. 👉 Works for all types of meetings: client calls, team syncs, project updates… whether you type a message or send a quick voice memo. If you need a professional n8n automation agency to build custom workflows like this, check out Vision IA's n8n automation services. ✅ Requirements Before running this workflow, you’ll need: A Telegram account with a bot configured (to send your messages/voice notes) An OpenAI API key (for GPT and voice transcription) An Airtable account with a base containing these fields: Email Subject Report A Slack account with the target channel for notifications A Gmail account connected to n8n (OAuth2) 🔧 Step-by-step setup Step 1 – Telegram Trigger Node**: Telegram Trigger Updates**: message 👉 Captures every message or voice note sent to the bot. Step 2 – Detect text or voice Node**: Code (“Message or Voice ?”) Expected output**: { type: "text", content } if message { type: "voice", file_id } if voice note 👉 Routes the workflow based on the input type. Step 3 – IF Condition Condition**: {{$json.type}} == voice 👉 Directs to the transcription branch if it’s a voice note. Voice Branch 🎤 Step 4 – Download the voice file Node**: Telegram → Voice note Parameter**: fileId = {{$json.file_id}} Step 5 – Wait Node**: Wait (2–3s) 👉 Lets Telegram prepare the file. Step 6 – Voice note download Node**: Telegram (file download) 👉 Retrieves the audio file. Step 7 – Transcribe to text Node**: OpenAI (Transcription) Resource**: audio Operation**: transcribe 👉 Converts the voice note into plain text. Step 8 – Short wait 👉 Ensures continuity before sending to GPT. Text Branch ✍️ Step 9 – Normalize Node**: Code (“Content”) Return**: { text: $json.content } 👉 Standardizes the text as if it were already a transcription. Step 10 – Detect email Node**: Code (“Domain or Email detection”) 👉 Extracts the target email (or builds a fallback [email protected]). Step 11 – Generate meeting minutes Node**: Agent (“Generate Meeting Message”) Prompt**: specialized for “meeting minutes” Model**: GPT-4.1-mini Output**: { email, subject, body } 👉 GPT creates a clean and structured meeting report. Step 12 – Enforce clean JSON Node**: Output Parser Structured JSON Example**: json {"email": "[email protected]","subject":"Subject","body":Email"} 👉 Ensures the output is always valid JSON. Step 13 – Cleanup / Airtable mapping Node**: Code Return**: { Email, subject, Report } 👉 Prepares the correct fields aligned with your Airtable table. If you need help setting up advanced Airtable workflows and database automation, check out Vision IA's Airtable automation services. Step 14 – Store in Airtable Node**: Airtable (Create Record) Mapping**: Email = {{$json.Email}} subject = {{$json.subject}} Report = {{$json.Report}} 👉 Archives each meeting report in your Airtable base. Step 15 – Notify in Slack Node**: Slack (Send Message) Channel**: your team channel Message**: {{$json.fields.subject}}{{$json.fields.Report}} Step 16 – Send the email Node**: Gmail (Send Email) sendTo**: {{$('Create a record').item.json.fields.Email}} subject**: {{$('Create a record').item.json.fields.subject}} message**: {{$('Create a record').item.json.fields.Report}} Need Help Automating Your Communication Workflows? This n8n workflow shows how powerful email automation and AI-powered documentation can be. If you want to go further with automated email campaigns, meeting follow-ups, and team communication systems, our agency specializes in building custom solutions. 👉 Explore our email automation services: Vision IA – Email Automation Agency We help businesses automate their entire communication pipeline—from meeting notes to client follow-ups and internal notifications—all running automatically with AI assistance. Questions about this workflow or other automation solutions? Visit Vision IA or reach out for a free consultation.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. How it works • Publishes content to 9 social platforms (Instagram, YouTube, TikTok, Facebook, LinkedIn, Threads, Twitter/X, Bluesky, Pinterest) from a single Airtable base • Automatically uploads media to Blotato, handles platform-specific requirements (YouTube titles, Pinterest boards), and tracks success/failure for each post • Includes smart features like GPT-powered YouTube title optimization, Pinterest Board ID finder tool, and random delays to avoid rate limits Set up steps • Takes ~20–35 minutes to configure all 9 platforms (or less if you only need specific ones) • Requires Airtable personal access token, Blotato API key, and connecting your social accounts in Blotato dashboard • Workflow includes comprehensive sticky notes with step-by-step Airtable base setup, credential configuration, platform ID locations, and quick debugging links for each social network Pro tip: The workflow is modular - you can disable any platforms you don't use by deactivating their respective nodes, making it flexible for any social media strategy from single-platform to full omnichannel publishing.

Sleeper NFL Team Chatbot Starter A Telegram chatbot built to look up your fantasy football team in the Sleeper app and return your roster details, player names, positions, and team info. This starter workflow is perfect for users who want a simple, conversational way to view their Sleeper team in-season or pre-draft. What It Does When a user types their Sleeper username into Telegram, this workflow: Extracts the username from Telegram Pulls their Sleeper User ID Retrieves their Leagues and selects the first one (by default) Pulls the full league Rosters Finds the matching roster owned by that user Uses player_ids to look up full player info from a connected database (e.g. Airtable or Google Sheets) Returns a clean list of player names, positions, and teams via Telegram Requirements To get this running, you’ll need: A Telegram bot (set up through BotFather) A Sleeper Fantasy Football account A synced player database that matches player_id to full player details (we recommend using the companion template: Sleeper NFL Players Daily Sync) Setup Instructions Import the workflow into your n8n instance Add the required credentials: Telegram (API Key from BotFather) Airtable (or replace with another database method like Google Sheets or HTTP request to a hosted JSON file) Trigger the workflow by sending your exact Sleeper username to the bot Your full team roster will return as a formatted message > If the user is in multiple Sleeper leagues, the current logic returns the first league found. Example Output You have 19 players on your roster: Cam Akers (RB - NO), Jared Goff (QB - DET), ... Customization Notes Replace Telegram Trigger with any other input method (webhook, form input, etc.) Replace Airtable node with Google Sheets, SQL DB, or even a local file if preferred You can hardcode a Sleeper username if you're using this for a single user Related Templates Sleeper NFL Players Daily Sync (syncs player_id to player name, position, team) -Create Player Sync first then either integrate it to this template or reate a subworkflow from it & use most recent data set. Difficulty Rating & Comment (from the author) 3 out of 10 if this ain't you're first rodeo, respectfully. Just a little bit more work on adding the Players Sync as your data table & knowing how to GET from Sleeper. If you use Sleeper for fantasy football, lets go win some games!

How it works This workflow runs on a daily schedule. It starts by scraping real estate-related queries from Google using Apify. The organic search results are parsed and summarized into a single text block. That text is then sent to an AI model (GPT-4o) which extracts the top 3 pain points faced by real estate agents based on current online sentiment. The workflow compares today's insights with yesterday's data stored in Airtable to detect recurring or new pain points. Finally, it sends a summary notification via Telegram and stores the current day's insights into Airtable for trend tracking. How to set up Clone or import the workflow into your n8n instance. Get an Apify API token and insert it into the HTTP Request node. Create an Airtable base with a table containing two fields: "Date" (text) and "Summary" (long text). Copy the Base ID and Table ID into the Airtable nodes. Connect your Telegram bot and replace the chat ID in the Telegram node. Set up OpenAI credentials with GPT-4o or GPT-4o-mini for the LLM node. Run once manually to test, then activate the schedule trigger to run daily. (Optional) Extend the flow to generate cold outreach emails based on pain points, or sync to Notion/CRM.

This telegram bot is designed to send one random recipe a day. This specific bot has filtered out only vegan recipes, so you can choose your diet type and send only recipes for a specific diet. What credentials you need: Set up a telegram bot. Airtable for listing who has joined your bot. This is needed to send one random recipe a day. Recipe (or other) API. This one uses Spoonacular. I hope you enjoy your bot!

This workflow extracts text from images sent in a Telegram chat and uploads the images to AWS S3. Telegram Trigger node** triggers the workflow when an image is sent in a Telegram channel. AWS S3 node** uploads the sent image to an S3 bucket. AWS Textract node** extracts text from the image. Airtable node** adds the extracted text and image information to a table.