Kütüphane / Potansiyel Müşteri Yaratma ve Zenginleştirme
Potansiyel Müşteri Yaratma ve Zenginleştirme
OpenAI ve Apify ile Google Sheets potansiyel müşterileri için e-posta taslakları oluştur
Google Sheets'teki onaylı potansiyel müşteri ve kaynak notlarını okur, OpenAI ile kişiselleştirilmiş e-posta taslakları yazar ve doğrulama sorunları olanları insan incelemesi için kuyruğa alır. Manuel tetikleyiciyle çalışır.
Ne yapar
## 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.
Adımlar
- 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
Toplam 33 adım.
Benzer otomasyonlar
Sosyal Medya YayıncılığıGoogle Sheets'ten Twitter ve Instagram'a Otomatik Paylaşım8 adımSosyal Medya YayıncılığıFirecrawl ile haber toplayıp X'te paylaşma5 adımSosyal Medya YayıncılığıHTTP İstekleriyle Twitter Bannerını Güncelle4 adımİzleme, Operasyon ve OlaylarŞirketinizin Yeni Twitter Bahsetmelerini Slack'e Gönderme7 adım