Find and Qualify Funded Leads with BrowserAct & Gemini

This n8n workflow automates the process of identifying and qualifying funded leads by leveraging AI agents and external tools, then notifying a Slack channel for review. It streamlines lead generation by extracting key information from a Google Sheet, enriching it using an AI agent (powered by Google Gemini), and filtering based on specific criteria.

What it does

1. Triggers Manually: The workflow starts when manually executed.
2. Reads Leads from Google Sheets: It fetches a list of potential leads from a specified Google Sheet.
3. Processes Leads in Batches: Each lead is processed individually or in small batches to manage API calls and processing time.
4. Qualifies Leads with AI Agent:
   • An AI Agent (configured for Google Gemini) receives the lead information.
   • It uses a "BrowserAct" tool (implied by the directory name, though not explicitly defined as a node in the JSON, it's a common tool used with Langchain agents for web browsing/data extraction) to browse and gather additional information about the company.
   • It then uses a "Search" tool (also implied, common for general knowledge retrieval) to find more details.
   • The AI Agent then outputs structured data about the lead, including its funding status.
5. Parses AI Agent Output: A Structured Output Parser extracts the relevant information (e.g., funding, company details) from the AI Agent's response.
6. Filters Qualified Leads: An "If" node checks if the lead meets specific qualification criteria (e.g., if it's funded).
7. Notifies Slack for Qualified Leads: If a lead is qualified, a message containing the lead's details is sent to a designated Slack channel for further action.
8. Merges Workflow Paths: Both qualified and unqualified lead paths eventually merge, allowing for potential subsequent actions or logging.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: With a spreadsheet containing your lead data.
• Google Gemini API Key: For the AI Agent to function.
• Slack Account: To receive notifications for qualified leads.
• BrowserAct Tool: While not an explicit n8n node in the JSON, the workflow's purpose and directory name suggest the use of a BrowserAct tool (likely configured within the AI Agent node's tools section) for web interaction.
• Search Tool: Similar to BrowserAct, a search tool (e.g., Google Search API, SerpAPI) is likely configured within the AI Agent node.

Setup/Usage

1. Import the workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Google Sheets: Set up your Google Sheets OAuth2 or API Key credential.
   • Google Gemini: Configure your Google Gemini API Key credential for the "Google Gemini Chat Model" node.
   • Slack: Set up your Slack API credential.
3. Update Google Sheets Node (ID: 18):
   • Specify the Spreadsheet ID and Sheet Name from which to read your leads.
4. Configure AI Agent Node (ID: 1119):
   • Ensure the "Google Gemini Chat Model" is selected as the Language Model.
   • Verify or configure the "BrowserAct" and "Search" tools within the agent's settings if they are not automatically set up.
   • Adjust the System Message and User Message to guide the AI Agent on how to find and qualify leads based on your specific criteria.
5. Configure Structured Output Parser Node (ID: 1179):
   • Ensure the schema or instructions for parsing the AI Agent's output match the expected JSON structure.
6. Update If Node (ID: 20):
   • Modify the conditions to filter leads based on your definition of "qualified" (e.g., {{ $json.fundingStatus === 'funded' }}).
7. Configure Slack Node (ID: 40):
   • Select the Channel where you want to receive notifications.
   • Customize the Message to include relevant lead details (e.g., company name, funding amount, website).
8. Activate and Execute: Save the workflow, activate it, and then click "Execute workflow" on the "Manual Trigger" node to run it.