Microsoft Excel 365 and Telegram integration

Track changes and approvals in Excel 365 📌 Overview This workflow monitors an Excel 365 sheet every minute and detects new, updated, and deleted rows using a unique ID column. It compares the current dataset with the previous snapshot and identifies field-level differences. When changes are detected, the workflow filters rows that require approval (Status = “Waiting Approval”), sends structured notifications, and optionally logs every field-level change into an audit sheet (Excel or Google Sheets). The configuration layer allows you to define the ID column, ignored fields, and audit logging behavior without modifying the comparison logic. This template is suitable for approval tracking, operational monitoring, and lightweight compliance logging. How it works Runs every minute using a schedule trigger Reads rows from Excel 365 Normalizes and stores a snapshot Compares with the previous state Detects new, updated, and deleted rows Filters rows with “Waiting Approval” status Sends structured notifications Logs changes if audit logging is enabled Setup steps Configure Microsoft Excel credentials Ensure your sheet contains a unique ID column Update the Environment Config node 4.(Optional) Configure Google Sheets credentials for audit logging Activate the workflow 🚀 Features ⏱ Scheduled Monitoring Runs automatically every 1 minute Near real-time Excel monitoring Prevents unnecessary execution when no changes are detected 🔍 Row-Level Change Detection Detects: ✅ New rows ✏️ Updated rows ❌ Deleted rows Uses a unique ID field per row for accurate tracking. ⸻ 🧠 Field-Level Comparison Compares previous vs current values Identifies exactly which fields changed Outputs structured change data Prevents false positives via data normalization ⸻ ⚙️ Environment Configuration Layer Centralized configuration node allows easy customization without modifying core logic. Configurable options include: idField ignoreFields monitorOnly firstRunSilent enableAuditLog No hardcoded logic required. ⸻ 🛑 Approval Validation Layer Filters rows where Status = "Waiting Approval" Sends notifications only for relevant approval cases Prevents unnecessary alerts ⸻ 🔔 Smart Notification System Sends formatted change notifications Includes: Change Type (NEW / UPDATED / DELETED) Row ID Field-level old → new values Fully customizable message formatting. ⸻ 📊 Optional Audit Logging If enabled in the Environment Config: Converts each field-level change into structured audit rows Appends logs to: Excel 365 (Audit Sheet) Google Sheets (External Log) Audit Log Structure | Timestamp | ChangeType | RowID | Field | OldValue | New Value | |-------------|--------------|--------|------|----------|------------| Designed for compliance and tracking purposes. 📦 Use Cases Internal approval tracking Financial data monitoring Sales pipeline control Procurement workflows Excel-based compliance systems SME automation systems 🧩 Requirements Microsoft 365 (Excel Online – Business) n8n (Cloud or Self-hosted) Microsoft credentials configured in n8n Telegram Bot (Optional) Google Sheets credentials for audit logging 🔧 Configuration Guide All system behavior is controlled from the Environment Config node. Example configuration structure: { CONFIG: { idField: "ID", ignoreFields: ["UpdatedAt", "LastModified"], monitorOnly: null, firstRunSilent: true, enableAuditLog: true } } You can customize: Which column acts as unique ID Which fields to ignore Which fields to monitor exclusively Whether to enable audit logging Whether first run should be silent 🟢 First Run Behavior On first execution: The workflow initializes internal snapshot storage No mass notification is sent (if firstRunSilent = true) This prevents false “NEW row” alerts during setup. 🏢 Who Is This For? Operations teams Finance departments SMEs using Excel as core system Automation consultants Businesses requiring lightweight audit tracking ⸻ 💡 Why This Workflow? Unlike simple Excel polling workflows, this solution: Tracks changes at field level Supports approval-based filtering Includes structured audit logging Avoids duplicate alerts Is fully configurable Designed for production usage This is not just an Excel notifier — it is a structured Change Tracking & Approval Monitoring System built on n8n.

📸💰 Log receipt transactions from Telegram images to Excel using OCR and AI OCR + AI + Duplicate Protection (n8n Workflow) Overview This workflow automatically converts receipt images or payment proof sent via Telegram into structured financial records stored in Excel 365. Core flow: Take Photo → OCR → AI Structuring → Validation → Duplicate Check → Append to Excel The system is designed to reduce manual data entry errors and improve financial visibility by turning unstructured receipt images into reliable financial records. ⸻ How it works This workflow captures receipt images sent to a Telegram bot and converts them into structured financial records in Excel. When a user sends an image, the workflow downloads the file and extracts the text using OCR. The extracted text is then analyzed by an AI model (OpenAI or Gemini) to identify key transaction details such as date, amount, merchant, and transaction type. The workflow validates the extracted data and generates a unique duplicate key. It then checks Excel to ensure the transaction has not already been recorded. If no duplicate is found, the transaction is appended to the Excel sheet. The user receives a confirmation message in Telegram indicating whether the transaction was successfully recorded or rejected due to missing data or duplication. Workflow Nodes The workflow contains the following nodes: Telegram Trigger Edit Fields (extract chat_id and image_id) Condition (validate image exists) Telegram Get File Tesseract OCR AI Agent (ChatGPT / Gemini) Edit Field (JSON Output Parsing) Excel 365 – Get Configuration Edit Field – Normalize & Generate duplicate_key Condition – Validate required fields Excel 365 – Lookup duplicate_key Condition – Duplicate Check Excel 365 – Append Transaction Telegram – Send Confirmation Message 🧠 What This Workflow Does This workflow automatically: Captures receipt images from Telegram Extracts text using OCR Converts OCR text into structured transaction data using AI Validates required financial fields Prevents duplicate transaction entries Saves valid records into Excel Sends confirmation messages to Telegram Setup steps Create a Telegram bot using @BotFather and copy the Bot Token. Add Telegram credentials in n8n using the Bot Token. Prepare an Excel file in OneDrive or SharePoint with a TRANSACTIONS sheet. Configure Microsoft Excel credentials in n8n. Add either OpenAI or Google Gemini credentials for the AI parsing step. If running self-hosted n8n, ensure Tesseract OCR is installed. Activate the workflow and send a receipt image to the Telegram bot to test. 🎯 Key Benefits • Reduce financial recording errors • Eliminate repetitive manual data entry • Improve cashflow visibility • Simple photo-based financial recording • Scalable foundation for AI-powered financial automation 🚀 Use Cases This workflow is useful for: • Small business owners • Online sellers • Freelancers • Finance administrators • Personal expense tracking 📌 Notes • Duplicate detection is based on a composite transaction key • OCR accuracy depends on image quality • AI parsing improves recognition compared to OCR-only approaches 🧱 Requirements To run this workflow you need: • n8n (Cloud or Self-Hosted) • Telegram Bot Token • Microsoft Excel 365 Account • OpenAI API Key or Google Gemini API Key • Tesseract OCR (for self-hosted installations) 🏁 Result After setup, users can simply send receipt photos to Telegram and the workflow will automatically convert them into structured financial records stored in Excel. No manual bookkeeping required. Built for automation lovers, small businesses, and teams who want simple but powerful financial tracking using n8n.

