sales-data-extraction-agent

Monitor directories for Excel sales files and extract MTD, YTD, and Year End metrics into PostgreSQL.

Updated Mar 16, 2026

Search Tags:#automation #postgresql #data pipeline #reporting #sales data #excel extraction

Ready to run

npx skills add https://github.com/Likas07/t3code-skills --skill sales-data-extraction-agent-likas07

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sales-data-extraction-agent
Source: https://github.com/Likas07/t3code-skills/tree/main/skills/sales-data-extraction-agent
Command: npx skills add https://github.com/Likas07/t3code-skills --skill sales-data-extraction-agent-likas07

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the extraction of critical sales metrics from Excel files, streamlining live reporting and data analysis.

Core Features & Use Cases

Real-time Monitoring: Watches directories for new or updated Excel sales reports.
Flexible Data Extraction: Parses various Excel formats, extracting MTD, YTD, and Year End metrics.
Data Persistence: Safely stores extracted data in PostgreSQL with a full audit trail.
Use Case: Automatically process daily sales reports from multiple regions, ensuring accurate and up-to-date figures for executive dashboards.

Quick Start

Process the Excel file located at /path/to/latest_sales_report.xlsx.

Frequently Asked Questions about sales-data-extraction-agent

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I automate extracting sales data from Excel files into PostgreSQL?▼

You can automate extracting sales data from Excel files into PostgreSQL by running a script that monitors directories for new spreadsheets, parses metrics like MTD and YTD, and persists the normalized records with an audit trail.

What is directory monitoring for Excel sales report extraction?▼

Directory monitoring for Excel sales report extraction is an automated process that watches specific folders for new or updated spreadsheets and immediately parses them to extract key revenue, units, and deals metrics without manual intervention.

How do I calculate quota attainment and Year End projections from Excel sales reports?▼

To calculate quota attainment and Year End projections from Excel sales reports, you can use a flexible column mapping script that identifies revenue and deal data to automatically compute and normalize these metrics for storage.

Can I extract MTD and YTD metrics from Excel files with varying column structures?▼

Yes, you can extract MTD and YTD metrics from Excel files with varying column structures because the extraction process uses flexible column mapping to identify revenue, units, and deals data across different spreadsheet formats.

What is the best way to maintain an audit trail when loading Excel sales data into a database?▼

The best way to maintain an audit trail when loading Excel sales data is to use a data pipeline that normalizes extracted metrics and persists them into PostgreSQL with built-in tracking for all processed records.

Do I need PostgreSQL to process Excel files for sales reporting automation?▼

Yes, you need PostgreSQL to store the normalized sales data because the extraction pipeline is specifically designed to persist MTD, YTD, and Year End metrics into a PostgreSQL database with a full audit trail.