AutomationMart
Home/Browse/AI-Powered Employee Database Management via Telegram using OpenAI and Airtable
n8n

AI-Powered Employee Database Management via Telegram using OpenAI and Airtable

n8nn8n22 modulesv1.0
GmailSlackNotionAirtableGoogle SheetsOpenAITelegram

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 directl

At a glance

AI-Powered Employee Database Management via Telegram using OpenAI and Airtable is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Slack, Notion, Airtable. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Slack, Notion, Airtable, Google Sheets, OpenAI
Modules
22
Price
Free
Version
v1.0
AI-Powered Employee Database Management via Telegram using OpenAI and Airtable workflow diagram

About this workflow

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: 1. Chat in natural language (e.g. “Show me all employees” or “Create employee: Sarah, Marketing…”) 2. Interpret and route requests via an AI Agent that acts as the orchestrator 3. Query employee, department, and job title data from Airtable 4. 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 5. Delete employees based on ID 6. Respond directly in Telegram, providing user-friendly feedback --- Setup 1. View & Copy the Airtable base here: 👉 Employee Database Management – Airtable Base Template 2. Telegram Bot: Set up a Telegram bot and connect it to the Telegram Trigger node 3. Airtable: Prepare three Airtable tables: Employees with links to Departments and Job Titles Departments with Name & Description Job Titles with Title & Description 4. Connect your Airtable API key and base/table IDs into the appropriate Airtable nodes 5. Add your OpenAI API key to the AI Agent nodes 6. Deploy both workflows: the main chatbot workflow and the employee creation sub-workflow 7. Test with sample messages like: “Create employee: John Doe, john@company.com, 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: 📧 billychartanto@gmail.com

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Add Go4Clients Email from Google Sheets new rows

Every time you receive or send an Email via Go4Clients, Make will automatically add the message to specified Google Sheets spreadsheet as a new row. The template uses this template spreadsheet

Free

Send scheduled WhatsApp order review requests (Part 2 of 2)

Automatically send WhatsApp order review requests from your queued orders. This template processes the Google Sheet queue created by Part 1 and sends personalized WhatsApp review requests via WhatsScale CRM. **How it works:** 1. Runs daily on schedule 2. Finds orders where Send Date is today or earlier 3. Looks up or creates CRM contact 4. Sends personalized order review request 5. Removes processed order from queue **Setup required:** - Google Sheets connection (same spreadsheet as Part 1) -

Free

Send Real-Time Market Alerts to Telegram

This scenario allows you to receive real-time news alerts from finlight directly in a Telegram chat. When finlight pushes a new article via webhook (based on your custom filters), this automation formats the headline, timestamp, and summary, and sends it as a Telegram message. Use this to track breaking financial news, central bank moves, geopolitical alerts, or company-specific headlines—without refreshing news sites.

Free

Receipt scanning & analysis workflow

How it works: - Automatically detects when a new receipt is uploaded to Google Drive. - Extracts text from the receipt using OCR. - Uses an AI Agent to analyze the extracted data and structure it (e.g., vendor, date, total, tax). - Saves the organized receipt data into a Google Sheet for easy tracking. Set up steps: - Setup takes around 15–20 minutes. - You'll need a Google Drive folder for receipts and a Google Sheet to store results. - Configure your Google Drive Trigger, OCR extraction, AI Ag

Free

Get Slack messages for new Adalo records

Make will watch for new records in Adalo at regular intervals and send messages to a specified channel or chat in Slack.

Free

Get content of a Google Doc, edit using ChatGPT and create a new doc

Periodically fetch contents of a Google Doc and edit using ChatGPT. The automation will then create a new Google Doc with the AI results.

Free

Scheduled YouTube video uploads with Google Sheets & Drive integration

Description: Effortlessly automate YouTube video uploads with this ready-to-use n8n workflow. Integrated with Google Sheets, Google Drive, and YouTube API, this template streamlines your video publishing process based on scheduled metadata entries. Key Features: - 🗓️ Scheduled Uploads (Mon–Fri at 9 AM, 12 PM, 3 PM) - 📋 Reads video metadata (title, description, filename) from Google Sheets - 🔍 Locates video files in Google Drive by filename - ⬇️ Downloads and uploads videos to YouTube with the co

Free

Create daily AI news YouTube Shorts with Groq, VoiceRSS, Pexels and Shotstack

Quick Overview This workflow runs daily to turn the latest Artificial Intelligence News RSS headline into a YouTube Shorts video by generating a script with Groq, creating voiceover with VoiceRSS, selecting stock footage from Pexels, rendering with Shotstack, and uploading the finished MP4 to YouTube. How it works 1. Runs every 24 hours on a scheduled trigger. 2. Reads the latest item from the Artificial Intelligence News RSS feed and extracts the headline and summary. 3. Uses Groq (Llama 3.1) t

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free