{"product_id":"n8n-workflow-score-woocommerce-editorial-prospects-w-openai","title":"n8n Workflow: Score WooCommerce Editorial Prospects w\/ OpenAI","description":"\u003ch3\u003eScore WooCommerce editorial prospects with OpenAI—automatically prioritize what to review\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads pending WooCommerce editorial prospects from Google Sheets, matches each prospect to the best-fit EU or NA WooCommerce product, fetches the prospect page metadata, and uses the OpenAI Chat Completions API to generate a structured relevance score and review guidance—then upserts a prioritized record back into Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on manual start\u003c\/strong\u003e inside n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches published products\u003c\/strong\u003e from two WooCommerce stores—\u003cstrong\u003eEU\u003c\/strong\u003e and \u003cstrong\u003eNA\u003c\/strong\u003e—and reads \u003cstrong\u003epending prospects\u003c\/strong\u003e from a Google Sheets tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates each prospect\u003c\/strong\u003e (including region alignment, permission status, and a safe public URL) before taking further action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches to a regional product\u003c\/strong\u003e using text-matching against the best-fit EU\/NA WooCommerce product.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequests the target prospect URL\u003c\/strong\u003e and extracts \u003cstrong\u003epage title\u003c\/strong\u003e and \u003cstrong\u003emeta description\u003c\/strong\u003e from the HTML response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores editorial relevance with OpenAI\u003c\/strong\u003e: sends page metadata plus matched product context to the OpenAI Chat Completions API to receive \u003cstrong\u003eJSON output\u003c\/strong\u003e including a relevance score, rationale, pitch angle, and suggested anchors.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSets review status and writes to Google Sheets\u003c\/strong\u003e by combining the OpenAI relevance score with sheet-provided domain rating and traffic inputs—then \u003cstrong\u003eappends or updates\u003c\/strong\u003e the opportunity in the \u003cstrong\u003eOpportunities\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003eIf a prospect is \u003cstrong\u003einvalid\/unapproved\/unsafe\u003c\/strong\u003e or if metadata fetch fails, the workflow \u003cstrong\u003eskips the AI step\u003c\/strong\u003e and writes a \u003cstrong\u003eflagged record\u003c\/strong\u003e for manual follow-up.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEditorial teams want a \u003cstrong\u003erepeatable n8n workflow\u003c\/strong\u003e to prioritize prospect outreach based on page metadata and product fit.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing \u003cstrong\u003eEU\/NA WooCommerce\u003c\/strong\u003e catalogs need automated prospect-to-product matching and scoring.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers require an audit-friendly pipeline that logs \u003cstrong\u003eflagged prospects\u003c\/strong\u003e when URLs or permissions can’t be verified.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth credential, reads pending prospects, writes\/appends into the \u003cstrong\u003eOpportunities\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWooCommerce\u003c\/strong\u003e: credentials for both EU and NA stores; fetches published products for matching.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e: pulls the prospect page HTML and extracts title\/meta description.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI Chat Completions\u003c\/strong\u003e: returns structured JSON scoring, rationale, pitch angle, and suggested anchors.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n logic nodes\u003c\/strong\u003e (e.g., if\/code\/sticky note) to validate prospects and control when the AI step runs.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146409365683,"sku":"N8N-20224","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ACaQNefdly-Vxl8E69yiY_4LY4ooP6.png?v=1790846676","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-score-woocommerce-editorial-prospects-w-openai","provider":"N8N Commerce","version":"1.0","type":"link"}