HR & IT helpdesk chatbot with audio transcription
An intelligent chatbot that assists employees by answering common HR or IT questions, supporting both text and audio messages. This unique feature ensures employees can conveniently ask questions via voice messages, which are transcribed and processed just like text queries. --- How It Works Message Capture: When an employee sends a message to the chatbot in WhatsApp or Telegram (text or audio), the chatbot captures the input. Audio Transcription: For audio messages, the chatbot transcribes the content into text using an AI-powered transcription service (e.g., Whisper, Google Cloud Speech-to-Text). Query Processing: The transcribed text (or directly entered text) is sent to an AI service (e.g., OpenAI) to generate embeddings. These embeddings are used to search a vector database (e.g., Supabase or Qdrant) containing the company’s internal HR and IT documentation. The most relevant data is retrieved and sent back to the AI service to compose a concise and helpful response. Response Delivery: The chatbot sends the final response back to the employee, whether the input was text or audio. --- Set Up Steps Estimated Time: 20–25 minutes Prerequisites: Create an account with an AI provider (e.g., OpenAI). Connect WhatsApp or Telegram credentials in n8n. Set up a transcription service (e.g., Whisper or Google Cloud Speech-to-Text). Configure a vector database (e.g., Supabase or Qdrant) and add your internal HR and IT documentation. Import the workflow template into n8n and update environment variables for your credentials.
By Felipe BragaAutomate hotel booking requests from Gmail to Google Sheets with GPT-5-mini
Who’s it for This workflow is for hotel managers, travel agencies, and hospitality teams who receive booking requests via email. It eliminates the need for manual data entry by automatically parsing emails and attachments, assigning booking cases to the right teams, and tracking performance metrics. What it does This workflow goes beyond simple automation by including enterprise-grade logic and security: 🛡️ Gatekeeper: Watches your Gmail and filters irrelevant emails before spending money on AI tokens. 🧠 AI Brain: Uses OpenAI (GPT-5-mini) to extract structured data from unstructured email bodies and PDF attachments. ⚖️ Business Logic: Automatically routes tasks to different teams based on urgency, room count, and VIP status. 🔒 Security: Catches PII (like credit card numbers) and scrubs them before they hit your database. 🚨 Safety Net: If anything breaks, a dedicated error handling path logs the issue immediately so no booking is lost. 📈 ROI Tracking: Calculates the time saved per booking to prove the value of automation. How to set up Create your Google Sheet: Create a new sheet and rename the tabs to: Cases, Team Assignments, Error Logs, Success Metrics. Add Credentials: Go to n8n Settings → Credentials and add your Gmail (OAuth2), Google Sheets, and OpenAI API keys. Configure User Settings: Open the "Configuration: User Settings" node at the start of the workflow. Paste your specific Google Sheet ID and Admin Email there. Adjust Business Rules: Open the "Apply Business Rules" node (Code node) to adjust the logic for team assignment (e.g., defining what counts as a "VIP" booking). Customize Templates: Modify the email templates in the Gmail nodes to match your hotel's branding. Test: Send a sample booking email to yourself to verify the filters and data extraction. Setup requirements Gmail account (OAuth2 connected) Google Sheets (with the 4 tabs listed below) OpenAI API key (GPT-5-mini recommended) n8n Cloud or self-hosted instance How to customize Filter Booking Emails: Update the trigger node keywords to match your specific email subjects (e.g., "Reservation", "Booking Request"). Apply Business Rules: Edit the Javascript in the Code node to fit your company’s internal logic (e.g., changing priority thresholds). New Metrics: Add new columns in the Google Sheet (e.g., “Revenue Metrics”) and map them in the "Update Sheet" node. AI Model: Switch to GPT-5 if you need higher reasoning capabilities for complex PDF layouts. Google Sheets Structure Description This workflow uses a Google Sheets document with four main tabs to track and manage hotel booking requests. Cases This is the main data log for all incoming booking requests. case_id: Unique identifier generated by the workflow. processed_date: Timestamp when the workflow processed the booking. travelagency / contactdetails: Extracted from the email. numberofrooms / checkindate: Booking details parsed by the AI. special_requests: Optional notes (e.g., airport transfer). assigned_team / priority: Automatically set based on business rules. daysuntilcheckin: Dynamic field showing urgency. Team Assignments Stores internal routing and assignment details. timestamp: When the case was routed. case_id: Link to the corresponding record in the Cases tab. assignedteam / teamemail: Which department handles this request. priority: Auto-set based on room count or urgency. Error Log A critical audit trail that captures details about any failed processing steps. errortype: Categorization of the failure (e.g., MISSINGREQUIRED_FIELDS). error_message: Detailed technical explanation for debugging. original_sender / snippet: Context to help you manually process the request if needed. Success Metrics Tracks the results of your automation to prove its value. processingtimeseconds: The time savings achieved by the automation (run time vs. human time). record_updated: Confirmation that the database was updated. 🙋 Support If you encounter any issues during setup or have questions about customization, please reach out to our dedicated support email: foivosautomationhelp@gmail.com
By GtarasAutomated crypto market summaries using Gemini AI and CoinGecko data
Try It Out! The AI Investment Research Assistant (Discord Summary Bot) transforms your Discord server into a professional-grade AI-driven crypto intelligence center. Running automatically every morning, it gathers real-time news, sentiment, and market data from multiple trusted sources — including NewsAPI, Crypto Compare, and CoinGecko — covering the most influential digital assets like BTC, ETH, SOL, BNB, and ADA. An AI Research Analyst Agent then processes this data using advanced reasoning and summarization to deliver a structured Market Intelligence Briefing. Each report distills key market events, sentiment shifts, price movements, and analyst-grade insights, all formatted into a visually clean and actionable message that posts directly to your Discord channel. Whether you’re a fund manager, community owner, or analyst, this workflow helps you stay informed about market drivers — without manually browsing dozens of news sites or data dashboards. --- Detailed Use Cases Crypto Research Teams: Automate daily market briefings across key assets. Investment Communities: Provide daily insights and sentiment overviews directly on Discord. Trading Desks: Quickly review summarized market shifts and performance leaders. DAOs or Fund Analysts: Centralize institutional-style crypto intelligence into your server. --- How It Works Daily Trigger (Schedule Node) – Activates each morning to begin data collection. News Aggregation Layer – Uses NewsAPI (and optionally CryptoPanic or GDELT) to fetch the latest crypto headlines and event coverage. Market & Sentiment Fetch – Collects market metrics via CoinGecko or Crypto Compare, including: 24-hour price change Market cap trend Social sentiment or Fear & Greed index AI Research Analyst (LLM Agent) – Processes and synthesizes all data into a cohesive insight report containing: 🧠 Executive Summary 📊 Top Gainers & Losers 💬 Sentiment Overview 🔍 Analyst Take / Actionable Insight Formatting Layer (Code Node) – Converts the analysis into a Discord-ready structure. Discord Posting Node – Publishes the final Market Intelligence Briefing to a specified Discord channel. --- Setup and Customization Import this workflow into your n8n workspace. Configure credentials: NewsAPI Key – For crypto and blockchain news. CoinGecko / Crypto Compare API Key – For real-time asset data. LLM Credential – OpenAI, Gemini, or Anthropic. Discord Webhook URL or Bot Token – To post updates. Customize the tracked assets in the News and Market nodes (BTC, ETH, SOL, BNB, ADA, etc.). Set local timezone for report delivery. Deploy and activate — your server will receive automated morning briefings. --- Output Format Each daily report includes: 📰 AI Market Intelligence Briefing 📅 Date: October 16, 2025 💰 Top Movers: BTC +2.3%, SOL +1.9%, ETH -0.8% 💬 Sentiment: Moderately Bullish 🔍 Analyst Take: Accumulation signals forming in mid-cap layer-1s. 📈 Outlook: Positive bias, with ETH showing strong support near $2,400. Compact yet rich in insight, this format ensures quick readability and fast decision-making for traders and investors. --- (Optional) Extend This Workflow Portfolio-Specific Insights: Fetch your wallet holdings from AFK Crypto or Zapper APIs for personalized reports. Interactive Commands: Add /compare or /analyze commands for Discord users. Multi-Language Summaries: Auto-translate for international communities. Historical Data Logging: Store briefings in Notion or Google Sheets. Weekly Recaps: Summarize all daily reports into a long-form analysis. --- Requirements n8n Instance (with HTTP Request, AI Agent, and Discord nodes enabled) NewsAPI Key CoinGecko / Crypto Compare API Key LLM Credential (OpenAI / Gemini / Anthropic) Discord Bot Token or Webhook URL --- APIs Used GET https://newsapi.org/v2/everything?q=crypto OR bitcoin OR ethereum OR defi OR nft&language=en&sortBy=publishedAt&pageSize=10 GET https://api.coingecko.com/api/v3/simple/price?ids=bitcoin,ethereum,solana&vscurrencies=usd&includemarketcap=true&include24hr_change=true (Optional)* GET https://cryptopanic.com/api/v1/posts/?authtoken=YOURTOKEN&kind=news (Optional)* GET https://api.gdeltproject.org/api/v2/doc/doc?query=crypto&format=json --- Summary The AI Investment Research Assistant (Discord Summary Bot) is your personal AI research analyst — delivering concise, data-backed crypto briefings directly to Discord. It intelligently combines news aggregation, sentiment analysis, and AI reasoning to create actionable market intelligence each morning. Ideal for crypto traders, funds, or educational communities seeking a reliable daily edge — this workflow replaces hours of manual research with one automated, professional-grade summary. --- Our Website: https://afkcrypto.com/ Check our blogs: https://www.afkcrypto.com/blog
By AFK Crypto