Skip to content

About

Transform Apollo prospect lists into campaign-ready outreach using n8n, AI, and modern GTM workflows.

Topics

Resources

Stars

1 star

Watchers

0 watching

Forks

Latest commit

 

History

3 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🚀 CampaignPilot – AI-Powered GTM Decision Engine

CampaignPilot Workflow


OpenAI n8n Google Sheets Apollo


Overview

CampaignPilot is an AI-powered GTM (Go-To-Market) decision engine that helps sales teams evaluate target accounts before outreach.

The workflow combines campaign criteria with company data, uses an LLM to qualify accounts, generates structured GTM insights, and automatically updates Google Sheets with lead scores, recommendations, and outreach readiness.

The project demonstrates how no-code automation, AI, and structured workflows can reduce manual prospect qualification while keeping the process scalable and cost-efficient.


Problem

Outbound teams often spend hours manually reviewing company lists before starting outreach.

Typical challenges include:

  • Manual account qualification
  • Inconsistent lead scoring
  • Generic prioritization
  • Time-consuming spreadsheet work
  • Repeated evaluation of the same accounts

CampaignPilot automates this qualification process using AI.


Solution

CampaignPilot processes company records through an automated workflow that:

  • Reads campaign configuration
  • Imports company data
  • Evaluates each account against an ICP
  • Assigns AI lead scores
  • Generates qualification reasoning
  • Classifies outreach readiness
  • Updates the database automatically
  • Skips companies that have already been processed

Features

✅ AI Account Qualification

Evaluate companies against predefined ICP criteria.


✅ AI Lead Scoring

Generate a structured score representing account quality.


✅ GTM Decision Engine

Produce actionable recommendations including:

  • Qualification
  • Strengths
  • Risks
  • Recommended action

✅ Google Sheets Integration

Automatically update enriched company records.


✅ Batch Processing

Process multiple companies within a single workflow execution.


✅ Cost Optimization

Previously processed companies are automatically skipped to reduce API usage.


Workflow

Pipeline Overview

    flowchart LR
    A[Apollo / Google Sheets] --> B[Campaign Config]
    B --> C[Raw Import]
    C --> D{AI Score empty?}
    D -- Yes --> E[Prepare GTM Context]
    E --> F[AI Agent]
    F --> G[Add AI Data in Sheets]
    G --> H[Update Status]
    H --> I[Update row in sheet]
    D -- No --> J[Skip processed row]
Loading

Technology Stack

Category Tools
Automation n8n
AI OpenAI GPT
Database Google Sheets
Prospecting Apollo
Data Format JSON
Workflow JavaScript

Google Sheets Database

Campaign Configuration

Stores campaign goals, ICP, filters, keywords and targeting rules.


Raw Import

Contains imported company records together with AI-generated enrichment.


Accounts Pipeline

Displays qualified companies ready for outbound workflows.


Dashboard

The dashboard provides a high-level operational view of campaign performance, qualification metrics, and workflow health.


Results

The current implementation successfully demonstrates:

  • Processed 50 SaaS companies
  • Automated AI qualification
  • Automated lead scoring
  • Structured GTM recommendations
  • Google Sheets synchronization
  • Duplicate prevention
  • Batch workflow execution
  • Cost-optimized processing using conditional execution

Repository Structure

CampaignPilot/

├── assets/
├── docs/
├── n8n/
├── prompts/
├── sample-data/
└── README.md

Future Improvements

Future versions may include:

  • Contact enrichment
  • CRM integrations
  • Instantly export automation
  • HeyReach export automation
  • Multi-campaign management
  • Dashboard analytics
  • Automated email generation
  • LinkedIn personalization

Lessons Learned

This project helped me explore practical GTM Engineering concepts including:

  • AI workflow orchestration
  • Prompt engineering
  • Automation design
  • Conditional workflow optimization
  • Batch processing
  • AI-powered lead qualification
  • Google Sheets as an operational database
  • Workflow documentation

Author

Mohil Wankar 💎

Linktree: https://linktr.ee/mohil.wankar

If you found this project interesting, star with repo and feel free to connect or explore my profile.

About

Transform Apollo prospect lists into campaign-ready outreach using n8n, AI, and modern GTM workflows.

Topics

Resources

Stars

1 star

Watchers

0 watching

Forks

Contributors