Telegram appointment scheduler bot with Google Calendar & Sheets
Telegram Appointment Scheduling Bot with n8n 📃 Description Tired of managing appointments manually? This template transforms your Telegram account into a smart virtual assistant that handles the entire scheduling process for you, 24/7. This workflow allows you to deploy a fully functional Telegram bot that not only schedules appointments but also checks real-time availability in your Google Calendar, logs a history in Google Sheets, and allows your clients to cancel or view their upcoming appointments. It's the perfect solution for professionals, small businesses, or anyone looking to automate their booking system professionally and effortlessly. --- ✨ Key Features Complete Appointment Management: Allows users to schedule, cancel, and list their future appointments. Conflict Prevention: Integrates with Google Calendar to check availability before confirming a booking, eliminating the risk of double-booking. Automatic Logging: Every confirmed appointment is saved to a row in Google Sheets, creating a perfect database for tracking and analysis. Smart Interaction: The bot handles unrecognized commands and guides the user, ensuring a smooth experience. Easy to Adapt: Connect your own accounts, customize messages, and tailor it to your business needs in minutes. --- 🚀 Setup Follow these steps to deploy your own instance of this bot: Prerequisites An n8n instance (Cloud or self-hosted). A Telegram account. A Google account. Telegram Bot Talk to @BotFather on Telegram. Create a new bot using /newbot. Give it a name and a username. Copy and save the API token it provides. Google Cloud & APIs Go to the Google Cloud Console. Create a new project. Enable the Google Calendar API and Google Sheets API. Create OAuth 2.0 Client ID credentials. Make sure to add your n8n instance's OAuth redirect URL. Save the Client ID and Client Secret. Google Sheets Create a new spreadsheet in Google Sheets. Define the column headers in the first row. For example: id, Client Name, Date and Time, ISO Date. n8n Import the workflow JSON file into your n8n instance. Set up the credentials: Telegram: Create a new credential and paste your bot's token. Google Calendar & Google Sheets (OAuth2): Create a new credential and paste the Client ID and Client Secret from the Google Cloud Console. Review the Google Calendar and Google Sheets nodes to select your correct calendar and spreadsheet. Activate the workflow! --- 💬 Usage Once the bot is running, you can interact with it using the following commands in Telegram: To start the bot: /start To schedule a new appointment: agendar YYYY-MM-DD HH:MM Your Full Name To cancel an existing appointment: cancelar YYYY-MM-DD HH:MM Your Full Name To view your future appointments: mis citas Your Full Name --- 👥 Authors Jaren Pazmiño President of the Polytechnic Artificial Intelligence Club (CIAP)
By Club de Inteligencia Artificial Politécnico CIAPAutomate HR recruitment with OpenAI resume screening & interview QnA generator
<br> <div> Build an AI HR Assistant to Screen Resumes and Send Telegram Alerts A step-by-step guide to creating a fully automated recruitment pipeline that screens candidates, generates interview questions, and notifies your team. This template provides a complete, step-by-step guide to building an AI-powered HR assistant from scratch in n8n. You will learn how to connect a web form to an intelligent screening agent that reads resumes, evaluates candidates against your job criteria, and prepares unique interview questions for the most promising applicants. <br> | Services Used | Features | | :---------------------------------------------- | :----------------------------------------------------------------------------- | | 🤖 OpenAI / LangChain | Uses AI Agents to screen, score, and analyze candidates. | | 📄 Google Drive & Google Sheets | Stores resumes and manages a database of open positions and applicants. | | 📥 n8n Form Trigger | Provides a public-facing web form to capture applications. | | 💬 Telegram | Sends real-time alerts to the hiring team for qualified candidates. | --- How It Works ⚙️ 📥 Application Submitted: The workflow starts when a candidate fills out the n8n Form Trigger with their details and uploads their CV. 📂 File Processing: The CV is automatically uploaded to a specific Google Drive folder for record-keeping, and the Extract from File node reads its text content. 🧠 AI Screening Agent: A LangChain Agent analyzes the resume text. It uses the Google Sheets Tool to look up the requirements for the applied role, then scores the candidate and decides if they should be shortlisted. 📊 Log Results: The agent's decision (name, score, shortlisted status) is logged in your master "Applications" Google Sheet. ✅ Qualification Check: An IF node checks if the candidate was shortlisted. ❓ AI Question Generator: If shortlisted, a second LangChain Agent generates three unique, relevant interview questions based on the candidate's resume and the job description. ✍️ Update Sheet: The generated questions are added to the candidate's row in the Google Sheet. 🔔 Notify Team: A final alert is sent via Telegram to notify the HR team that a new candidate has been qualified and is ready for review. --- 🛠️ How to Build This Workflow Follow these steps to build the recruitment assistant from a blank canvas. Step 1: Set Up the Application Intake Add a Form Trigger node. Configure it with fields for Name, Email, Phone Number, a File Upload for the CV, and a Dropdown for the "Job Role". Connect a Google Drive node. Set the Operation to Upload and connect your credentials. Set it to upload the CV file from the Form Trigger into a specific folder. Add an Extract from File node. Set it to extract text from the PDF CV file provided by the trigger. Step 2: Build the AI Screening Agent Add a Langchain Agent node. This will be your main screening agent. In its prompt, instruct the AI to act as a resume screener. Tell it to use the input text from the Extract from File node and the tools you will provide to score and shortlist candidates. Add an OpenAI Chat Model node and connect it to the Agent's Language Model input. Add a Google Sheets Tool node. Point it to a sheet with your open positions and their requirements. Connect this to the Agent's Tool input. Add a Structured Output Parser node and define the JSON structure you want the agent to return (e.g., candidate_name, score, shortlisted). Connect this to the Agent's Output Parser input. Step 3: Log Results & Check for a Match Connect a Google Sheets node after the Agent. Set its operation to Append or Update. Use it to add the structured output from the agent into your main "Applications" sheet. Add an IF node. Set the condition to continue only if the shortlisted field equals "yes". Step 4: Generate Interview Questions On the 'true' path of the IF node, add a second Langchain Agent node. Write a prompt telling this agent to generate 3 interview questions based on the candidate's resume and the job requirements. Connect the same OpenAI Model and Google Sheets Tool to this agent. Add another Google Sheets node. Set it to Update the existing row for the candidate, adding the newly generated questions. 💬 Need Help or Want to Learn More? Join my Skool community for n8n + AI automation tutorials, live Q&A sessions, and exclusive workflows: 👉 https://www.skool.com/n8n-ai-automation-champions --- Template Author: Sandeep Patharkar Category: Website Chatbots / AI Automation Difficulty: Beginner Estimated Setup Time: ⏱️ 15 minutes
By Sandeep Patharkar | www.FastTrackAiMastery.comExtract seed-funded startup data with RSS, GPT-4.1-MINI & BrightData to Excel
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. What It Does This workflow automatically discovers recently seed-funded startups by monitoring RSS feeds for funding announcements. It uses Bright Data to scrape full article content, then extracts structured company information using OpenAI (GPT). The data is exported to an Excel sheet on OneDrive, providing sales teams with a real-time list of qualified leads without any manual effort. How It Works Trigger & Article Discovery: Monitors curated RSS feeds for articles mentioning seed funding and triggers the workflow on new article detection. Content Scraping & Preparation: Scrapes full article content and converts it into clean markdown format for AI processing. Data Extraction with AI: Uses OpenAI to extract structured details like company name, website, LinkedIn profile, founders, and funding amount. Structured Data Output & Storage: Appends extracted data to an Excel sheet on OneDrive via Microsoft Graph API. Prerequisites RSS Feed URL: A valid RSS feed source that provides seed funding articles for startups. Bright Data Credentials: Active Bright Data account with access credentials (API token ) to enable article scraping. OpenAI API Key: An OpenAI account with an API key and access to GPT-4.1-MINI models for data extraction. Microsoft OAuth2 API Credentials: OAuth2 credentials (Client ID, Secret, Tenant ID) with access scopes to use Microsoft Graph API for Excel integration. Excel Sheet in SharePoint: A pre-created Excel file hosted on OneDrive or SharePoint with the following column headers: createdAt, companyName, companyWebsite, companyLinkedIn, fundingAmount, founderName, founderLinkedIn, articleLink Excel File & Sheet Identifiers: The Drive ID, File ID and Sheet ID of your Excel sheet stored on OneDrive or SharePoint, required by the Microsoft Graph API for appending rows using the HTTP node in n8n. Need help with the setup? Feel free to contact us How to Set It Up Follow these steps to configure and run the workflow: Import the Workflow Copy the provided n8n workflow template. In your n8n instance, go to Editor UI > paste this workflow. Configure the RSS Feed Node Open the RSS trigger node. Replace the default URL with your RSS feed URL. Ensure the polling interval matches your desired frequency (e.g., every 15 minutes or 1 hour). Set Up Bright Data Node Add your Bright Data credentials. Follow the documentation to complete the setup. Configure OpenAI Integration Add your OpenAI API key as a credential in n8n. Ensure the model is set to gpt-4.1-MINI. Follow the documentation to complete the setup. Configure Excel File Integration Open the HTTP node responsible for sending data to the Excel sheet via Microsoft Graph API. Replace the placeholder values in the API endpoint URL with your actual File ID and Sheet ID from the Excel file stored on OneDrive or SharePoint. https://graph.microsoft.com/v1.0/drives/{{drive-id}}/items/{{file-id}}/workbook/tables/{ {{ sheet-id }} }/rows This URL is used to append data to the specified Excel sheet range. Next, set up Microsoft OAuth2 credentials in n8n: Go to n8n > Credentials > Microsoft OAuth2 API. Provide the required values: Client ID Client Secret Tenant ID Scope Follow the documentation to complete the setup. Once the credential is saved, connect it to the HTTP node making the Graph API call. Activate the Workflow Set the workflow status to Active in n8n so it runs automatically when a new article appears in the RSS feed. --- Need Help? Contact us for support and custom workflow development.
By Eumentis