Bibliothek / Lead-Generierung & Anreicherung
Lead-Generierung & Anreicherung
Geschäftskontakte von Websites mit Apify und OpenAI extrahieren und einstufen
Läuft täglich, durchsucht gelistete Websites über Apify nach öffentlichen E-Mail-Adressen, Telefonnummern und Social-Media-Links, bewertet die Kontaktqualität, ergänzt OpenAI-Passungsbewertungen und speichert die eingestuften Leads in Sheets.
Was sie bewirkt
## 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.
Die Schritte
- Daily schedule
- Run manually
- Weekly report schedule
- Config
- Daily run or weekly report?
- Start Apify run
- Wait before polling
- Get run status
- Check run status
- Route by run status
- Stop: Apify run failed
- Fetch dataset items
- Validate and dedupe
- Any new records?
Insgesamt 35 Schritte.
Ähnliche Automatisierungen
Monitoring, Betrieb & StörungenKunden-Websites wöchentlich mit Apify, Google Sheets und SMTP-E-Mail prüfen7 SchritteLead-Generierung & AnreicherungLokale Unternehmen ohne Website mit Apify finden und Leads in Google Sheets speichern14 SchritteLead-Generierung & AnreicherungGoogle-Maps-Unternehmen und Kontakte mit Apify und Firecrawl scrapen14 SchritteLead-Generierung & AnreicherungUnternehmensdaten von Websites mit OpenAI anreichern11 Schritte