Skip to content

README.md

Latest commit

 

History

History
120 lines (82 loc) · 4.2 KB

README.md

File metadata and controls

120 lines (82 loc) · 4.2 KB

Python Automation Agent

A demonstration project showcasing an automation agent workflow for data collection tasks. The agent reads data from a spreadsheet, performs web searches for each row, and outputs the results—ideal for lead research, contact enrichment, or batch lookup operations.

Workflow: Spreadsheet → Agent → Web Search → Result

What is an Automation Agent?

An automation agent is a program that performs a sequence of tasks autonomously, typically:

  1. Reading input from a source (files, databases, APIs)
  2. Processing each item according to defined rules
  3. Executing actions (e.g., web searches, API calls, data transformations)
  4. Outputting results (console, files, or other systems)

This project implements a simple but realistic agent that automates the workflow of looking up information for each row in a spreadsheet—a common pattern in data collection and research automation.

Project Workflow

┌─────────────────┐     ┌─────────────────┐     ┌─────────────────┐     ┌─────────────────┐
│   data.xlsx     │ ──► │  agent.py       │ ──► │  web_search.py  │ ──► │  Console Output │
│   (Spreadsheet) │     │  (Orchestrator) │     │  (HTTP Request) │     │  (Results)      │
└─────────────────┘     └─────────────────┘     └─────────────────┘     └─────────────────┘
  1. Spreadsheet – data.xlsx contains rows with id, name, company, city, website, and status.
  2. Agent – agent.py reads each row, builds a search query from name and company, and coordinates the workflow.
  3. Web Search – web_search.py performs HTTP requests to a search API for each query.
  4. Result – Results are printed to the console with summaries and related information.

Technologies Used

Technology Purpose
Python Core language for the automation logic
pandas Reading and processing Excel spreadsheets
openpyxl Excel file support for pandas
requests HTTP requests for web search API calls

Project Structure

python-automation-agent/
├── agent.py              # Main orchestrator - runs the workflow
├── spreadsheet_reader.py # Reads Excel data with pandas
├── web_search.py         # Performs web searches via requests
├── data.xlsx             # Sample spreadsheet (10 rows)
├── create_sample_data.py # Script to regenerate data.xlsx
├── requirements.txt     # Python dependencies
└── README.md            # This file

Quick Start

1. Install Dependencies

pip install -r requirements.txt

2. Create Sample Data (if needed)

If data.xlsx doesn't exist, generate it:

python create_sample_data.py

3. Run the Agent

python agent.py

Example Output

============================================================
  PYTHON AUTOMATION AGENT - Data Collection Workflow
============================================================

[1] Reading spreadsheet: data.xlsx
  Found 10 rows to process.

[2] Processing rows (spreadsheet -> agent -> web search -> result)
------------------------------------------------------------

Row 1 (id=1): Sarah Chen @ TechFlow Solutions
  Search query: "Sarah Chen TechFlow Solutions"
  Summary: ...
  URL: ...

Use Case

This project serves as an example automation agent for data collection tasks, such as:

  • Lead research – Look up companies and contacts from a CRM export
  • Contact enrichment – Add public information to spreadsheet records
  • Batch verification – Validate company names and get summaries
  • Portfolio demo – Showcase Python, pandas, and requests in a clear workflow

License

MIT License - feel free to use and modify for your projects.