Generate Cold Email Dossiers
Scrape prospect websites to analyze business pain points, generate personalized cold emails with custom subject lines, and send the complete dossier to Slack.
Cold Email OutreachLead GenerationSlack IntegrationGoogle Sheets
Introduction
The Cold Email Dossier Generator creates personalized outreach drafts for enterprise sales. It fetches a target company's website, analyzes their business and potential pain points, and crafts tailored email content ready to be reviewed in Slack and logged in Google Sheets.
It performs these core actions:
- Accepts a list of target companies, contact names, and your product description.
- Scrapes and cleans the target website's text content.
- Uses an AI model to summarize the business, identify a specific pain point, and find a personalized hook.
- Passes these insights to another AI model that writes a short cold email with three subject line options.
- Sends the completed dossier message to a specified Slack channel.
- Logs the generated dossier and contact details into a Google Sheet for tracking.
Prerequisites
- A Needle platform account to run the workflow.
- A Slack workspace and a dedicated channel to receive the email dossiers.
- The Slack integration configured with the correct permissions.
- A Google account connected to Needle to write to Google Sheets.
- Access to Needle AI models for generating analyses and email copy.
How It Works
| Step | Component | Description |
|---|---|---|
| 1 | Manual Trigger | You start the flow by submitting an array of target details (URL, contact name, product description). |
| 2 | Unified Scraper | Fetches the company's website and removes HTML tags to extract clean text. Reports an error gracefully if the site blocks scraping. |
| 3 | AI Analyst | Reads the cleaned website text to generate a business summary, an assumed pain point your product solves, and a personalized hook. |
| 4 | Data Bridge | Parses and structures the AI outputs to ensure continuity of information for the next step. |
| 5 | AI Copywriter | Crafts a crisp, four-sentence cold email tailored to the contact, plus three distinct subject line options designed to improve open rates. |
| 6 | Final Merge | Combines all generated insights, email copy, and original contact data into a single formatted object. |
| 7 | Slack Delivery | Sends a formatted message to your configured Slack channel containing the complete dossier or an error alert if scraping failed. |
| 8 | Google Sheets Log | Upserts the dossier row into a tracking spreadsheet, using the target URL as the key to prevent duplicate entries. |
Expected Output
At the end of the run, you will receive a formatted Slack message and a new Google Sheets row featuring:
- A brief business summary and identified pain point.
- A personalized hook to open your email.
- A four-sentence cold email draft ready to send.
- Three subject line options to choose from.
- Clear error alerts if website scraping fails.
Important Notes
- Website scraping may fail if the site has strong bot protection. The workflow handles this gracefully by skipping the AI steps and alerting you in Slack.
- Review the AI-generated email content before sending to ensure it fits your voice and compliance needs.
- Provide clear and precise product descriptions to get the most accurate and compelling email copy.
- You must configure the Slack node with your specific channel ID.
- Create a Google Sheet named "AE Dossier Log" before running the workflow so the Google Sheets node can successfully locate and update it.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
