n8n WooCommerce to Google Sheets: Match Prospects

Match WooCommerce products to backlink prospects—and draft outreach emails automatically in n8n

This 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.

What this workflow does

• Runs on a schedule: executes daily at 09:00 (or can be started manually).
• Loads your configuration: store URLs, Google Sheet ID, brand/sender details, and a maximum number of drafts per run.
• Fetches published products from two WooCommerce stores (North America and Europe) and merges them into one product catalog.
• Reads prospects from the “Prospects” tab in your Google Sheet.
• Scores and matches each prospect against the combined WooCommerce catalog using keyword and market matching, selecting the best-matching product.
• Generates outreach drafts (subject + body) including the match score and product details.
• Writes results back by appending drafts to the “Drafts” tab for manual review.

Use cases

• Link building teams who maintain a Google Sheet of backlink prospects and want matched product-based outreach at scale.
• SaaS operators running multiple WooCommerce stores (North America + Europe) and need automated, region-aware outreach.
• Automation engineers building repeatable n8n workflows for prospect-to-content matching and email drafting.

Technical details

• Integrations / nodes: set, code, merge, sticky note, WooCommerce, Google Sheets.
• Credentials needed: read-only WooCommerce API credentials for both stores; Google Sheets OAuth2 credential.
• Required Google Sheet tabs: Prospects and Drafts (Prospects includes columns like status, site_name, email, contact_name, target_url, market, vehicle_focus, etc.).