Kanaka Kishore Kandregula
Experienced Magento 2 Developer with 10+ years of expertise in building and optimizing eCommerce solutions. Over the past year, I’ve expanded my skills into workflow automation using n8n, streamlining business processes and integrating systems for efficiency. Passionate about solving complex problems, enhancing performance, and leveraging automation to drive smarter workflows.
Templates by Kanaka Kishore Kandregula
Automatic Magento 2 product & coupon alerts to Telegram with duplicate protection
Boost Sales with Automated Magento 2 Product and Coupon Notifications ---------------------------------------------------- This n8n workflow automatically posts new Magento products & coupons to Telegram while preventing duplicates. Key benefits: ✅ Increase conversions with time-sensitive alerts (creates urgency) ✅ Reduce missed opportunities with 24/7 monitoring ✅ Improve customer engagement through rich media posts ✅ Save hours per week by automating manual posting Why This Works: Triggers impulse buys with real-time notifications Eliminates human error in duplicate posting Scales effortlessly as your catalog grows Provides analytics through database tracking Perfect for e-commerce stores wanting to: Announce new arrivals instantly Promote limited-time offers effectively Maintain consistent social presence Track performance through MySQL This workflow automatically: ✅ Detects new products AND coupons in Magento ✅ Prevents duplicate postings with MySQL tracking ✅ Posts rich formatted alerts to Telegram ✅ Runs on a customizable schedule ✨ Key Features -------------- For Products: Product name, price, and image Direct store link Media gallery support For Coupons: Coupon code and status Usage limits (times used/available) Active/inactive status indicator Core System: 🔒 MySQL duplicate prevention⏰ 1-hour schedule (customizable)📱 Telegram notifications with Markdown 🛠️ Configuration Guide ----------------------- Database Setup CREATE TABLE IF NOT EXISTS posteditems (itemid INT PRIMARY KEY, itemtype ENUM('product', 'coupon') NOT NULL, itemvalue VARCHAR(255), posted BOOLEAN DEFAULT FALSE, createdat TIMESTAMP DEFAULT CURRENTTIMESTAMP, updatedat TIMESTAMP DEFAULT CURRENTTIMESTAMP ON UPDATE CURRENT_TIMESTAMP); Required Credentials Magento API (HTTP Header Auth) MySQL Database Telegram Bot Sticky Notes `❗ IMPORTANT SETUP NOTES ❗ For products: Ensure 'urlkey' exists in customattributes For coupons: Magento REST API must expose coupon rules MySQL user needs INSERT/SELECT privileges Telegram bot must be added to your channel first 🔄 SCHEDULING: - Default: Checks every 1 hours at :00 - Adjust in Schedule Trigger node ` ⚙️ Technical Details -------------------- Workflow Logic: Checks for new products/coupons via Magento API Verifies against MySQL database Only posts if record doesn't exist Updates database after successful post Error Handling: Automatic skip if product/coupon exists Empty result handling Connection timeout protection 🌟 Why This Template? --------------------- Complete Solution: Handles both products AND coupons Battle-Tested: Prevents all duplicates reliably Ready-to-Use: Just add your credentials Fully Customizable: Easy to modify for different needs Perfect for e-commerce stores using Magento 2 who want automated, duplicate-free social notifications!
By Kanaka Kishore KandregulaDaily Magento 2 customer sync to Google Contacts & Sheets without duplicates
Automatically sync newly registered Magento 2 customers to Google Contacts and Google Sheets every 24 hours — with full duplication control and seamless automation. This workflow is a plug-and-play customer contact automation system designed for Magento 2 store owners, marketers, and CRM teams. It fetches customer records registered within the last 24 hours (from 00:00:00 to 23:59:59), checks against an existing Google Sheet to avoid reprocessing, and syncs only the new ones into Google Contacts. This ensures your contact list is always fresh and up to date — without clutter or duplicates. ✅ What This Workflow Does: Automates Customer Syncing Every day, it fetches newly registered Magento 2 customers via API based on the exact date range (midnight to midnight). Deduplicates Using Google Sheets A master Google Sheet tracks already-synced emails. Before adding a customer, the workflow checks this list and skips if already present. Creates Google Contacts Automatically For each unique customer, it creates a new contact in your Google Contacts, saving fields like first name, last name, and email. Logs New Entries to Google Sheets In Google Sheets, it even records magento 2 customer group, createdat, websiteid & store_id After syncing, it adds each new email to the tracking sheet, building a cumulative record of synced contacts. Fully Scheduled & Automated Can be scheduled with the Cron node to run daily (e.g., 12:05 AM) with no manual intervention required. 🔧 Modules Used: HTTP Request (Magento 2 API) Date & Time (for filtering registrations) Google Sheets (for reading/writing synced emails) Google Contacts (for contact creation) Set, IF, and Merge nodes (for control logic) Cron (for scheduling the automation) 💼 Use Cases: Keep your email marketing tools synced with Magento 2 customer data. Build a CRM-friendly contact base in Google Contacts without duplicates. Share customer data with sales or support teams through synced Google Sheets. Reduce manual work and human error in data transfer processes. 🔒 Credentials Required Magento 2 Bearer Auth: Set up as a credential in n8n using your Magento 2 API access token. Google API 📂 Category E-commerce → Magento 2 (Adobe Commerce) 💬 Need Help? 💡 Having trouble setting it up or want to customize this workflow further? Feel free to reach out — I’m happy to help with setup, customization, or Magento 2 API integration issues. Contact: Author 👤 Author Kanaka Kishore Kandregula Certified Magento 2 Developer https://gravatar.com/kmyprojects https://www.linkedin.com/in/kanakakishore
By Kanaka Kishore KandregulaMagento 2 low stock alert via Slack & Gmail (MSI compatible)
Daily Magento 2 stock check Automation It identifies SKUs with low inventory per source and sends daily alerts via: 📬 Gmail (HTML email) 💬 Slack (formatted text message) This automation empowers store owners and operations teams to stay ahead of inventory issues by proactively monitoring stock levels across all Magento 2 sources. By receiving early alerts for low-stock products, businesses can restock before items sell out—ensuring continuous product availability, reducing missed sales opportunities, and maintaining customer trust. Avoiding stockouts not only protects your brand reputation but also keeps your store competitive by preventing customers from turning to competitors due to unavailable items. Timely restocking leads to higher fulfillment rates, improved customer satisfaction, and ultimately, stronger revenue and long-term loyalty. ✅ Features: Filters out configurable, virtual, and downloadable products Uses Magento 2 MSI stock per source Customizable thresholds (default: ≤10 overall or ≤5 per source) HTML-formatted email report Slack notification with a code-formatted Runs daily via Cron (08:50 AM) No need of any 3rd part Modules One time Setup 🔑 Credentials Used HTTP Request (Magento 2 REST API using Bearer Token) Gmail (OAuth2) Slack (OAuth2 or Webhook) 📊 Tags Magento, Inventory, MSI, Stock Alert, Ecommerce, Slack, Gmail, Automation 📂 Category E-commerce → Magento 2 (Adobe Commerce) 👤 Author Kanaka Kishore Kandregula Certified Magento 2 Developer https://gravatar.com/kmyprojects https://www.linkedin.com/in/kanakakishore
By Kanaka Kishore KandregulaMagento maintenance via natural language with GPT and Telegram/WhatsApp
The Magento 2 Smart Maintenance AI Agent revolutionises how you interact with your store’s backend — allowing you to safely run critical maintenance and cache operations using plain natural language via Telegram or WhatsApp. ❗ The Problem Magento store issues never wait for office hours. Caches fill up, indexes break, or maintenance mode gets stuck — usually late at night, during weekends, or right before a campaign launch. Most store owners can’t fix these on their own and must wait for a developer or agency response, causing lost sales, downtime, and stress. 💡 The Solution The Magento 2 Smart Maintenance AI Agent acts as your personal, always-on rescue assistant. It turns your Telegram or WhatsApp chat into a command center — where you can say: “Please clear cache” “Disable maintenance mode” “Reindex catalog search” and instantly receive the correct, safe Magento CLI command. No SSH logins, no technical knowledge, no risk and no long wait chasing developer team. It’s your Magento First-Aid Kit — ready anytime, anywhere — that never runs dangerous commands like setup:upgrade or deploy. More messages like: “please clear full page cache” “reindex catalog search” “enable maintenance mode” “check if my site is under maintenance” and this AI-driven n8n workflow will instantly translate it into the correct and safe bin/magento command, while automatically blocking any risky operations (like setup or deployment). This template empowers developers, agencies, and support teams to manage Magento stores from anywhere — safely, intelligently, and conversationally. 🔍 What It Does: Interprets natural language into Magento CLI commands Supports Telegram and WhatsApp message interfaces Automatically identifies parameters like cache type or indexer name “Clear full page cache” → bin/magento cache:clean full_page “Reindex catalog search” → bin/magento indexer:reindex catalogsearch_fulltext Detects unsafe commands (like setup:upgrade) and returns a warning message Provides fully formatted, Telegram-safe output (no entity parsing errors) Can be integrated with Execute Command, SSH, or Magento APIs for real automation ⚙️ Technical Highlights: Powered by the n8n AI Agent Node (OpenAI or compatible LLM) Smart System Message Prompt ensures strict command safety Natural Language Understanding (NLU) for cache/index type recognition Compatible with Telegram Bot and WhatsApp Cloud API Outputs single-line CLI commands (safe for live chat or automation execution) Modular flow — extendable with triggers, schedulers, or approval gates ✅ Ideal For: Magento 2 developers and DevOps engineers Managed service providers and agencies Support or hosting teams maintaining multiple Magento stores Technical managers wanting safe control via chat eCommerce automation enthusiasts 📈 Why This Matters in the Current Market: As teams move toward AI-driven DevOps, eCommerce maintenance needs to keep pace. Magento remains one of the most powerful yet complex systems — and manual CLI management can be error-prone, slow, and risky. This AI Agent enables: Instant control via Telegram or WhatsApp Production safety through command filtering Parameter intelligence (cache and index targeting) Modern DevOps efficiency via conversational AI 🔧 Modules Used: AI Agent Node (OpenAI / GPT-compatible) Telegram Node WhatsApp Node Function Node Response Formatter Node 💼 Use Cases: Run safe Magento maintenance commands from Telegram or WhatsApp Let your DevOps team trigger safe CLI operations remotely Automate after-hours store operations via chat commands Integrate with monitoring workflows to self-heal caches or reindex automatically Use AI as a conversational Magento control interface 🔒 Credentials Required: OpenAI API Key (or equivalent LLM key) Telegram Bot API Token (for Telegram) WhatsApp Cloud API Credentials (optional, for WhatsApp integration) (Optional) Server credentials for local execution of CLI commands 📂 Category 🧠 AI Agents / 🛒 eCommerce / ⚙️ DevOps Automation / 💬 ChatOps Contact: Author 👤 Author Kanaka Kishore Kandregula Certified Magento 2 Developer https://gravatar.com/kmyprojects https://www.linkedin.com/in/kanakakishore
By Kanaka Kishore KandregulaAutomate your Magento 2 weekly sales & performance reports
Automatically fetches last week’s Magento 2 orders, summarises sales and product performance, logs the data to Google Sheets, and emails a polished report — all without logging into admin or buying extra modules. Perfect for store owners and agencies. ✅ What This Workflow Does: This workflow automatically fetches the last 7 days of orders from your Magento 2 store, summarizes key metrics (orders, revenue, products sold), groups product performance data, generates a Google Sheet with two tabs (Weekly Summary & Product Breakdown), and emails the report to your team in a modern dashboard-style HTML format — all without ever logging into Magento admin. 🔧 Modules Used: 🕒 Schedule Trigger ⚙️ Code (JavaScript) 🌐 HTTP Request 📊 Google Sheets ✉️ Gmail (HTML Email with custom design) 💼 Use Cases: E-commerce store managers who want weekly sales snapshots without logging into Magento 2. Agencies managing multiple Magento clients and reporting to them weekly. Business owners who want automated insights without paying for extra reporting modules. Marketing or growth teams that need product-wise performance regularly in Google Sheets. 🔒 Credentials Required: Magento 2 API (Bearer Token) Google Sheets OAuth2 Gmail OAuth2 (for sending HTML email reports) 📂 Category: E-commerce / Magento 2 / Reporting / Automation ✨ Why This Saves Hours: This workflow replaces manual Magento report exports, repetitive data cleanup, and weekly email formatting. Store managers often waste 1–2 hours/week collecting data — now it takes 0 minutes. Just set it and forget it. You don’t need to buy reporting extensions, log into the admin, or manually touch a spreadsheet again. 🤝 Need a Custom Workflow? If you need this tailored for your own workflow, store, or client — 📩 Let’s connect. I build custom, high-performance n8n automations for e-commerce, growth, and reporting. Contact: Author 👤 Author Kanaka Kishore Kandregula Certified Magento 2 Developer https://gravatar.com/kmyprojects https://www.linkedin.com/in/kanakakishore
By Kanaka Kishore KandregulaAuto-generate SEO meta descriptions & keywords for Magento 2 with GPT-4.1 & LangChain
This workflow intelligently regenerates meta descriptions and meta keywords for Magento 2 product pages using OpenAI and SEO best practices. 🔍 What It Does: Accepts SKU input via a public form Fetches the product by SKU from your Magento 2 store Extracts existing description, meta description, and keywords Uses a LangChain-powered AI Agent with OpenAI to: Analyze the current product content Generate a high-conversion meta description (150–160 characters) Generate 5–7 optimized SEO meta keywords (while retaining existing ones, avoiding duplicates) Updates the product's metadata in Magento via REST API ⚙️ Technical Highlights: Magento 2 REST integration FormTrigger node for user input Add Role so AI know the Tone of you JavaScript code node for safe HTML parsing LangChain AI Agent with OpenAI (GPT-4.1 mini) Structured output parser to format AI response Automatically pushes updated metadata back into Magento 🧪 Optional: SerpAPI (plug-and-play support included but disabled) can be enabled to bring real-time search trend data into the AI prompt. ✅ Ideal For: Magento 2 store owners, developers, and SEO teams who want to automate metadata updates and boost search performance without touching product pages manually. How This AI Automation Workflow Helps Magento 2 Store Owners Stay Ahead Automates SEO Meta Updates at Scale Manually updating meta descriptions and keywords across hundreds or thousands of products is time-consuming and error-prone. This AI-driven workflow automatically reads the current product descriptions, analyzes SEO opportunities, and generates optimized meta keywords and descriptions — all without manual copywriting. This saves significant time and labor while keeping your SEO metadata fresh. Uses AI to Align with Latest Search Trends The workflow integrates with live search trend data (via SerpAPI or other tools) so that generated meta keywords and descriptions incorporate current popular search queries, trending phrases, and relevant semantic keywords. This ensures your product pages rank better by tapping into what buyers are actively searching for right now. Improves Search Engine Rankings and Click-Through Rates (CTR) Well-optimized meta descriptions that include power words, clear calls to action, and keyword clustering help improve Google’s understanding of your pages and entice more clicks from search results. This drives more organic traffic and increases the chance visitors convert into customers. Maintains Brand Authority and Trustworthiness The AI prompt is designed to follow Google’s E-A-T guidelines (Expertise, Authoritativeness, Trustworthiness), ensuring your product metadata builds credibility. Consistent, accurate meta descriptions contribute to a professional brand image and help improve SEO reputation. Keeps Magento Store Metadata Consistent and Up-to-Date Product content changes frequently—new features, specifications, or uses arise. This workflow allows easy regeneration of SEO metadata after product updates or on-demand, so your Magento store’s search snippets never become outdated or irrelevant. Simple Integration with Magento 2 API and Your Existing Workflow Since the automation fetches and updates product meta fields via Magento’s REST API, it works seamlessly with your current Magento setup without heavy manual work or additional plugins. This smooth integration minimizes technical complexity. Why This Matters in the Current Market SEO remains a top driver of online sales — with evolving algorithms and user search behaviors, staying current and relevant in metadata is essential for visibility. Voice search, mobile search, and semantic search make keyword strategy more complex; AI-powered semantic keyword clustering simplifies this. E-commerce competition is fierce — automated, data-driven SEO optimizations give you an edge over stores relying on static, outdated meta descriptions. Content automation is becoming a necessity — businesses using AI for SEO benefit from faster iteration and more consistent messaging, helping them capture shifting consumer trends. Summary This AI + Automation + Workflow approach enables Magento 2 store owners to continuously and efficiently optimize their product metadata, leveraging live market data and SEO best practices to boost organic rankings, attract more visitors, and increase conversions — all while reducing manual workload.
By Kanaka Kishore KandregulaMagento 2: auto-fix missing image alt tags with product name
This n8n workflow connects to a Magento 2 store and automatically updates product images that are missing alt tags (labels). It fetches product data via the Magento 2 REST API, identifies media gallery entries with empty or null labels, and updates them by assigning the corresponding product name as the alt text. This is useful for: Improving SEO and accessibility by ensuring all product images have descriptive alt tags. Automating manual content cleanup tasks for product catalogs. Keeping your store compliant with basic accessibility and usability standards. ⚙️ How It Works Manual Trigger The workflow is designed to run manually or on a schedule (can be modified). Fetch Product Data The Get All Product Skus HTTP node pulls a paginated list of products using Magento's REST API The Split Out and Loop Over Items nodes iterate through each product. Filter Products With Images The If node checks if a product has at least one image. Label Missing Alt Texts The Code node inspects each image's label field. If it's empty or null, it sets it to the product’s name. Update Back to Magento 2 The HTTP Request (PUT) node updates each product using Magento’s V1/products/:sku endpoint, sending the updated image labels back to the store. 🧠 Use Case Problem: Magento 2 stores often have hundreds or thousands of product images, and it’s common to miss assigning alt text (label) to all of them—especially for bulk-imported or older products. Solution: This workflow ensures every product image has an alt label (minimum: product name), thus improving: Search engine optimization (SEO) Product discovery Accessibility compliance (WCAG) Store quality score (for marketplaces or audits) 🧪 Requirements Magento 2 REST API access A valid Bearer Token for Magento 2 Magento endpoint URL Basic understanding of how your store handles image paths and media entries 🔒 Credentials Required Magento 2 Bearer Auth: Set up as a credential in n8n using your Magento 2 API access token. 🛠️ Modifications You Can Make Increase the pageSize in the GET request to process more products per run. Set up a Cron trigger to run this regularly. Update other missing fields like position, disabled, or types programmatically. Include logging or email notifications after each batch update. 🧰 Helpful For Magento Developers & Store Managers SEO/Accessibility Compliance Teams Automation Engineers managing eCommerce workflows 📂 Category E-commerce → Magento 2 (Adobe Commerce) 💬 Need Help? 💡 Having trouble setting it up or want to customize this workflow further? Feel free to reach out — I’m happy to help with setup, customization, or Magento 2 API integration issues. Contact: Author 👤 Author Kanaka Kishore Kandregula Certified Magento 2 Developer https://gravatar.com/kmyprojects https://www.linkedin.com/in/kanakakishore
By Kanaka Kishore KandregulaWeekly Magento 2 stuck order reporting with Gmail & Google Sheets
Automatically identifies and reports Magento 2 orders stuck for the past 7 business days. Sends a weekly email alert to the store manager with a Google Sheets report, helping streamline order follow-ups and prevent fulfilment delays. 🔍 What It Does: This n8n automation identifies Magento 2 orders that have been stuck in the same status (like "processing") for the past 7 weekdays (excluding weekends), compiles them into a clean Google Sheet report, and emails the store manager every Monday morning with a snapshot and link to the full data for immediate action. ⚙️ Technical Highlights: Automatically runs every Monday at 8 AM using the Schedule Trigger. Dynamically calculates business days only (excluding weekends) to identify stale orders. Fetches order data using Magento 2 REST API. Filters and formats key details like customer name, order value, phone, and email. Stores the data in a Google Sheet titled with the current date. Sends a professionally formatted HTML email to the manager with: A summary table of stuck orders. A button linking directly to the full Google Sheet report. ✅ Ideal For: Magento 2 store owners/managers who need better visibility on stuck or delayed orders. Operations teams who want to avoid lost revenue or customer complaints due to order inaction. Automation engineers looking to integrate Google Workspace and Magento efficiently using n8n. 📈 Why This Matters in the Current Market: In e-commerce, stuck orders = lost trust and lost revenue. As fulfillment expectations continue to rise, proactively managing delayed or idle orders is crucial. This workflow empowers store managers to act fast, reduce manual monitoring, and keep operations smooth — all while preserving customer satisfaction and operational reputation. 🔧 Modules Used: Schedule Trigger HTTP Request (Magento 2 REST API) Code (JavaScript logic for date filtering, formatting) Google Sheets (Create & Append rows) Gmail (Send custom HTML email) Set/Get Logo (optional media path fetch for branding) 💼 Use Cases: Weekly operational check-ins for stuck orders. Root cause analysis of order processing delays. Escalation trigger for order fulfillment teams. Dashboard data feed for pending revenue reports. Enhance Magento store manager awareness with automation. 🔒 Credentials Required: Magento 2 Bearer Auth (Admin API access) Google Sheets OAuth2 (Access to Google Drive & Sheets) Gmail OAuth2 (Authorized sender account) 📂 Category: Magento 2 / E-Commerce Automation / Order Management / Reporting 💬 Need Help? If you'd like help customizing this for your Magento store, such as: Filtering by specific order statuses Adding Slack/Telegram alerts Multi-store/multi-manager support Feel free to reach out — we can assist in tailoring the workflow to your unique business logic. Contact: Author 👤 Author Kanaka Kishore Kandregula Certified Magento 2 Developer https://gravatar.com/kmyprojects https://www.linkedin.com/in/kanakakishore
By Kanaka Kishore Kandregula