AI-Driven WooCommerce Product Importer with SEO
Configured with Chain LLM, Google Sheets, LM Chat Open Router, Output Parser Structured, and additional nodes. Review the connections and setup before adapting this template.
Node categories in this workflow
- Trigger
- AI & models
- Data store
- Code
- Integration
- Routing
- Messaging
- Transform
Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.
Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.
How it works
The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.
| Node | Category | Type | Operation |
|---|---|---|---|
| When clicking ‘Test workflow’ | Trigger | Manual Trigger | See node parameters |
| OpenRouter Chat Model | AI & models | LM Chat Open Router | See node parameters |
| SEO Expert | AI & models | Chain LLM | See node parameters |
| Get products | Data store | Google Sheets | See node parameters |
| Map categories | Code | Code | See node parameters |
| Create product | Integration | Woo Commerce | product / create |
| Creation done | Data store | Google Sheets | update |
| Update meta | Data store | Google Sheets | update |
| Set SEO meta | Integration | Woo Commerce | product / update |
| Loop products | Routing | Loop Over Items | See node parameters |
| Send message | Messaging | Telegram | See node parameters |
| Structured Output Parser | Transform | Output Parser Structured | See node parameters |
Setup
- Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
- Connect your own credentials through n8n’s credential store. Replace
REPLACE_WITH_*values with your resource identifiers. - Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
- Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.
Requirements
An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.
Credential types declared in the source
googleSheetsOAuth2ApiopenRouterApitelegramApiwooCommerceApi
Workflow notes
STEP 1
STEP 1
- Install Yoast SEO Plugin on Wordpress
- Add this code in function.php file
function abilita_yoast_meta_api() {
$meta_keys = ['_yoast_wpseo_title', '_yoast_wpseo_metadesc'];
foreach ($meta_keys as $meta_key) {
register_post_meta('post', $meta_key, array(
'type' => 'string',
'description' => "Meta Yoast $meta_key per i post",
'single' => true,
'show_in_rest' => true,
));
register_post_meta('page', $meta_key, array(
'type' => 'string',
'description' => "Meta Yoast $meta_key per le pagine",
'single' => true,
'show_in_rest' => true,
));
}
}
add_action('init', 'abilita_yoast_meta_api');
STEP 3
STEP 3
- Copy this sheet and add product details to be inserted in columns A to I IMPORTANT:
- Columns B, E and F in "text format"
- Column I in "numeric format"
- Columns G and H accepts HTML
- In Column C insert the URL of product image
STEP 2
STEP 2
- Enable WooCommerce API from Wordpress
- Add CHAT_ID in Telegram trigger
AI-Driven WooCommerce Product Importer
AI-Driven WooCommerce Product Importer
This workflow streamlines your WooCommerce product creation process by integrating directly with Google Sheets. Simply input product details into your spreadsheet, and the workflow takes care of the rest—automatically creating new products on your WooCommerce store.
But it doesn’t stop there. A dedicated SEO expert chain analyzes each product’s content and generates optimized meta titles and meta descriptions, enhancing visibility and ranking potential on search engines.
AI-Driven WooCommerce Product Importer with SEO
AI-Driven WooCommerce Product Importer with SEO
Purpose and structure
This folder contains the AI-Driven WooCommerce Product Importer with SEO workflow. Its executable nodes use chainLlm, code, googleSheets, lmChatOpenRouter, manualTrigger, outputParserStructured, splitInBatches, telegram, wooCommerce. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.
Setup
Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.
Entry points
When clicking ‘Test workflow’
Verification
Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.
Attribution
https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Telegram/1775_Telegram_Code_Import_Triggered.json MIT; preserve source notices.