Keep a lead list from directories fresh in Google Sheets

Say you sell packaging to food producers, and your state's food manufacturers' association lists its members online, a page per member. A bought list goes stale, and copying the directory by hand takes a day you'd rather spend calling.

Swap in your directory's link. Ask only for what its listings show: BrowseWiz writes what's on the page and doesn't look anyone up. If the directory is for members only, sign in to it in Chrome first.

BrowseWiz creates the sheet in your Google Drive, one row per company. The Listing column links each row to the page it came from, so you can check any phone number before you call.

1. 1

   Describe the list

   Name the directory, the columns and the sheet. Paste the request into the side panel.

2. 2

   Check and approve the plan

   BrowseWiz replies with a plan: how it pages through the directory, what it opens for each member and which columns it writes. Nothing runs until you approve. Then grant tab access and sign in to Google once when asked.

3. 3

   It reads the directory in your Chrome

   It opens the pages in the BrowseWiz Tabs group, using the sessions you already have, and never asks for your passwords. See how the browser agent works.

After the first run, send one more message: "Every Monday at 8:00, update this sheet from the directory. Add a row for each new member, with today's date in First seen. For members already in the sheet, update their website, city and phone in their row. Add a Status column, and write Not listed for members the directory no longer shows. Don't delete any rows." Approve the plan, and BrowseWiz saves it as a scheduled task without running it now. Each Monday after that:

1. 1

   New members get a row

   A company the sheet doesn't have yet gets a new row, with that Monday's date in First seen. Filter on the date to see this week's new leads.

2. 2

   Changed details are updated in place

   When a member's website, city or phone changes, the run writes the new value into that company's row. You keep one row per company, not a second copy.

3. 3

   Members that left are marked

   When a company drops out of the directory, its row stays, with Not listed in Status. You keep the history, and you know not to pitch a company that closed or left.

4. 4

   You hear when it's done

   Each run alerts you in Chrome when it finishes or fails, so a week that went wrong doesn't pass unnoticed.

• Hundreds of rows, not thousands. BrowseWiz reads the directory page by page in your Chrome, the way you would, so it fits a list you'd otherwise copy by hand. For thousands of companies, use a list vendor or a cloud scraping service.
• Only what the pages show. It writes what the listings display and finds no hidden emails. It doesn't guess addresses, look people up or add data from other sources.
• Chrome has to be open. Scheduled runs happen only while your computer is on and Chrome is open. This isn't a 24/7 service.
• The directory's terms apply. Many directories limit copying or reusing their listings, and some block automated visits. Read the terms before you schedule a run: you're responsible for following them.
• Named people's details are personal data. Data about a company isn't covered by the GDPR, but a person's name, work email or direct phone is, including at work ^{Source 1}. Privacy rules such as the GDPR apply to those details, so collect only what you need and check the rules where you and your leads are. This isn't legal advice.
• Check the first two scheduled runs. An AI model carries out each run from the approved plan, so results can vary. Make sure there's still one sheet, with one row per company.
• Layout changes and sign-ins. If the directory changes its layout or signs you out, a run can miss members or land on a sign-in page. The Listing link in each row lets you check any value.
• A sheet BrowseWiz creates. It writes the leads into a new sheet in your Google Drive, and each run updates that one.

Start on Free: it includes one scheduled task that runs up to once a day, one monitor and 10M credits a month. Credit use depends on how much page text each run reads, so opening every member's listing uses more than reading one long list.

• Free

  $0 / month

  • 1 scheduled task, up to once a day
  • 1 page monitor
  • 10M credits a month

• Pro

  $35 / month

  • Up to 10 scheduled tasks, up to once a day
  • Up to 30 page monitors
  • 250M credits a month

• Max

  $95 / month

  • Up to 10 scheduled tasks, up to once a day
  • Up to 30 page monitors
  • 1B credits a month

Prices include VAT. See how credits are counted.