# Qualify leads and send personalized outreach with OpenAI, Outlook and Sheets

> Quick overview This workflow runs daily to read leads from Google Sheets, research company websites, score and qualify them with OpenAI, and draft or send personalized initial and follow-up emails via Gmail while writing statuses, scores, drafts, and send results back to Google Sheets. How it works 1. Runs every day on a schedule and loads configuration values (sheet, thresholds, limits, email copy, and dry-run mode). 2. Reads lead rows from Google Sheets, normalizes emails, suppresses opt-outs/duplicates, and routes each row to either initial outreach or follow-up eligibility checks. 3. For new leads, fetches the company website via HTTP, extracts usable text, and sends it to OpenAI to produce a grounded company analysis with a 0–100 fit score. 4. Updates the lead row in Google Sheets with the analysis, evidence quotes, score breakdown, and a QUALIFIED/UNQUALIFIED (or error) status. 5. For qualified new leads, asks OpenAI to draft a personalized first-contact email, validates it, and 

- **Domain**: `n8n-workflow-20098.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20098
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20098.n8n.io
- Documentation: https://n8n.io/workflows/20098