Back to Templates

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

Created by

Created by: Alex Berman || alexberman
Alex Berman

Last update

Last update 5 hours ago

Categories

Share

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.