Library / Lead Generation & Enrichment
Lead Generation & Enrichment
Draft outreach emails from Google Sheets leads with OpenAI and Apify
Reads approved leads and source notes from Google Sheets, writes personalized email drafts with OpenAI, and queues them with validation issues for human review. Runs on manual trigger.
What it does
## Create personalized email drafts from sourced Google Sheets leads with OpenAI Turn approved Google Sheets leads and sourced research into personalized English email drafts with OpenAI. Store drafts, source links and validation issues in a separate review queue. Built for small businesses and consultants preparing outreach for human approval. ### How it works Read Leads and Drafts, validate contact permission and unique IDs, skip completed drafts, and limit eligible leads. Use supplied source_notes with a matching source_url, or optional public LinkedIn/X posts. OpenAI returns a structured draft; validation checks its format and evidence IDs. Upsert results by lead_id. No email is sent. ### Setup 1. Import and execute the default credential-free demo. 2. Create Leads and Drafts tabs with the headers shown on the canvas. Set spreadsheet ID, tab names and seller details in Prepare Settings. 3. Connect Google Sheets OAuth2 to all three Sheets nodes and your OpenAI credential to Generate email draft with OpenAI. 4. Set mode=provided. Add one synthetic test lead with status=new, contact_allowed=TRUE, source_notes and a source_url matching its declared profile. Execute and inspect Drafts. ### Requirements and customization Standard nodes; Google Sheets and funded OpenAI access for live drafting. Adjust offer, model and run limit. Optional social mode needs paid Apify/X credentials; instructions are on the canvas. Sheets/OpenAI were live tested on n8n 2.28.6; social providers were simulated. Cloud/local compatible; actual Cloud execution untested. Run one execution at a time. API/hosting costs apply. Review facts and sources: evidence-ID checks cannot prove factual accuracy.
The steps
- Manual Trigger
- Prepare Settings
- Check Demo Mode
- Load Demo Leads
- Read Leads from Sheets
- Read Drafts from Sheets
- Build Lead Queue
- Process Each Lead
- Summarize Execution
- Check Lead Readiness
- Check Social Mode
- Normalize Research Data
- Setup Social Context
- Check LinkedIn Requirement
33 steps in total.
Similar automations
Lead Generation & EnrichmentRun Advanced Prospect Outreach and Nurturing Campaigns with AI25 stepsLead Generation & EnrichmentFind Leads with Apify and Email Them with OpenAI13 stepsLead Generation & EnrichmentGenerate hiring-signal outreach lines from career pages with Apify, GPT-4 and Slack18 stepsLead Generation & EnrichmentScrape Google Maps Leads and Write Outreach with AI21 steps