Ahmed Saadawi
CRM consultant and automation expert with 15+ years of experience building AI-powered, no-code workflows for sales, support, and operations. Open to collaboration or custom solutions β letβs connect!
Categories
Templates by Ahmed Saadawi
Auto-send welcome messages to Vtiger CRM leads via Evolution API WhatsApp
One of My Best! Send WhatsApp Greetings to New Vtiger Leads Automatically πͺπ β οΈ This Workflow Requires a Community Nodes and a Self-Hosted n8n Instance > This template uses two custom community nodes: > * n8n-nodes-vtiger-crm > * n8n-nodes-evolution-api > You must be running self-hosted n8n with Community Nodes enabled. π§ How to Install Community Nodes Go to Settings β Community Nodes Click Install Node Add: bash n8n-nodes-vtiger-crm n8n-nodes-evolution-api Restart n8n if prompted. --- π¬ Auto-Send WhatsApp Welcome Messages to New Leads in Vtiger CRM Overview This workflow sends a personalized WhatsApp welcome message to newly created leads in Vtiger CRM β using Evolution API β and updates the CRM record to ensure the message isnβt sent again. Itβs ideal for teams that want to greet new leads instantly, reduce manual effort, and automate the first touchpoint of the sales process. --- π What This Workflow Does β± Runs every 1 minute via schedule trigger π₯ Fetches the latest uncontacted lead from Vtiger (cf_1090 != 1) π¬ Sends a personalized WhatsApp message using Evolution API β Marks the lead as βmessagedβ by updating a custom field --- πΈ Visual Preview 𧩠Workflow Canvas > Full layout of the automation flow in n8n π¬ Evolution API Server > Example of the greeting message the lead receives: Hi Ahmed Saadawi π, We have received your interest with our services and we will contact you soon. Have a nice day ππ --- π οΈ Setup Instructions Vtiger CRM Setup Add a custom field (e.g. cf_1090) to track if a message was already sent Ensure lead records contain: firstname, lastname, phone Connect your Vtiger CRM API credentials Evolution API Setup Install or connect to your Evolution API instance Configure: instanceName remoteJid (from Vtiger lead phone) Message template (edit as needed) Add your Evolution API credentials Customize Message Edit the message in the Evolution node to match your brandβs tone. --- π₯ Who Is This For? Sales teams needing instant CRM-to-WhatsApp follow-ups Companies automating first contact with leads Vtiger CRM users looking for WhatsApp engagement tools --- π Credentials Required β Vtiger CRM API β Evolution API (self-hosted or SaaS) --- π· Tags vtiger, whatsapp automation, evolution api, crm follow-up, sales automation, welcome message, crm whatsapp integration, lead onboarding, no-code automation, n8n template, self-hosted n8n, vtiger crm automation, community nodes, whatsapp message workflow
By Ahmed SaadawiAutomated MySQL to Google Sheets sync with duplicate prevention
π Sync MySQL Rows to Google Sheet Description: This n8n template automates the process of syncing new records from a MySQL database table into a Google Sheet, ideal for reporting, backup, or lightweight dashboards. It is designed for teams or individuals who need to periodically export new data rows from a custom database (e.g., CRM, registrations, surveys) into a structured Google Sheet for further analysis, sharing, or archivingβwithout duplicates. --- π οΈ What This Workflow Does: Runs every 15 minutes via a schedule trigger. Selects unsynced rows (sync = 0) from a MySQL table (fifa25_customers). Checks if records exist to prevent unnecessary writes. Appends records to a Google Sheet, mapping fields like name, email, phone, gender, and more. Updates the MySQL table to mark those rows as synced (sync = 1) to avoid reprocessing. Fully annotated using sticky notes for easier understanding and onboarding. --- π Setup Instructions: Create or select a Google Sheet and make sure the columns match the following: id, name, phone, birthdate, email, region, gender, datatime Ensure your MySQL table (fifa25_customers) has a sync column (default = 0 for new rows). Connect your MySQL and Google Sheets credentials inside n8n. (Optional): Add custom filtering or column transformations as needed. --- π€ Who Is It For? Marketers syncing leads to a spreadsheet Ops teams pulling user data from internal tools Analysts logging form submissions or customer data Anyone needing lightweight scheduled ETL from MySQL to Sheets --- π Credentials Required: MySQL Google Sheets OAuth2 --- β Best Practices Followed: Uses IF node to prevent unnecessary processing Updates source database to avoid duplicates Includes sticky notes for clarity All columns are explicitly mapped Works out-of-the-box on any n8n instance with proper creds
By Ahmed SaadawiReal-time Vtiger support tickets to Telegram with auto status updates
β οΈ This Workflow Requires a Community Node and a Self-Hosted n8n Instance > This workflow uses the Vtiger CRM community node. To use it, you must be running a self-hosted version of n8n with Community Nodes enabled. π§ How to Install the Node Go to Settings β Community Nodes Click Install Node Enter the package name: bash n8n-nodes-vtiger-crm Restart your n8n instance if prompted --- π¬ Real-time Vtiger Support Tickets to Telegram with Auto Status Updates π Overview Keep your support team instantly informed when new tickets are created in Vtiger CRM. This workflow: Fetches the most recent ticket marked as Open Sends its details to a Telegram chat Updates the status in Vtiger to In Progress to prevent re-sending --- π What This Workflow Does π¨ Pulls the latest open ticket from Vtiger HelpDesk π² Sends a rich-text message to Telegram with all key ticket details π Updates the ticketβs status to "In Progress" --- π§ Workflow Preview > --- π² Telegram Output Example > New ticket with the following details: Ticketid: TT2 Title: Internet down Status: Open Priority: High Severity: Minor Category: Small Problem Description: The internet was slow from yesterday and today is down completely --- π οΈ Setup Instructions π Telegram Bot Setup Open Telegram and search for @BotFather Run /newbot and follow the instructions Save the bot token Add the bot to your chat or group Use @userinfobot to get your chat_id Paste the token and chat ID in the Telegram node inside n8n --- π Vtiger CRM Setup Make sure your Vtiger HelpDesk module includes: ticketno, tickettitle, ticketstatus, ticketpriorities, ticketseverities, ticketcategories, description Connect your Vtiger API credentials inside n8n --- π₯ Who This Is For Customer support and IT helpdesk teams using Vtiger CRM Teams that want instant alerts in Telegram Anyone syncing CRM activity with chat-based notifications --- π Credentials Required β Vtiger CRM API credentials β Telegram Bot Token --- π· Tags vtiger, telegram, crm automation, helpdesk alerts, no-code crm, realtime notifications, n8n telegram integration, support ticket automation, self-hosted n8n, community nodes, workflow automation, vtiger crm integration, helpdesk sync, n8n crm alerts
By Ahmed SaadawiAuto-generate FAQ answers in Vtiger CRM with DeepSeek LLM and LangChain
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. π§ Vtiger CRM β Auto-Answer FAQs with DeepSeek AI Description: This workflow automates the process of answering FAQ drafts in Vtiger CRM using DeepSeek LLM via LangChain. It's perfect for teams who want to accelerate knowledge base creation, improve support response consistency, or reduce the manual effort of writing FAQ content. Every 1 minute, this workflow: π₯ Retrieves the most recent FAQ record marked as Draft in Vtiger CRM π§ Sends the question to a LangChain agent powered by DeepSeek AI π Receives a plain-text answer π€ Updates the original FAQ with the generated answer and changes its status to Published --- βοΈ How It Works Trigger: Scheduled to run every 1 minute Query: Pulls the latest FAQ from Vtiger where faqstatus = 'Draft' AI Agent: Uses LangChain + DeepSeek to generate a natural-language answer Memory Buffer: Keeps context using LangChain memory Update: Pushes the answer back to Vtiger and marks it as Published --- π οΈ Setup Instructions Connect Credentials for: Vtiger CRM API DeepSeek API Ensure your Vtiger CRM has a Faq module with fields: question faq_answer faqstatus Install the required Community Node: Go to Settings β Community Nodes Click Install Node and enter: bash n8n-nodes-vtiger-crm Restart your instance when prompted. Optionally customize the schedule or field names as needed. --- π€ Who Is This For? Customer support teams building a knowledge base Businesses using Vtiger as a CRM or internal helpdesk Teams looking to automate repetitive content creation using LLMs --- π Credentials Required β Vtiger CRM API credentials β DeepSeek AI API key --- β Highlights Fully automated LLM-powered FAQ generation Uses custom community node for Vtiger support Lightweight and runs on a short interval (1 min) Includes sticky note for clarity and onboarding Clean conditional logic and memory context built-in --- π· Tags vtiger, crm, faq automation, ai automation, deepseek, langchain, llm, open source crm, faq generation, customer support, n8n, n8n community nodes, workflow automation, ai generated answers, vtiger integration, deepseek ai, langchain integration
By Ahmed SaadawiWhatsApp message auto-logger for Vtiger CRM with lead relation
Auto-Log WhatsApp Inbound Messages to Vtiger CRM Leads (with WhatsAppLog) --- Description π₯ A Game-Changer for CRM Logging! Automatically Log WhatsApp Inbound Messages to Vtiger and Link to Leads π¬β‘ β οΈ This Workflow Requires Community Nodes & a Self-Hosted n8n Instance > This template uses a custom community node: > * n8n-nodes-vtiger-crm > β No need for an Evolution API node β webhook is used instead. --- π§ How to Install Community Nodes Go to Settings β Community Nodes Click Install Node Add this: n8n-nodes-vtiger-crm Restart n8n if prompted. --- π¬ Automatically Log WhatsApp Inbound Messages in Vtiger CRM Overview This workflow listens for inbound WhatsApp messages via Evolution API Webhook, filters out outbound and group messages, and logs the message in the custom WhatsAppLog module in Vtiger. If the sender is not in CRM, it creates a new lead and links the message. --- π What This Workflow Does π© Listens to WhatsApp inbound messages via webhook π« Filters out group and outbound messages π Looks up existing lead by phone π Creates a new lead if not found π§Ύ Logs the message in the WhatsAppLog module π Relates message to corresponding lead --- π Evolution API Webhook Configuration Open your Evolution API dashboard Go to Events β Webhook Enable Webhook Set the Webhook URL to your n8n webhook path: https://your-n8n-domain/webhook/whatsAppListen Enable only the event: β MESSAGES_UPSERT Disable all other events to avoid unnecessary triggers This ensures only inbound WhatsApp messages are pushed to n8n. > No need to use the Evolution API node in n8n. All communication is triggered via webhook. --- πΈ Visual Preview 𧩠Workflow Canvas > Full view of the automation steps in n8n π¬ WhatsApp Message Capture > A sample inbound message sent to your WhatsApp number --- π οΈ Setup Instructions Vtiger CRM Setup Ensure the Leads module has phone fields (phone or mobile) Create a custom module WhatsAppLog (if not already present) Connect your Vtiger CRM API credentials to n8n Webhook Setup Follow the Webhook Configuration steps above for Evolution API Make sure your n8n instance is publicly accessible Workflow Customization Update field mapping inside the Set and Log nodes Adjust the assigneduserid or custom fields as needed --- π₯ Who Is This For? CRM admins managing WhatsApp communication Sales teams tracking lead interactions in Vtiger Support teams logging WhatsApp tickets Businesses using Evolution API to receive WhatsApp messages --- π Credentials Required β Vtiger CRM API β No Evolution API credentials needed inside workflow (webhook-only) --- π· Tags vtiger, whatsapp, crm automation, inbound message logging, evolution api, whatsapp crm integration, n8n template, community nodes, lead management, self-hosted n8n, customer communication, no-code crm, webhook
By Ahmed SaadawiAutomate WhatsApp sales with DeepSeek AI, Google Sheets and Gmail notifications
Turn WhatsApp Into a 24/7 AI Sales Assistant β n8n + DeepSeek + Sheets + Gmail β οΈ Self-Hosted n8n Only Description Turn your WhatsApp channel into a smart sales assistant! This workflow listens for inbound customer messages, looks up product data in Google Sheets, uses a DeepSeek Chat Model to answer in Saudi dialect, collects purchase details, and notifies your service rep only when the customer is ready to buy. --- π§ How to Install Community Nodes Go to Settings β Community Nodes Click Install Node, then add: bash n8n-nodes-evolution-api Restart n8n if prompted. --- π What This Workflow Does Webhook Listener Captures inbound WhatsApp messages (MESSAGES_UPSERT via Evolution API). Filters Ignores outbound (fromMe) and group (@g.us) messages. Data Extraction Pulls the customerβs message and phone number. AI Response Uses the DeepSeek Chat Model node to answer from your Google Sheets product list, greeting with βΩΩΨ§ ΩΨΊΩΨ§β and speaking in Saudi dialect. Purchase Flow Prompts for name, phone, and delivery/pickup date. Notify Sales Sends an email via Gmail only when the customer requests to purchase. Context Memory (Optional) Stores conversation history in Postgres for coherent multi-turn chats. --- πΈ Visual Preview 𧩠Workflow --- π οΈ Setup Instructions Evolution API Webhook In Evolution API dashboard β Events β Webhook Enable only MESSAGES\_UPSERT Set Webhook URL to: https://your-n8n-domain/webhook/whatsAppListen Google Sheets Create a spreadsheet (βYou Conmanay Name Itemsβ) with your product data [Item name, Item Model, Item Description, Item Components, Item Price, Item Availability, ...] Connect your Google Sheets credentials in n8n DeepSeek Chat Model Configure your DeepSeek API credentials in the DeepSeek Chat Model node Ensure the system prompt matches your companyβs tone and data columns Gmail Notifications Add Gmail OAuth2 credentials to the Send a message in Gmail node Customize subject and email template if needed Postgres Memory (Optional) Connect a Postgres instance in the Postgres Chat Memory node for session context --- π₯ Who Is This For? E-commerce teams automating first-touch customer replies Sales reps needing AI-driven chat support on WhatsApp Businesses using WhatsApp as a primary customer channel --- π Credentials Required Evolution API (webhook only) Google Sheets API DeepSeek API Gmail OAuth2 Postgres (optional, for memory) --- π· Tags whatsapp bot, deepseek, google sheets, evolution api, gmail, postgres memory, ecommerce, sales automation, n8n template, no-code, ai, agent, ai agent
By Ahmed SaadawiBuild a WhatsApp customer support bot with LangChain, OpenAI, and CRM integration
Full Customer Support WhatsApp AI Bot (Self-Hosted, Evolution API) π§βπΌ Whoβs it for This template is for businesses using WhatsApp for customer communication who want to automate support using AI and real-time CRM data β especially in retail, food & beverage, e-commerce, or service sectors. Itβs ideal for self-hosted n8n users with access to OpenAI and a CRM with API endpoints. --- π‘ What It Does This workflow creates a multi-intent AI chatbot that handles WhatsApp conversations and connects to your CRM using HTTP APIs. It uses LangChainβs AI Agent to dynamically classify and respond to customer queries in real time. π Supported Use Cases: π Branch inquiries (nearest location, hours, contact) π° Menu & product info (availability, categories, images) π Order creation & tracking β οΈ Complaint submission and follow-up β Loyalty points lookup β¨ Concierge & custom orders Each user message is routed using AI to the appropriate path, where a tailored system prompt and real-time API call generate a smart, emoji-rich reply. --- π Key Advantages Plug-and-play AI support bot with 6 distinct customer intents No code logic building β uses natural language instructions via LangChain Connects to your CRM using httpRequestTool nodes Smart classification with OpenAI (via LangChain agent) Sticky notes and prompt modularity for easy customization Real-time replies using dynamic data from your API Short, branded, emoji-friendly replies with support for Arabic NLP patterns --- π§ How It Works 𧲠A Webhook (via evolution-api node) receives incoming WhatsApp messages. π§ An AI Router Agent classifies the message intent using GPT-4. π§° Based on the intent, a specific system prompt is injected. π§ A LangChain Agent uses tools (CRM APIs) to fetch data. π¬ A final reply is generated and sent back via WhatsApp. Everything is modular, explainable, and built with clarity in mind using sticky notes and renamed nodes. --- π οΈ Requirements β Self-hosted n8n (required for community nodes) β evolution-api node (for WhatsApp messaging) β OpenAI API Key β Your own CRM HTTP API endpoints for: Order creation/status Menu & category lookup Complaints Branch search Loyalty points --- βοΈ Setup Instructions π Install the evolution-api node via n8n community nodes. π Replace all YOURAUTHORIZATIONTOKEN_HERE with your real credentials. π§ Add your OpenAI credentials in n8n. π οΈ Update all CRM URLs to point to your environment. π² Connect the webhook URL to your WhatsApp provider. --- π¨ How to Customize Edit the intent categories in the AI router prompt. Modify each system prompt for tone, brand, or language (supports Arabic). Add more tools or branches (e.g., shipping, feedback, upselling). Use n8nβs credentials manager for production security. --- π§ User Experience & Design Sticky notes provide full visual explanation of logic. Prompts ensure short, relevant, context-aware replies. User session memory improves continuity across messages. Optimized for performance and ease of onboarding. --- π SEO Tags whatsapp support bot, n8n chatbot, gpt-4 ai support, langchain agent, self-hosted n8n, crm integration, customer support automation, evolution-api, loyalty bot, menu chatbot, orders automation, arabic whatsapp bot, real-time crm bot, openai n8n workflow
By Ahmed Saadawi