This n8n workflow qualifies leads and sends personalized outreach emails using OpenAI and Gmail. It reads leads from Google Sheets and runs automatically every day on a schedule. Settings such as the Google Sheet, scoring thresholds, limits, email copy and dry-run mode are loaded at the start of each run.
The workflow cleans each lead row by normalizing emails and suppressing opt-outs and duplicates. For new leads, it fetches the company website, extracts the text and sends it to OpenAI. OpenAI returns a company analysis with a 0–100 fit score. The analysis, evidence quotes, score breakdown and a QUALIFIED, UNQUALIFIED or error status are written back to the sheet.
For qualified new leads, OpenAI drafts a first-contact email, which is validated before it goes out. In dry-run mode it saves an OUTREACH_PREVIEW. Otherwise it reserves the row and sends the email through Gmail. Gmail message and thread IDs, timestamps and follow-up due dates are recorded in the sheet. Uncertain send outcomes are flagged SEND_REVIEW.
- Platform
- n8n workflow
- Schedule
- Runs daily
- Integrations
- Schedule Trigger, Google Sheets, HTTP Request, OpenAI, Gmail, plus logic nodes such as if and code
- Lead source
- Google Sheets
- Scoring
- 0–100 fit score from company website analysis, with evidence quotes and score breakdown
- Statuses
- QUALIFIED, UNQUALIFIED, error, OUTREACH_PREVIEW, FOLLOWUP_PREVIEW, SEND_REVIEW
- Outreach
- OpenAI-drafted first-contact email and single follow-up, sent via Gmail
- Dry-run mode
- Saves previews of outreach and follow-ups instead of sending
- Tracking
- Gmail message and thread IDs, timestamps and follow-up due dates written to Google Sheets
- List hygiene
- Normalizes emails, suppresses opt-outs and duplicates
- Reply detection
- Reads the original Gmail thread before sending a follow-up