Generate Personalized Cold Email Icebreakers with GPT-4 Mini

This n8n workflow automates the creation of highly personalized cold email icebreakers using a list of LinkedIn profiles from Google Sheets and the power of GPT-4 Mini via the Apify platform. It helps sales and outreach teams scale their personalization efforts, making cold emails more effective and increasing response rates.

What it does

1. Triggers Manually: The workflow is initiated manually, allowing you to control when the icebreaker generation process begins.
2. Reads LinkedIn Profiles: It fetches a list of LinkedIn profile URLs from a specified Google Sheet.
3. Filters Empty Rows: Ensures that only rows containing a LinkedIn profile URL are processed, skipping any empty entries.
4. Loops Through Profiles: Processes each valid LinkedIn profile URL individually.
5. Extracts LinkedIn Data (via Apify): For each LinkedIn profile, it makes an HTTP request to the Apify platform to scrape public information. This step is configured to use the apify/linkedin-profile-scraper actor.
6. Generates Icebreaker with OpenAI (GPT-4 Mini): Using the scraped LinkedIn data, it sends a prompt to OpenAI (likely GPT-4 Mini, given the context) to generate a personalized cold email icebreaker.
7. Aggregates Results: Collects all generated icebreakers and their corresponding LinkedIn data.
8. Updates Google Sheet: Writes the generated icebreakers back to the original Google Sheet, associating them with their respective LinkedIn profiles.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: A Google Sheets spreadsheet containing a column with LinkedIn profile URLs.
• Apify Account: An Apify account with access to the apify/linkedin-profile-scraper actor and an API key.
• OpenAI Account: An OpenAI account with API access (specifically for GPT-4 Mini, if that's the model being used).

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON workflow definition.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON.
2. Configure Credentials:
   • Google Sheets: Set up a Google Sheets credential to allow n8n to read from and write to your spreadsheet.
   • HTTP Request (Apify):
     • The HTTP Request node will need to be configured with your Apify API key. This is typically passed as a query parameter or header.
     • Ensure the URL for the Apify actor is correct and includes your Apify API key.
   • OpenAI: Set up an OpenAI credential with your API key.
3. Update Google Sheet Node:
   • In the "Google Sheets" node, specify the "Spreadsheet ID" and "Sheet Name" where your LinkedIn profile URLs are located.
   • Ensure the column containing LinkedIn URLs is correctly referenced.
   • Configure the "Update Google Sheet" node to write the generated icebreakers to the desired column in your sheet.
4. Review Apify HTTP Request:
   • Verify the "HTTP Request" node targeting Apify is correctly configured with the apify/linkedin-profile-scraper actor ID and any necessary input parameters (e.g., profileUrls).
5. Review OpenAI Node:
   • Check the "OpenAI" node to ensure the prompt for generating icebreakers is tailored to your needs. It should reference the data obtained from the LinkedIn scraper (e.g., {{ $json.profileData.name }}, {{ $json.profileData.currentJobTitle }}, etc.).
   • Confirm the model used (e.g., gpt-4-mini or similar) and other parameters like temperature.
6. Activate the Workflow: Once configured, activate the workflow.
7. Execute Manually: Click "Execute Workflow" on the "Manual Trigger" node to run the workflow.