Skip to main content

Scrape WooCommerce store leads with ScraperCity and sync verified contacts to Airtable

Workflow preview

Scrape WooCommerce store leads with ScraperCity and sync verified contacts to Airtable preview
Open on n8n.io
n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER Hostinger Early Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

Overview

Who is this for

This template is for sales teams, lead generation agencies, and growth marketers who want to build targeted lists of WooCommerce store owners -- complete with verified emails, phone numbers, and social profiles -- and have those contacts automatically land in Airtable for outreach or CRM workflows.

How it works

  1. A manual trigger starts the workflow and a configuration node lets you set your target country, lead volume, and which data points to collect (emails, phones).
  2. A POST request to the ScraperCity store-leads API kicks off an async scrape job targeting WooCommerce stores and returns a runId.
  3. The workflow enters a polling loop -- waiting 60 seconds between each status check -- until the ScraperCity job reports SUCCEEDED.
  4. Once complete, the results CSV is downloaded via the ScraperCity download endpoint.
  5. A Code node parses the CSV, cleans the data, and deduplicates records by email address.
  6. A filter removes rows missing both email and phone, keeping only actionable contacts.
  7. Each verified contact is upserted into an Airtable base, ready for outreach.

How to set up

  1. Create a ScraperCity account at scrapercity.com and copy your API key.
  2. In n8n, create an HTTP Header Auth credential named ScraperCity API Key with the header Authorization: Bearer YOUR_KEY.
  3. Create an Airtable personal access token credential in n8n.
  4. Open the Configure Scrape Parameters node and set your country code, lead volume, and Airtable base/table IDs.
  5. Click Execute workflow to run.

Requirements

  • ScraperCity account (store-leads product)
  • Airtable account with a base containing columns: Name, Website, Email, Phone, Instagram, Facebook, Country
  • n8n instance (cloud or self-hosted)

How to customize the workflow

  • Change platform in the config node from woocommerce to shopify to target Shopify stores instead.
  • Adjust totalLeads to scrape more or fewer contacts per run.
  • Add a Filter node after the Code node to restrict results to stores with Instagram profiles only.
  • Replace the Airtable output node with HubSpot, Google Sheets, or Notion to match your CRM stack.
  • Attach a Schedule Trigger to run the scrape weekly for ongoing lead generation.