Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Lead Generation & Enrichment

Lead Generation & Enrichment

Extract and rank business contacts from websites with Apify and OpenAI

Runs daily to crawl listed sites via Apify for public emails, phones and social links, scores contact quality, adds OpenAI fit ratings, and saves ranked leads to Sheets.

What it does

## Extract and rank business contacts from websites with Apify, OpenAI and Google Sheets Crawls the home, contact and about pages of the sites you list through Apify and collects public business emails, phone numbers and social links. ### How it works 1. A daily schedule (or the manual trigger) loads Config; a Monday schedule sends a 7-day report instead. 2. Runs the Apify actor website-contact-extractor and downloads the results. 3. Drops incomplete rows and anything already seen in the last 30 days. 4. Score contact quality gives a 0-100 rule score; an OpenAI model adds a fit score, verdict and summary. 5. Upserts every row to the Contacts sheet tab. Hot rows go to Slack for approval, warm rows to an email digest. ### Setup steps - [ ] Add an Apify HTTP Header Auth credential (Authorization: Bearer ) on the 3 Apify HTTP nodes. - [ ] Create a Google Sheet with the columns in *Upsert to Google Sheets* and paste its ID into googleSheetId. - [ ] Connect OpenAI, Slack and Gmail; set slackChannelId and digestEmail in Config. - [ ] In Config set actorInput.startUrls (one object with a url per site), maxPagesPerSite, then freeMailDomains and preferNamedEmails. Feed the list from a sheet or CRM by replacing the Config value with an expression. - [ ] Describe your ideal result in aiCriteria, run once manually, then activate. ### Customization - Change the weights in Score contact quality (email 30, named email 20, phone 15, same-domain 10, socials 10). - Raise hotScore (60) or warmScore (35) to send fewer alerts. - Needs an Apify account; actor runs use your Apify credits.

The steps

  1. Daily schedule
  2. Run manually
  3. Weekly report schedule
  4. Config
  5. Daily run or weekly report?
  6. Start Apify run
  7. Wait before polling
  8. Get run status
  9. Check run status
  10. Route by run status
  11. Stop: Apify run failed
  12. Fetch dataset items
  13. Validate and dedupe
  14. Any new records?

35 steps in total.

Similar automations