Collect Leads From Websites Into a Spreadsheet, and Keep Every Row Current

Collect Leads From Websites Into a Spreadsheet, and Keep Every Row Current

Tom
Tom

To get leads from websites into a spreadsheet, write the columns first, give every row a link to the page it came from, and have a tool reread those pages on a schedule so the sheet updates itself. The reading method matters less than people expect. A lead list is worth what its stalest row is worth, so plan the second run before you start the first.

Table of Contents

Mistakes That Turn a Lead Sheet Into Dead Weight

A one-time export feels finished the moment it lands. You pull every exhibitor from a trade directory, sort by region and start calling. Weeks later a share of the contact names have moved on, and nothing in the sheet tells you which ones. Store the source URL and a "last checked" date on every row, so any row can be reread instead of guessed at.

Reading the logged-out version of a page is the second trap. Member directories, supplier portals and association lists often show a company name to everyone and the contact person, phone and email only to signed-in members. Anything that requests the page on its own, without your session, collects the shell. Open one source page in a private window and compare it with what you see when signed in. If the two differ, your method has to read the signed-in view.

Keep what the page says apart from what you decided about it. When "fit score", "owner" or "called on" share columns with collected fields, a refresh either overwrites your work or never runs because nobody dares to start it. Put qualification notes in a separate sheet keyed on the company website, and let the collected sheet stay a pure record of the pages.

Building a separate scraper for each site multiplies the upkeep. Every site gets its own selectors, the CSS paths that point at the name or email on the page, and each one breaks on its own timetable when the site redesigns. The failure is silent: the scraper returns nothing new, the sheet keeps the last good rows and looks healthy. Describe the rows in plain words across sites instead of encoding where each field sits.

Why Scraped Lead Lists Go Stale and Break

Lead details live on pages written for people. A contact name sits in a card, the email hides behind a "show contact" button, and the full list runs across paginated screens. Anything that copies the page as a table misses most of what matters.

Formula-based refresh is tied to an open document. A lead list gets opened when someone needs to call, so the formula refreshes on the sales rep's schedule rather than the market's.

Selectors encode layout, and sites change layout for their own reasons. A directory that adds a filter bar or moves the phone number into a tab has broken every rule written against the old version, with no warning sent to you.

Rechecking has no owner. Copying is a task someone does once, at a campaign kickoff.

Signs Your Lead List Has Already Started to Fail

  • You cannot click from a row to the page that row came from.
  • No column shows when each row was last confirmed against its source.
  • Contact fields are blank for companies whose contacts you can see when signed in.
  • Your scraper reports success, but the row count stopped growing.
  • Two colleagues each keep their own copy of the list and correct it by hand.
  • The next update depends on someone remembering to do it.

Weigh these by what fixes them. A missing source link or date column is a design gap you close on the next pull. Blank signed-in fields and a frozen row count mean the collection method itself cannot reach the data, and no amount of cleanup will change that. A lead list refreshed weekly in Google Sheets avoids both problems from the start.

Building a Lead Sheet That Rereads Its Own Sources

  1. Write the columns before you open any site: company, website, contact name, role, email or contact page, city, source link and date checked.
  2. List the pages to read, such as a directory's search results and each company's contact page, and sign in to the ones that need it in Chrome.
  3. Describe the rows in one message, for example: "Open the exhibitor list on the association site where I'm signed in, and for each company add a row with name, website, contact name, role, email, city, a link to the page it came from and today's date. Then visit each company's contact page and fill in any missing email."
  4. Open five source links from the first run and compare each row with its page before you trust the rest.
  5. Ask for a weekly refresh, decide whether rows update in place or new companies arrive as new rows, and ask for a Previous column if you want to see which contacts changed.
  6. Set a monitor on the one change you would act on, such as a new company appearing in the directory.
  7. Pull files separately when a portal offers them. BrowseWiz can download files from the portal, such as statements and invoices, and log each file name, size and status in a Google Sheet. Downloads require granting the downloads permission, so allow it when asked.

Choosing Between a Formula, a One-Off Pull and a Scheduled Run

If your sources are public pages with clean tables and you only need the list while someone has the sheet open, a formula is enough. Read up on what IMPORTXML can reach before you build on it, because the moment a field hides behind a click or a sign-in, the formula returns blanks.

If you need the list once, for one event, a one-off pull is fine. Treat it as a snapshot: date it, and do not build a quarter of outreach on it.

If the list has to keep building, or the useful fields sit behind your sign-in, you want a scheduled run in your own browser. The same reasoning holds when you keep a spreadsheet of listings updated every week, and our guide to price tracking walks the identical choice for signed-in supplier prices. The trade-off is that your computer has to be on, with Chrome open, at the scheduled time. If your laptop is closed every Monday morning, set the run for an hour when it is open.

Where BrowseWiz Fits Into a Weekly Lead Refresh

BrowseWiz runs as an extension in your own Chrome, using the browser session you're signed into, with no cookie export or stored passwords. You describe the rows in plain words, with no selectors or scrapers to build or fix. One plain-language message can cover several sites instead of a robot per site.

BrowseWiz writes the rows into a new Google Sheet in your Drive, and when you ask for a source column, every row links back to the page it came from. Scheduled refreshes update rows in place and can keep the old value in its own column when you ask for one. Scheduled sheet updates run up to once a day, at the time you set, so a weekly lead list is well inside the limit.

Two limits shape the setup. Scheduled refreshes and monitors run only while Chrome is open. If a site signs you out, you must sign in again in Chrome. Once that sheet runs, the same pattern carries over to price tracking on the suppliers you buy from.

If your leads sit behind sign-ins on several sites and you want the weekly run set up for a team, tell us about your sources. Plans are on the pricing page.

Frequently Asked Questions

Can I pull data from a website into Excel?

Yes, and a typical request appears on Microsoft's Q&A forum, where a user wanted the "Latest matches" table from a single WhoScored player page pulled into an Excel spreadsheet. One public table on one page is the easy case. Lead collection rarely looks like that: the fields sit in cards across many pages and sites, some behind a sign-in. Choose your destination by how often the data must be rechecked, rather than by which program opens the file.

Is it illegal to scrape data from a website?

It depends on what you collect, how you reach it and where you and the people on your list are. Reading public business details at a human pace differs from bulk-copying personal contact data or getting around a login you were never given. Read each site's terms before you schedule anything. When the list holds personal data, such as named individuals and their emails, check the privacy rules where you operate with a qualified lawyer before you send outreach. Reading pages in your own signed-in session keeps you to data you are already allowed to see.

How do I scrape data from a website into Google Sheets?

For a public page with a clean table, the import formulas are the quickest start. For leads across several sites, or pages you sign into, describe the rows to BrowseWiz in Chrome and it writes them into a new Google Sheet in your Drive. Save that description as a Promptbook prompt with fill-in variables, such as the city or the directory address. The next region's list then becomes one edited prompt instead of a fresh setup, and every regional sheet keeps the same columns.

How can I scrape data from a website into Excel?

Collect where the scheduling lives and move the result. BrowseWiz writes to Google Sheets. Let the scheduled run keep that sheet current, and copy the rows into Excel when someone needs them there, rather than maintaining a second scraper aimed at a local workbook. Treat each Excel copy as a snapshot labelled with the date you took it, and send corrections back to the source pages, never into the copy, so the next refresh does not undo them.

Tom's avatar

About Tom

I'm a software engineer and solutions architect specializing in AI-driven tools and productivity software, passionate about helping users reclaim their valuable time through intelligent automation.