I built a Python automation script to read diamond inventory from an Excel file, sends queries to the Nivoda API for market prices, and writes the price and price per carat back into the Excel file.

🔍 What It Does

Reads Excel inventory file
Sends a GraphQL query to the Nivoda API for each row
Retrieves PricePerCarat and Price
Writes those back into the same Excel file

Perfect for quick price audits, sourcing decisions, and reducing manual work.

💻 Tech Stack

Python
openpyxl
requests
GraphQL
Excel Automation

📦 Input Format

Columns: B (Shape), D (Weight), E (Color), F (Clarity)
Output Columns: N (Price/ct), O (Total Price)

🧠 Code Highlights

Authenticated API token via headers
GraphQL query built dynamically per row
Excel updated live with new pricing

🔗 GitHub

👉 nivoda-excel-fetcher

⚡ Results

✅ Transformed hours of manual filtering
✅ Accurate live pricing from Nivoda
✅ Reusable and easily extended

👨‍💻 About Me

I’m a Data Analyst at Sheetal Manufacturing Co.
Currently pursuing MSc in Data Science from Symbiosis.

🔗 Connect with me on LinkedIn

🙌 Let’s Collaborate

If you liked this, feel free to:

Fork the repo
Suggest improvements
Drop a comment — I’d love to connect with fellow automation nerds 😄

Nivoda + Python + Excel: Automating Market Price Fetching