Перейти к содержанию
НОВОЕМаркетплейс и ваша команда: продавайте то, что создали, и получайте планы и изменения, проверенные до того, как вы их увидите. Что нового

Библиотека / Генерация и обогащение лидов

Генерация и обогащение лидов

Создание черновиков писем для холодных рассылок из лидов 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.

Шаги

  1. Manual Trigger
  2. Prepare Settings
  3. Check Demo Mode
  4. Load Demo Leads
  5. Read Leads from Sheets
  6. Read Drafts from Sheets
  7. Build Lead Queue
  8. Process Each Lead
  9. Summarize Execution
  10. Check Lead Readiness
  11. Check Social Mode
  12. Normalize Research Data
  13. Setup Social Context
  14. Check LinkedIn Requirement

Всего шагов: 33.

Похожие автоматизации