This n8n workflow is designed to streamline and enhance cold email outreach for marketing agencies and business owners by automating lead scraping, website content analysis, and personalized email generation. The process begins when the workflow is manually triggered, initializing the creation of a Google Spreadsheet to store leads and their generated icebreakers and subject lines. It then fetches target URLs and contact info from an external data source (like Apollo), filtering for complete entries. The workflow calls an Apify scraper API to collect up to 50,000 leads’ website URLs, and retrieves the scraped data while filtering out incomplete entries.

Next, the workflow crawls each website URL to extract HTML content, which is then converted into plain text for easier analysis. Summarization of the website’s content takes place via OpenAI’s GPT-4, producing concise descriptions that highlight the agency’s unique strengths and achievements.

Using another GPT-4 node, the system crafts personalized cold email icebreakers, making each message feel genuine and human-centered, tailored to the lead’s website content. Simultaneously, a subject line that complements the email is generated, ensuring a higher open rate.

All generated data—including website summaries, icebreakers, and subject lines—are stored in the Google Spreadsheet. This setup is ideal for marketing agencies seeking to automate lead outreach with hyper-personalized emails, saving time and increasing engagement.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.openAi, code, filter, googleSheets, httpRequest, manualTrigger, set, slack, splitInBatches, stickyNote