Lead Generation Outreach Workflow for E2M
This project automates the process of fetching company leads, enriching them with online data, summarizing their websites, and generating personalized HTML outreach emails using AI.
Design and implement a fully automated workflow to:
- Fetch leads using the Apify API.
- Enrich and summarize company data.
- Generate contextually relevant, human-like HTML outreach emails.
- Store all results in Google Sheets for easy management.
- Fetch 100–500 leads using the Apify API.
- Import lead data automatically into a Google Sheet.
- Workflow triggers automatically on:
- New rows added.
- Existing rows updated.
Screenshot: Lead Data in Google Sheet
For each lead:
- Use domain from the data if available.
- Otherwise, extract domain from email or website.
- If domain is missing, log the issue in an Error Logs tab.
Screenshot: Error Logs Example
- Identify the base URL for each valid domain.
- Scrape textual content from the homepage.
- Generate a short business summary (2–3 sentences).
- Save the summary in the Google Sheet.
Screenshot: Business Summary in Sheet
- Use the lead data and summary to generate personalized outreach emails in HTML.
- Emails include:
- Human-like context.
- Proper headings, paragraphs, and buttons.
- Limited emojis for visual appeal.
- Store HTML content in the Google Sheet.
Screenshot: HTML Email Preview
- n8n: Automation tool.
- Apify API: Fetch leads.
- Google Sheets API: Store and manage leads.
- AI model (OpenAI or free alternative): Generate summaries and emails.
- HTML: Email formatting.
- Clone the repository:
git clone https://github.com/your-username/lead-generation-workflow.git
- Import the workflow JSON into n8n.
- Set up Google Sheets API credentials.
- Run the workflow or trigger by adding/updating leads.
- Check the Google Sheet for processed summaries and HTML emails.
Prins Ambaliya
GitHub: PrinsAmbaliya
LinkedIn: https://www.linkedin.com/in/prins-ambaliya-bb7546367