{"product_id":"n8n-workflow-woocommerce-prospect-scoring-with-openai","title":"n8n Workflow: WooCommerce Prospect Scoring with OpenAI","description":"\u003ch3\u003eScore WooCommerce editorial prospects with OpenAI—directly into Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e evaluates Google Sheets editorial prospects against the correct \u003cstrong\u003eregional WooCommerce product catalogs\u003c\/strong\u003e (EU and NA), fetches each prospect page’s metadata, and uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a structured relevance score and review-ready pitch angles—then \u003cstrong\u003eupserts results into an Opportunities sheet\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRuns on a \u003cstrong\u003emanual trigger\u003c\/strong\u003e (start workflow when you’re ready to score a batch).\u003c\/li\u003e\n  \u003cli\u003eLoads \u003cstrong\u003epublished WooCommerce products\u003c\/strong\u003e from two stores: \u003cstrong\u003eEU\u003c\/strong\u003e and \u003cstrong\u003eNA\u003c\/strong\u003e, then reads prospect rows from Google Sheets tab \u003cstrong\u003ePending_Leads\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eValidates each prospect using checks such as \u003cstrong\u003eregion\u003c\/strong\u003e, \u003cstrong\u003eURL safety\u003c\/strong\u003e, \u003cstrong\u003erequired fields\u003c\/strong\u003e, and \u003cstrong\u003epermission status\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSelects the \u003cstrong\u003ebest matching product\u003c\/strong\u003e from the correct regional WooCommerce catalog.\u003c\/li\u003e\n  \u003cli\u003eFor valid prospects, fetches the prospect URL’s editorial page HTML and extracts the \u003cstrong\u003e\u0026lt;title\u0026gt;\u003c\/strong\u003e and \u003cstrong\u003emeta description\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalls \u003cstrong\u003eOpenAI\u003c\/strong\u003e with the page metadata, prospect topic, and selected product details to return a JSON response including a \u003cstrong\u003erelevance score\u003c\/strong\u003e, \u003cstrong\u003erationale\u003c\/strong\u003e, \u003cstrong\u003epitch angle\u003c\/strong\u003e, and \u003cstrong\u003eanchor suggestions\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCombines AI relevance with quantitative signals (including \u003cstrong\u003edomain rating\u003c\/strong\u003e and \u003cstrong\u003eorganic traffic\u003c\/strong\u003e) to set a \u003cstrong\u003estatus\u003c\/strong\u003e and \u003cstrong\u003ereview flags\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts\u003c\/strong\u003e each evaluated outcome into Google Sheets tab \u003cstrong\u003eOpportunities\u003c\/strong\u003e using \u003cstrong\u003eopportunity_key\u003c\/strong\u003e; invalid\/unapproved prospects are written with \u003cstrong\u003e“Needs input or permission review”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate editorial lead scoring for outreach pipelines using your existing \u003cstrong\u003eWooCommerce\u003c\/strong\u003e catalogs.\u003c\/li\u003e\n  \u003cli\u003eTurn URL-based prospect research into consistent, review-ready opportunities in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSupport region-specific evaluation by matching EU\/NA catalogs correctly.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ building blocks:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003ehttp request\u003c\/em\u003e, \u003cstrong\u003eWoo Commerce\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e configure WooCommerce credentials for both EU and NA stores and ensure store domains match the host checks used for product permalinks; configure \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e credential.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123169317043,"sku":"N8N-20106","price":67.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/K_oRg8tnPqYE854FqjyS5_CKs2munW.png?v=1790673279","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-woocommerce-prospect-scoring-with-openai","provider":"N8N Commerce","version":"1.0","type":"link"}