Skip to content

Sales email lead scraping instructions for Sophie

Install the Chrome Google Maps scraping extension

Prerequisites

  • Google Chrome browser
  • Airtable Personal Access Token with data.records:write scope
  • Access to the Sales emails base in Airtable

Step 1: Download the extension

  1. Create a new folder named in your root (C:) directory, named “MCC_scraper”
  2. Download the zip file containing the extension to the above directory
  3. Unzip it

You should now have a folder named "Google Maps search results scraper Chrome extension" containing:

  • manifest.json
  • popup.html
  • popup.js
  • options.html
  • options.js
  • icons/ folder

Step 2: Install in Chrome

  1. Open Chrome and navigate to chrome://extensions/
  2. Enable Developer mode (toggle in top-right corner)
  3. Click Load unpacked
  4. Navigate to C:\MCC_scraper\
  5. Click the Google Maps search results scraper Chrome extension folder (single click to highlight, don't double-click)
  6. Click Select Folder
  7. The extension icon won't immediately appear in your toolbar. You first have to navigate to it using the puzzle piece tool, and toggle the pin control to pin the extension to your toolbar:
  8. The extension icon should appear in your toolbar

Step 3: Configure Airtable settings

  1. Right-click the extension icon in your toolbar
  2. Select Options
  3. Enter the following:
Field Value
Airtable Personal Access Token patCgzwikWczEQ7KV.17e94a97d48232c0eb996e041d51b38a07886525d753484013040395492fecc4
Airtable Base ID appDaFRJSxle3TqBA
Airtable Table ID tblQ8VYyUg1LsFKL1
  1. Click Save Settings

Install the Python email scraper

Step 1: Install Python

  1. Go to python.org/downloads
  2. Download the latest Python 3.x installer for Windows
  3. Run the installer
  4. IMPORTANT : Tick the checkbox "Add Python to PATH" at the bottom of the first screen
  5. Click Install Now
  6. Wait for installation to complete, then click Close
Verify Python installed correctly
  1. Open Command Prompt (press Win + R , type cmd , press Enter)
  2. Type python --version and press Enter
  3. You should see something like Python 3.12.0

If you see an error, Python wasn't added to PATH. Uninstall and reinstall, making sure to tick "Add Python to PATH".

Step 2: Download the script files

  1. If you haven’t already, create a new folder named in your root (C:) directory, named “MCC_scraper”
  2. Download the Scrape_email zip file to that folder
  3. Unzip it

The unzipped folder should contain:

  • scrape_emails.py - The main script
  • config.txt - Configuration file
  • README.md - Documentation

Step 3: Install Playwright

  1. Open Command Prompt as Administrator:
  2. Press Win + S , type cmd
  3. Right-click Command Prompt and select Run as administrator
  4. Click Yes if prompted
  5. Run the following commands one at a time:
pip install playwright

Wait for it to finish, then run:

playwright install chromium

This downloads the Chromium browser (~150MB). Wait for it to complete.

Scrape leads from Google Maps

  1. Search Google Maps for prospective leads (e.g., "childcare chatswood") as guided by Glenn/Jordan
  2. Open Chrome Extension by clicking the Google Maps Lead Scraper extension icon
  3. Select campaign — Select the target Instantly campaign from the dropdown (campaigns are fetched from Airtable's 'Instantly campaigns' table)
  4. Click Scrape — Extension opens each result’s details tile, and scrapes the following fields :
  5. Business name
  6. Address
  7. Street (parsed from address)
  8. Suburb / city (parsed from address)
  9. Post code
  10. Website
  11. Phone
  12. In-extension deduplication — Extension dedupes by business name within a single scrape (prevents duplicate sponsored listings)
  13. Save to Airtable — Click "Save to Airtable", which pushes records to the 'Leads scraped from Google Maps' table in the Sales emails base
  14. The list of leads in the extension will be cleared

Scrape email addresses for those leads

  1. Open Command Prompt (press Win + R, type cmd, press Enter)
  2. Navigate to the script folder by copying and pasting the below command into the Command Prompt, then pressing Enter: cd C:\MCC_scraper\Scrape_email
  3. Run the script by copying and pasting the below command into the Command Prompt, then pressing Enter: python scrape_emails.py
  4. Wait for the scraper to announce that it has finished. It will say something like this:

Manual check and handover

  1. Check all leads in the Is it a lead? view of the ‘Leads scraped from Google Maps’ table to ensure that all data looks good (especially names and email addresses, as these are critical to the email campaign).
  2. Notify Glenn that the leads are ready for qualification