Библиотека / Генерация и обогащение лидов
Генерация и обогащение лидов
Создание черновиков писем для холодных рассылок из лидов Google Sheets с помощью OpenAI и Apify
Читает одобренных лидов и заметки об источниках из Google Sheets, пишет персонализированные черновики писем с помощью OpenAI и ставит их в очередь вместе с проблемами валидации на ручную проверку. Запускается вручную.
Что делает
## 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.
Шаги
- 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.
Похожие автоматизации
Поддержка клиентов и служба помощиОтветы на вопросы поддержки в Telegram с Gemini и SupabaseШагов: 13Чат-боты и боты для мессенджеровИИ-агент по продажам для Bitrix24 с Gemini и SupabaseШагов: 54Публикации в соцсетяхАвтопубликация из Google Sheets в Twitter и InstagramШагов: 8Публикации в соцсетяхСбор новостей через Firecrawl и публикация в XШагов: 5