n8n Workflow: WooCommerce Prospect Scoring with OpenAI

Score WooCommerce editorial prospects with OpenAI—directly into Google Sheets

This n8n workflow evaluates Google Sheets editorial prospects against the correct regional WooCommerce product catalogs (EU and NA), fetches each prospect page’s metadata, and uses OpenAI to generate a structured relevance score and review-ready pitch angles—then upserts results into an Opportunities sheet.

What this workflow does

• Runs on a manual trigger (start workflow when you’re ready to score a batch).
• Loads published WooCommerce products from two stores: EU and NA, then reads prospect rows from Google Sheets tab Pending_Leads.
• Validates each prospect using checks such as region, URL safety, required fields, and permission status.
• Selects the best matching product from the correct regional WooCommerce catalog.
• For valid prospects, fetches the prospect URL’s editorial page HTML and extracts the <title> and meta description.
• Calls OpenAI with the page metadata, prospect topic, and selected product details to return a JSON response including a relevance score, rationale, pitch angle, and anchor suggestions.
• Combines AI relevance with quantitative signals (including domain rating and organic traffic) to set a status and review flags.
• Upserts each evaluated outcome into Google Sheets tab Opportunities using opportunity_key; invalid/unapproved prospects are written with “Needs input or permission review”.

Use cases

• Automate editorial lead scoring for outreach pipelines using your existing WooCommerce catalogs.
• Turn URL-based prospect research into consistent, review-ready opportunities in Google Sheets.
• Support region-specific evaluation by matching EU/NA catalogs correctly.

Technical details

• Nodes / building blocks: if, code, sticky note, http request, Woo Commerce, Google Sheets.
• Setup: configure WooCommerce credentials for both EU and NA stores and ensure store domains match the host checks used for product permalinks; configure Google Sheets OAuth credential.