AI Email Analyzer with Department Routing and Excel Logging (n8n Workflow) Overview This workflow automatically analyzes incoming emails using AI, categorizes them, routes them to the appropriate department, logs the results in Excel 365, and sends notifications to the responsible team member via Telegram. It helps teams automate email triage, prioritize issues, and ensure that important messages are routed to the correct department without manual sorting. This workflow is designed to be scalable, easy to configure, and adaptable for multiple business use cases such as support management, internal operations, finance monitoring, and technical issue tracking. Features AI-powered email analysis Automatic email categorization Department routing based on AI classification Priority detection (High / Medium / Low) Attachment detection Action-required detection Spam filtering Excel 365 email logging Department contact lookup from Excel Telegram notifications to the responsible team member Modular workflow design for easy extension How It Works Email Trigger The workflow listens for new incoming emails using IMAP, Gmail, or Outlook. Email Data Extraction Key email information such as sender, subject, and body content is extracted and prepared for analysis. Email Body Limiting The email body is truncated to avoid excessive token usage when sending content to the AI model. Batch Processing Emails are processed one by one to prevent rate limits when calling the AI API. AI Email Analysis The email is sent to an AI model that analyzes the message and returns structured JSON data including: summary category priority department attachment detection action required spam detection Department Lookup The workflow looks up the responsible department contact using an Excel 365 sheet that maps departments to their respective PIC (Person in Charge). Email Logging The analyzed email data is appended to an Excel sheet for tracking and auditing. Telegram Notification The responsible department PIC receives a Telegram notification containing the email summary and priority details. Setup Steps Import the Workflow Import the workflow JSON file into your n8n instance. Configure Email Trigger Connect your email account using one of the following: - IMAP - Gmail - Outlook Set the trigger to detect new incoming emails. Configure OpenAI Add your OpenAI API credentials in n8n. The AI model is used to analyze incoming email content and generate structured data such as summary, category, department, and priority. Prepare the Excel File Create an Excel file with two sheets. File example: Email_Automation.xlsx Sheet 1: Email_Log ---------------------------------------------------------------------------------------------------------- Timestamp Sender Subject Category Priority Department Action Attachment Spam Summary Required ----------- -------- --------- ---------- ---------- ------------ ---------- ------------ ------ --------- This sheet stores the processed email records for auditing and tracking. Sheet 2: Department_Routing Department PIC_Name Email Telegram_Chat_ID ------------ ---------- ------------------- ------------------ Support Andi [email protected] 12345678 Sales Rina [email protected] 23456789 Finance Budi [email protected] 34567890 Technical Dodi [email protected] 45678901 Management CEO [email protected] 56789012 General Admin [email protected] 67890123 This sheet maps departments to the responsible team member and their Telegram chat ID. Configure Telegram Create a Telegram Bot and connect it to n8n. Ensure the Telegram Chat IDs in the Excel routing sheet are correct so notifications are delivered to the right person. Configure Excel Credentials Connect your Excel 365 account to n8n and select the Excel file used for logging and department routing. Test the Workflow Send a test email to your monitored inbox. The workflow should: 1. Analyze the email using AI 2. Determine category and department 3. Log the result in Excel 4. Send a Telegram notification to the responsible department Example Output Example AI output: { "summary": "Customer asking about invoice payment status", "category": "Invoice", "priority": "Medium", "department": "Finance", "has_attachment": true, "action_required": true, "spam": false } Example Telegram notification: 📩 New Email Routed Department: Finance\ Priority: Medium From: [email protected]\ Subject: Invoice payment status Summary:\ Customer asking about invoice payment status Action Required: Yes\ Attachment: Yes Requirements n8n OpenAI API key Email account (IMAP / Gmail / Outlook) Microsoft Excel 365 Telegram Bot Customization Ideas You can extend this workflow by adding: - Jira ticket creation for technical issues - Slack or Microsoft Teams notifications - CRM integration for sales leads - sentiment analysis for customer emails - automated support ticket creation - SLA monitoring and escalation Notes This workflow demonstrates how AI can automate email intake, classification, and operational routing for teams. It can be adapted for customer support, internal operations, finance monitoring, and technical issue tracking.