dev-muthama/kenya-sales-agent

The agent operates in a serverless fashion using GitHub Actions for scheduling and execution. Data is stored centrally in a Google Sheet, which acts as a simple, free database. # Automated AI Sales Agent for Kenya This repository contains a fully automated, free-stack Python agent that finds mid-tier Kenyan company prospects and scans for cybersecurity tenders. It runs on a schedule using GitHub Actions and stores data in a Google Sheet. ## Features - **Prospect Finder**: Scrapes business directories to find mid-tier companies (50-500 employees). - **Tender Scanner**: Scans `tenders.go.ke` and other sources for cybersecurity RFPs. - **Enrichment**: Attempts to find company websites, decision-makers, and verify emails. - **Automation**: Runs every 6 hours via GitHub Actions. - **Notifications**: Sends an email summary with new findings and a CSV attachment. - **Free Stack**: Uses Python, GitHub Actions, and Google Sheets (all free tiers). ## Quick Start: Operational Checklist Follow these steps to deploy the agent: ### 1. Set Up the Google Sheet 1. **Create Sheet**: Go to sheets.google.com and create a new spreadsheet. Name it `Kenya_Sales_Agent_DB`. 2. **Create Tabs**: Create two tabs (worksheets) at the bottom named exactly `Prospects` and `Tenders`. 3. **Add Headers**: Copy the column headers from the Data Schema section above into the first row of each respective sheet. 4. **Get URL**: Copy the URL of your Google Sheet and paste it into the `GSHEET_URL` variable in `main.py`. ### 2. Configure Google Cloud & Service Account This agent needs API access to your Google Sheet. 1. **Enable APIs**: Go to the Google Cloud Console. - Create a new project (e.g., "Sales Agent Project"). - Go to "APIs & Services" -> "Library". - Search for and **enable** the **Google Drive API** and the **Google Sheets API**. 2. **Create Service Account**: - Go to "APIs & Services" -> "Credentials". - Click "Create Credentials" -> "Service account". - Give it a name (e.g., `sheets-editor`) and click "Create and Continue". - Grant it the **Editor** role. - Click "Done". 3. **Generate JSON Key**: - Find your new service account on the Credentials page …