{"product_id":"n8n-woocommerce-to-google-sheets-match-prospects","title":"n8n WooCommerce to Google Sheets: Match Prospects","description":"\u003ch3\u003eMatch WooCommerce products to backlink prospects—and draft outreach emails automatically in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls published products from two WooCommerce stores, matches them to backlink prospect rows in Google Sheets, and generates personalized outreach email drafts—saved back to Google Sheets for human review. Run it daily (09:00) or trigger it manually, so your link outreach pipeline stays fresh without manual copy-paste work.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e: executes daily at \u003cstrong\u003e09:00\u003c\/strong\u003e (or can be started manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your configuration\u003c\/strong\u003e: store URLs, Google Sheet ID, brand\/sender details, and a maximum number of drafts per run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches published products\u003c\/strong\u003e from \u003cstrong\u003etwo WooCommerce stores\u003c\/strong\u003e (North America and Europe) and merges them into one product catalog.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads prospects\u003c\/strong\u003e from the \u003cstrong\u003e“Prospects”\u003c\/strong\u003e tab in your Google Sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores and matches\u003c\/strong\u003e each prospect against the combined WooCommerce catalog using \u003cstrong\u003ekeyword and market matching\u003c\/strong\u003e, selecting the best-matching product.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates outreach drafts\u003c\/strong\u003e (subject + body) including the match score and product details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results back\u003c\/strong\u003e by appending drafts to the \u003cstrong\u003e“Drafts”\u003c\/strong\u003e tab for manual review.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLink building teams who maintain a Google Sheet of backlink prospects and want matched product-based outreach at scale.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators running multiple WooCommerce stores (North America + Europe) and need automated, region-aware outreach.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building repeatable n8n workflows for prospect-to-content matching and email drafting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes\u003c\/strong\u003e: set, code, merge, sticky note, \u003cstrong\u003eWooCommerce\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCredentials needed\u003c\/strong\u003e: read-only WooCommerce API credentials for both stores; Google Sheets OAuth2 credential.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired Google Sheet tabs\u003c\/strong\u003e: \u003cstrong\u003eProspects\u003c\/strong\u003e and \u003cstrong\u003eDrafts\u003c\/strong\u003e (Prospects includes columns like status, site_name, email, contact_name, target_url, market, vehicle_focus, etc.).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46058939089075,"sku":"N8N-19703","price":8.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bvHXjGdfuDgzKyYF29hta_2Q5rJU4x.png?v=1789722190","url":"https:\/\/buyflowscripts.com\/products\/n8n-woocommerce-to-google-sheets-match-prospects","provider":"N8N Commerce","version":"1.0","type":"link"}