This article provides a complete, practical walkthrough of the Telegram Code Import Triggered n8n agent. It connects HTTP Request, Webhook across approximately 1 node(s). Expect a Intermediate setup in 15-45 minutes. One‑time purchase: €29.

What This Agent Does

This agent orchestrates a reliable automation between HTTP Request, Webhook, handling triggers, data enrichment, and delivery with guardrails for errors and rate limits.

It streamlines multi‑step processes that would otherwise require manual exports, spreadsheet cleanup, and repeated API requests. By centralizing logic in n8n, it reduces context switching, lowers error rates, and ensures consistent results across teams.

Typical outcomes include faster lead handoffs, automated notifications, accurate data synchronization, and better visibility via execution logs and optional Slack/Email alerts.

How It Works

The workflow uses standard n8n building blocks like Webhook or Schedule triggers, HTTP Request for API calls, and control nodes (IF, Merge, Set) to validate inputs, branch on conditions, and format outputs. Retries and timeouts improve resilience, while credentials keep secrets safe.

Third‑Party Integrations

• HTTP Request
• Webhook

Import and Use in n8n

1. Open n8n and create a new workflow or collection.
2. Choose Import from File or Paste JSON.
3. Paste the JSON below, then click Import.
4. Show n8n JSON

   Title:
   Turbocharge Your WooCommerce Store: Automated AI Product Importer with SEO Optimization Using n8n
   
   Meta Description:
   Learn how this n8n workflow automates WooCommerce product creation from Google Sheets, powered by AI-driven SEO and real-time notifications via Telegram.
   
   Keywords:
   WooCommerce automation, n8n workflow, AI SEO optimization, product importer, Google Sheets to WooCommerce, OpenRouter, LangChain, Yoast SEO, Gemini model, WooCommerce API, Telegram integration
   
   Third-Party APIs Used:
   
   1. Google Sheets API – for reading and updating product data
   2. WooCommerce API – for creating and updating products on your WooCommerce store
   3. OpenRouter API – for accessing language models such as Gemini 2.0 via OpenRouter
   4. Telegram Bot API – for sending completion notifications
   5. LangChain (LLM & Structured Output Parser) – for generating and parsing SEO meta titles and descriptions based on product content
   
   Article:
   
   AI-Driven WooCommerce Product Importer: How to Automate Store Management and SEO with n8n
   
   Managing an eCommerce store means juggling multiple tasks—sourcing products, updating listings, tracking stock, and making sure your pages rank well on Google. This becomes increasingly complex as your store scales. That’s where automation steps in.
   
   Meet the AI-Driven WooCommerce Product Importer with SEO: an n8n-powered workflow designed to automate the entire product creation pipeline—from taking product data from Google Sheets to uploading optimized product listings into your WooCommerce store, complete with AI-generated meta tags. All hands-free.
   
   This article offers a behind-the-scenes look at how this workflow works and how it can completely transform your store management.
   
   🧠 The Workflow in a Nutshell
   
   This n8n workflow takes product entries you input into a Google Sheet and then:
   
   1. Imports and formats product data
   2. Creates a new WooCommerce product
   3. Generates SEO meta data using advanced AI
   4. Applies the optimized SEO data to the product via WooCommerce
   5. Updates the spreadsheet to flag the action as completed
   6. Sends a Telegram message to notify you
   
   Let’s break it down step-by-step.
   
   📥 Step 1: Product Input in Google Sheets
   
   Everything starts in a Google Sheet designed to capture key product information: title, SKU, prices, descriptions, image URL, stock quantity, and categories. One column labeled “DONE” is used to mark which products have already been processed to avoid duplication.
   
   🧮 Step 2: Processing and Formatting
   
   When you trigger the workflow in n8n (either manually or on schedule), it reads the new rows in your Google Sheet using the Google Sheets API. Before sending the data to WooCommerce, the workflow maps and validates category IDs with a custom code node to ensure compatibility with the store's category taxonomy.
   
   🛍️ Step 3: WooCommerce Product Creation
   
   Now the magic happens. Using WooCommerce’s API—connected with the user’s credentials—the workflow creates a new product entry. It fills in all provided fields including SKU, pricing, inventory, images, short and long descriptions, and categorization.
   
   ⚙️ Step 4: AI-Generated SEO Meta Tags
   
   But we don’t stop at basic product creation.
   
   SEO is critical for discoverability and sales. So, the workflow makes an intelligent call to OpenRouter’s Gemini 2.0 language model via LangChain, feeding it the full product content.
   
   Using a finely-tuned prompt engineered in the workflow, the AI acts as an SEO expert, generating:
   
   - A meta title (≤60 characters)
   - A meta description (≤160 characters)
   
   This task isn’t purely generative. The AI is instructed to analyze the content, identify the primary keyword and search intent, and ensure both pieces of metadata are optimized for click-through rate and search engine indexing.
   
   The structured output is then parsed using LangChain’s Structured Output Parser node to maintain API compatibility and data quality.
   
   🏷️ Step 5: SEO Injection into WooCommerce (Yoast Fields)
   
   For the SEO metadata to be effective, it must be stored in the proper fields. This setup assumes Yoast SEO is installed on your WooCommerce store and includes a small plugin tweak to expose Yoast meta fields (_yoast_wpseo_title and _yoast_wpseo_metadesc) via the REST API. That’s achieved using a snippet added to functions.php (as described in the workflow's sticky notes).
   
   The workflow then updates each product with the generated SEO values using the WooCommerce API.
   
   📊 Step 6: Update Google Sheets and Notify via Telegram
   
   Once a product is successfully created, the workflow updates the Google Sheet:
   
   - Marks the "DONE" column with an “x”
   - Inserts the WooCommerce product ID and permalink
   - Adds the generated meta title and description for reference
   
   Finally, a Telegram message is automatically sent to your specified chat ID, letting you know that the product creation is complete—closing the feedback loop in real time.
   
   🔌 Dependencies and Integrations
   
   This workflow beautifully ties together several powerful services:
   
   - Google Sheets: For product data input and log tracking
   - WooCommerce API: Creating products and injecting SEO metadata
   - OpenRouter + Gemini (LangChain): AI-powered content generation
   - LangChain Structured Output Parser: Ensures clean, usable AI data
   - Telegram Bot API: Real-time notifications to your device
   
   🛠️ Setup Requirements
   
   To get started, you need to:
   
   1. Enable WooCommerce REST API and install Yoast SEO
   2. Add a PHP snippet to expose Yoast meta fields via REST
   3. Connect your Google Account and WooCommerce credentials in n8n
   4. Insert your Telegram chat ID for alerts
   5. Input product data into the prepared Google Sheet format
   
   🚀 Conclusion
   
   Whether you're a solo entrepreneur or managing a team, the AI-Driven WooCommerce Product Importer Workflow in n8n can save you hours of manual work. It doesn’t just push content—it generates optimized, SEO-rich product listings that increase visibility and are ready to sell.
   
   Automate your way to eCommerce growth—with intelligence, precision, and zero busywork.
   
   Want to try it? Make a copy of the provided Google Sheet, modify your store as instructed, and launch the workflow inside your n8n instance. Happy automating!
   
   

5. Set credentials for each API node (keys, OAuth) in Credentials.
6. Run a test via Execute Workflow. Inspect Run Data, then adjust parameters.
7. Enable the workflow to run on schedule, webhook, or triggers as configured.

Tips: keep secrets in credentials, add retries and timeouts on HTTP nodes, implement error notifications, and paginate large API fetches.

Validation: use IF/Code nodes to sanitize inputs and guard against empty payloads.

Why Automate This with AI Agents

AI‑assisted automations offload repetitive, error‑prone tasks to a predictable workflow. Instead of manual copy‑paste and ad‑hoc scripts, your team gets a governed pipeline with versioned state, auditability, and observable runs.

n8n’s node graph makes data flow transparent while AI‑powered enrichment (classification, extraction, summarization) boosts throughput and consistency. Teams reclaim time, reduce operational costs, and standardize best practices without sacrificing flexibility.

Compared to one‑off integrations, an AI agent is easier to extend: swap APIs, add filters, or bolt on notifications without rewriting everything. You get reliability, control, and a faster path from idea to production.

Best Practices

• Credentials: restrict scopes and rotate tokens regularly.
• Resilience: configure retries, timeouts, and backoff for API nodes.
• Data Quality: validate inputs; normalize fields early to reduce downstream branching.
• Performance: batch records and paginate for large datasets.
• Observability: add failure alerts (Email/Slack) and persistent logs for auditing.
• Security: avoid sensitive data in logs; use environment variables and n8n credentials.

FAQs

Can I swap integrations later? Yes. Replace or add nodes and re‑map fields without rebuilding the whole flow.

How do I monitor failures? Use Execution logs and add notifications on the Error Trigger path.

Does it scale? Use queues, batching, and sub‑workflows to split responsibilities and control load.

Is my data safe? Keep secrets in Credentials, restrict token scopes, and review access logs.