VendorSync Pro

Automates vendor price comparison and publishes a unified price matrix to Google Sheets.

Operations Automation Production Ready Python Google Drive API Google Sheets API Pandas
View on GitHub Adapt This to Your Needs β†’

What This Project Does

VendorSync Pro automates the entire vendor price comparison workflow. It downloads Excel and CSV files from a shared Google Drive folder, normalizes all product barcodes to a consistent format, merges everything into a single price matrix using an outer join, and publishes the result directly to Google Sheets β€” with the lowest price per product highlighted in green, automatically.

Adding a new vendor requires one new entry in config.json. No code changes. One command. Done in under 30 seconds.

See It in Action

Watch how VendorSync Pro downloads vendor files from Google Drive, normalizes barcodes, merges price data, and publishes the results to Google Sheets with automatic price highlighting.

3
Vendors
Merged in one run
5,000
Products
Across all vendors
Under 30 seconds
Processing Time
Drive to Sheets

Key Features

  • Any vendor format β€” Excel or CSV, any column names, mapped in config.json β€” no code changes
  • Barcode normalization β€” UPC (12-digit) and EAN (13-digit) both padded to GTIN-13, no duplicate rows
  • Scientific notation fix β€” Barcodes forced to string before any processing β€” 1.23E+11 never reaches your sheet
  • Outer join merge β€” A product that only one vendor carries still appears β€” missing data is information too
  • Green highlighting β€” Lowest price per product applied automatically on every run
  • Zero code to add a vendor β€” One new entry in config.json. That is it.

Real-World Applications

Daily Price Comparison
Automate the morning vendor price matrix across all your suppliers
Retail Buying
Identify the best price per product before placing orders
Inventory Visibility
Know which vendor carries which products β€” even if only one does
Scalable Sourcing
Add a new vendor with one config entry, no code changes

Want to Try It?

This tool is free and open-source. It runs locally on your computer and connects to your own Google Drive and Sheets β€” your data never touches any third-party server.

Two Ways to Use This Tool:

If you're a developer:

  1. Clone the repository from GitHub
  2. Install dependencies: pip install -r requirements.txt
  3. Copy the config: cp config.json.example config.json
  4. Add your Google credentials and vendor mappings to config.json
  5. Run: python3 main.py

If you're not a developer:

Don't worry about the technical setup. I can configure the tool for your specific vendor formats, connect it to your Google Drive and Sheets, and deliver a ready-to-use pipeline with clear instructions.

Let Me Handle It For You

How We'll Work Together

  1. Discovery β€” You walk me through your vendor formats and how you currently compare prices. I confirm whether this tool fits and give you an honest timeline and cost estimate. No commitment needed.
  2. Scope β€” I send you a written scope: what gets built, what gets tested, when it ships, and what it costs. You approve it or we adjust until it fits.
  3. Build β€” I configure the tool for your specific vendor column structures and Google environment. You get progress updates every 2 to 3 days. Nothing ships blind.
  4. Handoff β€” You test with real vendor files. I fix anything that does not work. Final payment on delivery. Seven days of support included.
  5. You run it independently β€” The tool is yours. You have the script, the documentation, and the logic. No dependency on me to keep it running.
Email Me Back to Projects