Extract Sales Leads from Google Jobs, LinkedIn & Indeed with GPT-4o and Apify

This n8n workflow automates the process of extracting sales leads from job postings on Google Jobs, LinkedIn, and Indeed. It leverages Apify for web scraping, GPT-4o for intelligent data extraction and enrichment, and then routes the refined leads to either Google Sheets, Slack, or Gmail for further action.

The workflow is designed to streamline lead generation for sales teams, recruiters, or anyone looking to identify potential clients or partners based on hiring needs.

What it does

1. Triggers Manually: The workflow is currently set up for manual execution, allowing you to initiate the lead extraction process on demand.
2. Scrapes Job Postings (Apify - Implicit): Although not explicitly present in the provided JSON, the workflow's name suggests it integrates with Apify for scraping job postings from Google Jobs, LinkedIn, and Indeed. The output of this scraping would then be fed into the subsequent nodes.
3. Processes with AI Agent: An "AI Agent" (likely a LangChain agent) is used to process the scraped job data. This agent probably orchestrates calls to language models and tools to extract relevant sales lead information.
4. Extracts Structured Data: A "Structured Output Parser" (LangChain) is employed to ensure the AI agent's output is consistently formatted, likely into a JSON structure containing key lead details.
5. Enriches with OpenAI Chat Model: An "OpenAI Chat Model" (GPT-4o, as per the directory name) is utilized, likely for tasks such as:
   • Identifying key decision-makers or relevant roles.
   • Inferring company details or industry.
   • Summarizing job requirements for lead qualification.
   • Generating personalized outreach messages.
6. Edits/Sets Fields: A "Set" node is used to transform or refine the data structure, ensuring all extracted lead information is in a consistent and usable format.
7. Conditional Routing: An "If" node evaluates the processed leads, likely based on criteria such as lead quality, completeness, or specific keywords.
8. Merges Data: A "Merge" node is present, suggesting that different branches of the workflow (e.g., successful extraction vs. partial extraction) might be combined before final output.
9. Sends to Google Sheets: Qualified leads can be automatically added to a Google Sheet for centralized tracking and management.
10. Notifies via Slack: Alerts or summaries of new leads can be sent to a designated Slack channel, keeping the team informed in real-time.
11. Sends Emails via Gmail: The workflow can send personalized emails, potentially for outreach or internal notifications, based on the extracted leads.
12. Executes Custom Code: A "Code" node allows for custom JavaScript logic, which could be used for advanced data manipulation, validation, or integration with other services.
13. Sticky Note for Documentation: A "Sticky Note" is included for internal documentation or comments within the workflow.

Prerequisites/Requirements

• n8n Instance: A running instance of n8n.
• Apify Account: (Implicit) An Apify account with access to relevant job scraping actors.
• OpenAI API Key: For the "OpenAI Chat Model" node (GPT-4o).
• Google Account: With access to Google Sheets, for the "Google Sheets" and "Gmail" nodes.
• Slack Account: For the "Slack" node.
• n8n Credentials: Configured credentials for OpenAI, Google (OAuth), and Slack within your n8n instance.

Setup/Usage

1. Import the Workflow: Download the workflow JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your OpenAI API key credential.
   • Configure Google OAuth credentials for Google Sheets and Gmail.
   • Set up your Slack API token credential.
3. Customize Apify Integration (Implicit): If the Apify integration is not fully defined in the JSON, you will need to add and configure the Apify node to scrape the desired job platforms (Google Jobs, LinkedIn, Indeed) with your specific search queries.
4. Adjust AI Agent and Output Parser: Review the configuration of the "AI Agent" and "Structured Output Parser" nodes. You may need to refine the prompts or schema definitions to optimize lead extraction for your specific needs.
5. Configure "Edit Fields" (Set) Node: Adjust the "Edit Fields" node to map and transform the extracted data into your desired output structure.
6. Define "If" Node Conditions: Customize the conditions in the "If" node to filter leads based on your qualification criteria.
7. Configure Output Nodes:
   • Google Sheets: Specify the Spreadsheet ID and Sheet Name where leads should be added.
   • Slack: Define the channel and message content for Slack notifications.
   • Gmail: Configure recipient, subject, and body for email notifications.
8. Review Custom Code (if present): If the "Code" node contains custom logic, ensure it aligns with your requirements.
9. Activate the Workflow: Once configured, activate the workflow.
10. Execute Manually: Since it's a manual trigger, click "Execute Workflow" to run it and begin extracting leads. For automated runs, consider replacing the manual trigger with a "Schedule Trigger" or "Webhook" node.