Building a Sales Contact Aggregator with GibsonAI and Crew AI

In this example, we'll create a sales contact aggregator agent using GibsonAI for database management and Crew AI for multi-agent workflows. This solution automatically finds and stores sales contacts, saving you valuable prospecting time.

Step 1: Create the Database with GibsonAI

1. In GibsonAI, define your database schema by specifying the required tables:

   • Sales Contact table with fields: Company ID, name, title, LinkedIn URL, phone, email

   • Sales Company table

2. Review the generated SQL code to confirm it matches your requirements.

3. Deploy the database to make it available via API.

4. Copy your API key from the Settings section for later use.

Step 2: Set Up the Crew AI Agent

1. Import the Crew AI library in your Python environment.

2. Create two key components:

   • Contact Finder: A Crew AI agent that searches for contacts

   • Contact Poster: A tool that posts data to your GibsonAI database

3. Define search parameters in your tasks file (e.g., target company "Workday").

4. Configure the agent with your API keys and specific instructions.

Step 3: Run the Automated Workflow

1. Execute your Python script to initiate the agent.

2. The agent will:

   • Follow your instructions to find relevant contacts

   • Search public data sources including LinkedIn

   • Structure the gathered data according to your database schema

   • Automatically post the data to your GibsonAI database

3. Verify results by checking your database (e.g., via Postman) to confirm the contacts were successfully added.

This integration demonstrates how agentic workflows with Crew AI can automate sales prospecting tasks while using GibsonAI as a robust backend database solution.